PJC_TXN_XFACE_STAGE_ALL
PJC_TXN_XFACE_STAGE_ALL is the table you use for importing third party transactions with containing name and / or ID for all attributes like project, task, expenditure type, organization, person, supplier, inventory, etc. Name to ID conversion will happen and these transactions will be populated into PJC_TXN_XFACE_ALL for one-stop processing.
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJC_TXN_XFACE_STAGE_ALL_PK |
TXN_INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| INTERFACE_ID | NUMBER | 18 | System-generated number that identifies all the transactions processed by a given concurrent request | ||
| TXN_INTERFACE_ID | NUMBER | 18 | Yes | System generated identifier that uniquely identifies a imported transaction | |
| TRANSACTION_STATUS_CODE | VARCHAR2 | 2 | System-defined status of the transaction as it is loaded into PA | ||
| BUSINESS_UNIT | VARCHAR2 | 240 | Indicates business unit associated to the row. | ||
| ORG_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | ||
| USER_TRANSACTION_SOURCE | VARCHAR2 | 240 | The descriptive name of the transaction source | ||
| TRANSACTION_SOURCE_ID | NUMBER | 18 | Identifier of the Transaction Source. ***** | ||
| DOCUMENT_NAME | VARCHAR2 | 240 | Projects-related categorization of the document type that is creating this transaction. ***** | ||
| DOCUMENT_ID | NUMBER | 18 | Identifier for the Projects-related categorization of the document type that is creating this transaction. ***** | ||
| DOC_ENTRY_NAME | VARCHAR2 | 240 | Name of the Document Entry. ***** | ||
| DOC_ENTRY_ID | NUMBER | 18 | Identifier of Projects-related categorization of the document type that is creating this transaction. ***** | ||
| BATCH_NAME | VARCHAR2 | 200 | User-entered name for a grouping of expenditures in the interface table.For one transaction source, all items with the same BATCH_NAME areimported into Oracle Projects in the same expenditure group, if processed together. | ||
| BATCH_ENDING_DATE | DATE | BATCH_ENDING_DATE ***** | |||
| BATCH_DESCRIPTION | VARCHAR2 | 250 | BATCH_DESCRIPTION ***** | ||
| PROJECT_NUMBER | VARCHAR2 | 25 | Project Number | ||
| PROJECT_NAME | VARCHAR2 | 240 | Project Name | ||
| PROJECT_ID | NUMBER | 18 | Project Identifier | ||
| TASK_NUMBER | VARCHAR2 | 100 | Number of the task. | ||
| TASK_NAME | VARCHAR2 | 255 | Name of the task. | ||
| TASK_ID | NUMBER | 18 | Identifier for the task. | ||
| EXPENDITURE_ITEM_DATE | DATE | Date on which the transaction occurred | |||
| PERSON_NUMBER | VARCHAR2 | 30 | Number assigned to the person, to identify the person uniquely in any context, not dependent on being an employee, contingent worker, etc. | ||
| PERSON_NAME | VARCHAR2 | 2000 | Name of the person. | ||
| PERSON_ID | NUMBER | 18 | Identifier of the person. | ||
| HCM_ASSIGNMENT_NAME | VARCHAR2 | 80 | Assignment Number | ||
| HCM_ASSIGNMENT_ID | NUMBER | 18 | The HCM assignment for which the transaction was created. ***** | ||
| EXPENDITURE_TYPE | VARCHAR2 | 240 | Expenditure Type Name | ||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Identifier of the Expenditure Type. ***** | ||
| ORGANIZATION_NAME | VARCHAR2 | 240 | Expenditure Organization | ||
| ORGANIZATION_ID | NUMBER | 18 | Organization Identifier | ||
| CONTRACT_NUMBER | VARCHAR2 | 120 | The contract number defined by user | ||
| CONTRACT_NAME | VARCHAR2 | 300 | The contract name derived from user | ||
| CONTRACT_ID | NUMBER | 18 | The unique contract identifier created by our system | ||
| FUNDING_SOURCE_NUMBER | VARCHAR2 | 50 | The funding source number defined by user | ||
| FUNDING_SOURCE_NAME | VARCHAR2 | 240 | The funding source name derived from user | ||
| NON_LABOR_RESOURCE | VARCHAR2 | 240 | Non Labor Resource | ||
| NON_LABOR_RESOURCE_ID | NUMBER | 18 | Identifier of the Non-labor resource utilized when incurring the transaction charge. ***** | ||
| NON_LABOR_RESOURCE_ORG | VARCHAR2 | 240 | NON_LABOR_RESOURCE_ORG ****** | ||
| NON_LABOR_RESOURCE_ORG_ID | NUMBER | 18 | Non-Labor Resource Organization Identifier | ||
| QUANTITY | NUMBER | Number of units for the transaction. This column is defined with a precision of 2 in order to maintain consistency with PAs expenditure entry forms which round expenditure item quantities to 2 decimal places when saved to the database | |||
| UNIT_OF_MEASURE_NAME | VARCHAR2 | 80 | UNIT_OF_MEASURE_NAME | ||
| UNIT_OF_MEASURE | VARCHAR2 | 30 | Base unit of measure | ||
| WORK_TYPE | VARCHAR2 | 240 | WORK_TYPE | ||
| WORK_TYPE_ID | NUMBER | 18 | Work Type Identifier | ||
| BILLABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if the item can accrue revenue | ||
| CAPITALIZABLE_FLAG | VARCHAR2 | 1 | Flag that indicates if a project-related item is eligible for capitalization. ***** | ||
| ACCRUAL_FLAG | VARCHAR2 | 1 | Indicates whether the imported transaction is automatically reversed in the next accounting period. | ||
| SUPPLIER_NUMBER | VARCHAR2 | 30 | Supplier Number ***** | ||
| SUPPLIER_NAME | VARCHAR2 | 360 | The supplier name of the scm transaction | ||
| VENDOR_ID | NUMBER | 18 | Vendor Identifier | ||
| INVENTORY_ITEM_NAME | VARCHAR2 | 300 | Inventory Item ****** | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item identifier | ||
| ORIG_TRANSACTION_REFERENCE | VARCHAR2 | 120 | Yes | User-entered value used to identify the transaction in an external system from which the imported item originated. | |
| UNMATCHED_NEGATIVE_TXN_FLAG | VARCHAR2 | 1 | Flag used to identify certain adjustments (transactions with negative quantities) as summary-level adjustments for which there is no single matching item in PA to reverse. When this flag is Y, PA does not execute the matching value | ||
| REVERSED_ORIG_TXN_REFERENCE | VARCHAR2 | 120 | Value used to identify the transaction being reversed in the external system from which the imported item originated | ||
| EXPENDITURE_COMMENT | VARCHAR2 | 240 | User-entered free text comment to describe the transaction | ||
| GL_DATE | DATE | GL_DATE to be copied to PA_COST_DISTRIBUTION_LINES.GL_DATE for transactions that are accounted for in external systems as specified by the GL_ACCOUNTED_FLAG flag on the transaction source. This date is used to derive the PA_DATE on CDLs. | |||
| DENOM_CURRENCY_CODE | VARCHAR2 | 15 | Transaction currency code of the transaction | ||
| DENOM_CURRENCY | VARCHAR2 | 80 | Transaction currency code of the transaction | ||
| DENOM_RAW_COST | NUMBER | Raw cost in Transaction currency | |||
| DENOM_BURDENED_COST | NUMBER | Burdened cost in Transaction currency | |||
| RAW_COST_CR_CCID | NUMBER | 18 | RAW_COST_CR_CCID ***** | ||
| RAW_COST_CR_ACCOUNT | VARCHAR2 | 2000 | Raw Cost Credit Account String | ||
| RAW_COST_DR_CCID | NUMBER | 18 | RAW_COST_DR_CCID ***** | ||
| RAW_COST_DR_ACCOUNT | VARCHAR2 | 2000 | Raw Cost Debit Account String | ||
| BURDENED_COST_CR_CCID | NUMBER | 18 | BURDENED_COST_CR_CCID ***** | ||
| BURDENED_COST_CR_ACCOUNT | VARCHAR2 | 2000 | Burdened Cost Credit Account String | ||
| BURDENED_COST_DR_CCID | NUMBER | 18 | BURDENED_COST_DR_CCID ***** | ||
| BURDENED_COST_DR_ACCOUNT | VARCHAR2 | 2000 | Burdened Cost Debit Account String | ||
| BURDEN_COST_CR_CCID | NUMBER | 18 | BURDEN_COST_CR_CCID ***** | ||
| BURDEN_COST_CR_ACCOUNT | VARCHAR2 | 2000 | Burden Cost Credit Account String | ||
| BURDEN_COST_DR_CCID | NUMBER | 18 | BURDEN_COST_DR_CCID ***** | ||
| BURDEN_COST_DR_ACCOUNT | VARCHAR2 | 2000 | Burden Cost Debit Account String | ||
| ACCT_CURRENCY_CODE | VARCHAR2 | 15 | Functional Currency Code. ***** | ||
| ACCT_CURRENCY | VARCHAR2 | 80 | Functional Currency Code. ***** | ||
| ACCT_RATE_DATE | DATE | Functional conversion rate date for the transaction | |||
| ACCT_RATE_TYPE | VARCHAR2 | 30 | Functional conversion rate type for the transaction | ||
| ACCT_RATE_DATE_TYPE | VARCHAR2 | 4 | Provider Ledger Currency Conversion Date Type ***** | ||
| ACCT_EXCHANGE_RATE | NUMBER | Functional exchange rate for the transaction | |||
| ACCT_RAW_COST | NUMBER | Raw cost in functional currency | |||
| ACCT_BURDENED_COST | NUMBER | Burdened cost in Functional currency | |||
| ACCT_EXCHANGE_ROUNDING_LIMIT | NUMBER | Rounding limit for imported transactions | |||
| RECEIPT_CURRENCY_AMOUNT | NUMBER | Receipt currency amount of the transaction | |||
| RECEIPT_CURRENCY_CODE | VARCHAR2 | 15 | Receipt currency code of the transaction | ||
| RECEIPT_CURRENCY | VARCHAR2 | 80 | Receipt currency code of the transaction | ||
| RECEIPT_EXCHANGE_RATE | NUMBER | Receipt exchange rate for the transaction | |||
| CONVERTED_FLAG | VARCHAR2 | 1 | Flag that indicates if the transaction is converted from legacy applications and should be marked as converted. Transactions marked as converted have restrictions around what type of adjustments can be performed on them. ***** | ||
| USER_DEF_ATTRIBUTE1 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE1 ***** | ||
| USER_DEF_ATTRIBUTE2 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE2 ***** | ||
| USER_DEF_ATTRIBUTE3 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE3 ***** | ||
| USER_DEF_ATTRIBUTE4 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE4 ***** | ||
| USER_DEF_ATTRIBUTE5 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE5 ***** | ||
| USER_DEF_ATTRIBUTE6 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE6 ***** | ||
| USER_DEF_ATTRIBUTE7 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE7 ***** | ||
| USER_DEF_ATTRIBUTE8 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE8 ***** | ||
| USER_DEF_ATTRIBUTE9 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE9 ***** | ||
| USER_DEF_ATTRIBUTE10 | VARCHAR2 | 150 | USER_DEF_ATTRIBUTE10 ***** | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| CONTEXT_CATEGORY | VARCHAR2 | 40 | Segment used to identify the descriptive flexfield application context for project-related standardized cost collection. ***** | ||
| RESERVED_ATTRIBUTE1 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | ||
| RESERVED_ATTRIBUTE2 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | ||
| RESERVED_ATTRIBUTE3 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | ||
| RESERVED_ATTRIBUTE4 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | ||
| RESERVED_ATTRIBUTE5 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | ||
| RESERVED_ATTRIBUTE6 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | ||
| RESERVED_ATTRIBUTE7 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | ||
| RESERVED_ATTRIBUTE8 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | ||
| RESERVED_ATTRIBUTE9 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | ||
| RESERVED_ATTRIBUTE10 | VARCHAR2 | 150 | Reserved for Projects - future functionality ***** | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| 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. | |
| LOAD_REQUEST_ID | NUMBER | 18 | Yes | Load Request ID to be populated by parent ESS job. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| TRANSACTION_TYPE | VARCHAR2 | 30 | Value used to describe the type of transaction. | ||
| PROJECT_ROLE_ID | NUMBER | 18 | Unique id of the project role associated with the project cost transaction. | ||
| PROJECT_ROLE_NAME | VARCHAR2 | 240 | Name of the project role associated with the project cost transaction. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJC_TXN_XFACE_STAGE_ALL_N1 | Non Unique | Default | TRANSACTION_STATUS_CODE, BATCH_NAME |
| PJC_TXN_XFACE_STAGE_ALL_U1 | Unique | Default | TXN_INTERFACE_ID |