1. Tables and Views for Project Management
  2. PJF_PROJECTS_ALL_XFACE

PJF_PROJECTS_ALL_XFACE

PJF_PROJECTS_ALL_XFACE table is used to import projects from an external application into Oracle Fusion Project Financial Management. The Import Projects process validates and imports data from the interface table to Oracle Fusion Project Financial Management transaction tables.

Details

  • Schema: FUSION

  • Object owner: PJF

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PJF_PROJECTS_ALL_XFACE_PK

XFACE_REC_ID

Columns

Name Datatype Length Precision Not-null Comments Status
XFACE_REC_ID NUMBER 18 Yes Unique identifier of the project in the interface table. Active
SOURCE_APPLICATION_CODE VARCHAR2 30 The third-party application from which the project originates. The application code must be defined in the Source Application lookup type. If a value is not entered, the source application code is set to OPEN_INTERFACE. Active
SOURCE_PROJECT_REFERENCE VARCHAR2 25 The identifier of the project in the external system where it was originally entered. Active
SOURCE_TEMPLATE_NUMBER VARCHAR2 25 Number of the project template used to create the current project. Active
PROJECT_NAME VARCHAR2 240 Yes Name of the project to be imported. A value is required. Active
PROJECT_NUMBER VARCHAR2 25 Number of the project to be imported. This value is required if project numbering is not automatic. Active
ORGANIZATION_NAME VARCHAR2 240 Organization that owns the project. Organizations can be departments, sections, divisions, companies, or other units. Active
LEGAL_ENTITY_NAME VARCHAR2 240 Legal entity that owns the project. A recognized party with given rights and responsibilities by legislation. Active
DESCRIPTION VARCHAR2 2000 A description about the project. This might include high-level information about the work being performed. Active
PROJECT_MANAGER_NUMBER VARCHAR2 30 Number of the person who leads the project team and who has authority and responsibility for meeting project objectives. This project manager overrides the project manager copied from the template. The project manager number takes precedence over the project manager name and E-Mail. Active
PROJECT_MANAGER_NAME VARCHAR2 360 Name of the person who leads the project team and who has authority and responsibility for meeting project objectives. The value must match the format of the list name, which is last name followed by a comma, space, and first name. This project manager overrides the project manager copied from the template. This value is not used if the project manager number is entered. The project manager name takes precedence over the project manager E-Mail. Active
PROJECT_MANAGER_EMAIL VARCHAR2 360 E-Mail address of the person who leads the project team and who has authority and responsibility for meeting project objectives. This project manager overrides the project manager copied from the template. This value is not used if the project manager number or name is entered. Active
PROJECT_START_DATE DATE The date that work or information tracking begins on a project. The date format is YYYY/MM/DD. Active
PROJECT_FINISH_DATE DATE The date that work or information tracking completes for a project. The date format is YYYY/MM/DD. Active
CLOSED_DATE DATE The date that the project status was set to closed. No further action can be taken on closed projects. The date format is YYYY/MM/DD. Active
PROJECT_STATUS_NAME VARCHAR2 80 An implementation-defined classification of the status of a project. Typical project status names are Active and Closed. Active
PROJECT_PRIORITY_CODE VARCHAR2 30 The importance of a project based on a predefined scale. The code must be defined in the Project Priority lookup type. Examples include HIGH, MEDIUM, and LOW. Active
OUTLINE_DISPLAY_LEVEL NUMBER 18 The level to which the project plan is expanded by default when you navigate to the project plan. For example, if the value is 3, the project plan is expanded to 3 levels. If the value is 0, the project is collapsed. Active
PLANNING_PROJECT_FLAG VARCHAR2 1 Indicates the project is used to plan and schedule tasks and resources on those tasks. Valid values are Y and N. Active
SERVICE_TYPE_CODE VARCHAR2 30 A classification of the service or activity associated with the project. The code must be defined in the Service Type lookup type. Active
WORK_TYPE_NAME VARCHAR2 240 A classification of the work associated with a project or task.. You can use work types to categorize and group projects for processing purposes. Active
PROJECT_CURRENCY_CODE VARCHAR2 15 The three-letter ISO currency code of the project to which the transaction is charged. Active
CURRENCY_CONV_DATE_TYPE_CODE VARCHAR2 30 Dates that can be used when converting amounts to the project currency. Valid values are: A - Accounting Date P - Project Accounting Date T - Transaction Date F - Fixed Date" Active
CURRENCY_CONV_RATE_TYPE VARCHAR2 15 The source of a currency conversion rate, such as user defined, spot, or corporate. In this case, the rate determines how to convert an amount from one currency to the project currency. Active
CURRENCY_CONV_DATE DATE The date used to obtain currency conversion rates when converting an amount to the project currency. This date is used when the currency conversion date type is Fixed Date. The date format is YYYY/MM/DD. Active
BURDEN_SCHEDULE_NAME VARCHAR2 30 Default set of overhead cost multipliers for the project. Active
BURDEN_SCH_FIXED_DATED DATE A specific date used to determine the right set of burden multipliers for the project. The date format is YYYY/MM/DD. Active
KPI_NOTIFICATION_ENABLED VARCHAR2 5 Indicates that workflow notifications are sent after KPI values are generated. Valid values are Y and N. Active
KPI_NOTIFICATION_INCLUDE_NOTES VARCHAR2 5 Indicates that notes about the KPI are included on the KPI generation notification report. Valid values are Y and N. Active
KPI_NOTIFICATION_RECIPIENTS VARCHAR2 30 Indicates that workflow notifications are sent to the project manager after KPI values are generated. Valid values are Y and N. Active
CINT_ELIGIBLE_FLAG VARCHAR2 1 Indicates the project is enabled for capitalization of interest amounts. Valid values are Y and N. Active
CINT_RATE_SCH_NAME VARCHAR2 30 The rate schedule used to calculate the capitalized interest. Active
CINT_STOP_DATE DATE The date where capitalized interest will stop accruing. The date format is YYYY/MM/DD. Active
ASSET_ALLOCATION_METHOD_CODE VARCHAR2 30 Method by which unassigned asset lines and common costs are allocated across multiple assets. Valid code values are: AU - Actual units CC - Current cost EC - Estimated cost SC - Standard unit cost SE - Spread evenly CE - Client extension N - None Active
CAPITAL_EVENT_PROCESSING_CODE VARCHAR2 30 Name of the method for processing events on projects of this project type if capitalization is enabled. Valid code values: M - Manual P - Periodic N - None" Active
ALLOW_CROSS_CHARGE_FLAG VARCHAR2 1 An option at the project and task level to indicate if transaction charges are allowed from all provider business units to the project or task. Valid values are Y and N. Active
CC_PROCESS_LABOR_FLAG VARCHAR2 1 Indicates that the project will allow processing of cross-charge transactions between business units for labor transactions. Valid values are Y and N. Active
LABOR_TP_SCHEDULE_NAME VARCHAR2 50 Name of the transfer price schedule that associates transfer price rules with pairs of provider and receiver organizations for labor transactions. Active
LABOR_TP_FIXED_DATE DATE A specific date used to determine a price on a transfer price schedule for labor transactions. The date format is YYYY/MM/DD. Active
CC_PROCESS_NL_FLAG VARCHAR2 1 Indicates that the project will allow processing of cross-charge transactions between business units for nonlabor transactions. Valid values are Y and N. Active
NL_TP_SCHEDULE_NAME VARCHAR2 50 Name of the transfer price schedule that associates transfer price rules with pairs of provider and receiver organizations for nonlabor transactions. Active
NL_TP_FIXED_DATE DATE A specific date used to determine a price on a transfer price schedule for nonlabor transactions. The date format is YYYY/MM/DD. Active
LIMIT_TO_TXN_CONTROLS_CODE VARCHAR2 30 Type of transaction controls, inclusive or exclusive, defined for the selected project or task. Valid code values are: Y - Inclusive N - Exclusive Active
COPY_TASKS_FLAG VARCHAR2 1 Indicates whether project tasks are copied from the project template to the new project. Valid values are Y and N. If the value is Y, tasks in the open interface file are not loaded. The default value is N. Active
COPY_TASK_ATTACHMENTS_FLAG VARCHAR2 1 Indicates whether task attachments are copied from the project template when tasks are copied. Valid values are Y and N. The default value is N. Active
COPY_TASK_DFF_FLAG VARCHAR2 1 Indicates whether task descriptive flexfields are copied from the project template when tasks are copied. Valid values are Y and N. The default value is N. Active
COPY_TASK_ASSIGNMENTS_FLAG VARCHAR2 1 Indicates whether task attachments are copied from the project template when tasks are copied. Valid values are Y and N. The default value is N. Active
COPY_TEAM_MEMBERS_FLAG VARCHAR2 1 Indicates whether project team members are copied from the originating project template to the new project. A project team member is a person who is assigned a role on a project. Valid values are Y and N. The default value is N. Active
COPY_PROJECT_CLASSES_FLAG VARCHAR2 1 Indicates whether project classifications should be copied from the originating project template to the new project. Valid values are Y and N. The default value is N.
COPY_ASSETS_FLAG VARCHAR2 1 Indicates whether assets are copied from the project template to the new project. Valid values are Y and N. The default value is N. Active
COPY_ASSET_ASSIGNMENTS_FLAG VARCHAR2 1 Indicates whether asset assignments are copied from the project template to the new project. Valid values are Y and N. The default value is N. Active
COPY_TRANSACTION_CONTROLS_FLAG VARCHAR2 1 Indicates whether transaction controls are copied from the project template to the new project. Valid values are Y and N. If the value is Y, transaction controls in the open interface file are not loaded. The default value is N. Active
COPY_GROUP_SPACE_FLAG VARCHAR2 1 Indicates whether the project space template is copied from the originating template to the project. Valid values are Y and N. The default value is N. Active
COPY_DFF_FLAG VARCHAR2 1 Indicates whether descriptive flexfields are copied from the project template to the new project. Valid values are Y and N. The default value is N. Active
COPY_ATTACHMENTS_FLAG VARCHAR2 1 Indicates whether attachments are copied from the project template to the new project. Valid values are Y and N. The default value is N. Active
COPY_COST_OVERRIDES_FLAG VARCHAR2 1 Indicates whether costing overrides are copied from the project template to the new project. Valid values are Y and N. The default value is N. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
LOAD_REQUEST_ID NUMBER 18 Request ID of the ESS job that loads the interface tables. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
LOAD_STATUS VARCHAR2 10 Status of the project that is transferred from the CSV file to the interface table. Valid values are ON HOLD and COMPLETE. Active
IMPORT_STATUS VARCHAR2 10 Status of the project that is transferred from the interface table to Oracle Fusion Project Foundation. Valid values are PROCESSING, ERROR, and SUCCESS. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
ORG_ID NUMBER 18 Indicates the identifier of the business unit associated to the row. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE30 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE31 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE32 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE33 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE34 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE35 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE36 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE37 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE38 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE39 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE40 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE41 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE42 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE43 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE44 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE45 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE46 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE47 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE48 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE49 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE50 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE1_DATE DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2_DATE DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3_DATE DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4_DATE DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5_DATE DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6_DATE DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7_DATE DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8_DATE DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9_DATE DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10_DATE DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11_DATE DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12_DATE DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13_DATE DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14_DATE DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15_DATE DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE1_NUMBER NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2_NUMBER NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3_NUMBER NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4_NUMBER NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5_NUMBER NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6_NUMBER NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7_NUMBER NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8_NUMBER NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9_NUMBER NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10_NUMBER NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11_NUMBER NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12_NUMBER NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13_NUMBER NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14_NUMBER NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15_NUMBER NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
SCHEDULE_NAME VARCHAR2 200 Name of the calendar used for planning the project.
EPS_NAME VARCHAR2 200 Name of Enterprise structure node associated to the project.
PROJECT_PLAN_VIEW_ACCESS VARCHAR2 30 Project View Accessor
SCHEDULE_TYPE VARCHAR2 30 Type of Schedule
OPPORTUNITY_ID NUMBER 18 Identifier of the opportunity in the opportunity management application.
OPPORTUNITY_NUMBER VARCHAR2 240 Opportunity Number.
OPPORTUNITY_CUSTOMER_NUMBER VARCHAR2 240 Public Identifier of the customer in the opportunity management application.
OPPORTUNITY_CUSTOMER_ID NUMBER 18 Identifier of the customer in the opportunity management application.
OPPORTUNITY_AMT NUMBER Total amount of a customer deal in the opportunity management application.
OPPORTUNITY_CURRCODE VARCHAR2 15 Currency code of the deal amount of the opportunity in the opportunity management application.
OPPORTUNITY_WIN_CONF_PERCENT NUMBER Percentage probability of winning an opportunity in the opportunity management application.
OPPORTUNITY_NAME VARCHAR2 240 Name of the opportunity associated to the project.
OPPORTUNITY_DESC VARCHAR2 1000 Description of the opportunity associated to the project.
OPPORTUNITY_CUSTOMER_NAME VARCHAR2 900 Name of the customer with whom the deal is made for the opportunity.
OPPORTUNITY_STATUS VARCHAR2 240 Status of the opportunity in the opportunity management application.
PRJ_PLAN_BASELINE_NAME VARCHAR2 100 Name of the project plan baseline.
PRJ_PLAN_BASELINE_DESC VARCHAR2 1000 Description of the project plan baseline.
PRJ_PLAN_BASELINE_DATE DATE Date when project plan was baselined.
BUDGETARY_CONTROL_FLAG VARCHAR2 1 Budgetary Control Flag: Indicates whether transactions on the project will undergo funds checking
SOURCE_TEMPLATE_NAME VARCHAR2 240 Name of the project template used to create the current project.

Indexes

Index Uniqueness Tablespace Columns Status
PJF_PROJECTS_ALL_XFACE_N1 Non Unique FUSION_TS_TX_DATA PROJECT_NAME, LOAD_STATUS, IMPORT_STATUS Active
PJF_PROJECTS_ALL_XFACE_PK Unique FUSION_TS_TX_DATA XFACE_REC_ID Active