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 |