PJC_TXN_XFACE_CTRL_ALL
PA_TRANSACTION_XFACE_CTRL_ALL is used internally by the Transaction Import program to control processing of pending transactions in the interface table by multiple concurrent requests. One record is inserted into PA_TRANSACTION_XFACE_CTRL_ALL for each unique transaction_source/batch_name record inserted into PA_TRANSACTION_INTERFACE_ALL. Each request for the Transaction Import process locks the unprocessed records in the PA_TRANSACTION_XFACE_CTRL_ALL table that meet the request's selection criteria thereby preventing other requests from attempting to import the same transactions. . .
Details
-
Schema: FUSION
-
Object owner: PJC
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
PJC_TXN_XFACE_CTRL_ALL_PK |
TXN_XFACE_CTRL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TXN_XFACE_CTRL_ID | NUMBER | 18 | Yes | TXN_XFACE_CTRL_ID ***** | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| TRANSACTION_SOURCE_ID | NUMBER | 18 | TRANSACTION_SOURCE_ID ***** | ||
| DOCUMENT_ID | NUMBER | 18 | DOCUMENT_ID ***** | ||
| BATCH_ENDING_DATE | DATE | BATCH_ENDING_DATE ***** | |||
| ACCRUAL_BATCH_FLAG | VARCHAR2 | 20 | ACCRUAL_BATCH_FLAG ***** | ||
| BATCH_NAME | VARCHAR2 | 200 | Yes | Batch name being processed | |
| BATCH_STATUS | VARCHAR2 | 30 | Yes | Processing status ***** | |
| INTERFACE_ID | NUMBER | 18 | System generated ID to identify the Transaction Import run | ||
| DESCRIPTION | VARCHAR2 | 250 | DESCRIPTION ***** | ||
| PROCESSED_COUNT | NUMBER | Number of processed records | |||
| PRE_IMPORT_REJECT_COUNT | NUMBER | Number of transactions rejected by the pre_processing_extension | |||
| PRE_IMPORT_SUCCESS_COUNT | NUMBER | Number of transactions accepted by the pre_processing_extension | |||
| IMPORT_REJECT_COUNT | NUMBER | Number of transactions rejected by Transaction Import | |||
| IMPORT_SUCCESS_COUNT | NUMBER | Number of transactions accepted by Transaction Import | |||
| POST_IMPORT_REJECT_COUNT | NUMBER | Number of transactions rejected by the post_processing_extension | |||
| POST_IMPORT_SUCCESS_COUNT | NUMBER | Number of transactions accepted by the post_processing extension | |||
| 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. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJC_TXN_XFACE_CTRL_ALL | pjf_txn_sources_b | TRANSACTION_SOURCE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| PJC_TXN_XFACE_CTRL_ALL_N1 | Non Unique | Default | BATCH_STATUS | |
| PJC_TXN_XFACE_CTRL_ALL_N2 | Non Unique | Default | INTERFACE_ID | |
| PJC_TXN_XFACE_CTRL_ALL_U1 | Unique | Default | BATCH_NAME, DOCUMENT_ID, ORG_ID, TRANSACTION_SOURCE_ID | Obsolete |
| PJC_TXN_XFACE_CTRL_ALL_U2 | Unique | Default | TXN_XFACE_CTRL_ID |