XCC_BC_REPROCESS_DATASETS_GT
The table contains a record for each budgetary control validation request to reprocess transactions that failed budgetary control validations previously. Each record includes potentially different parameter values submitted in repeated requests.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
XCC_BC_REPROCESS_DATASETS_PK |
DATA_SET_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
DATA_SET_ID | NUMBER | 18 | Yes | Unique identifier for smaller group of budgetary control transaction to be processed by a particular budgetary control request. | |
TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Unique identifier for transaction type. | |
SOURCE_ACTION_CODE | VARCHAR2 | 30 | Yes | Action performed on transaction. | |
LEDGER_ID | NUMBER | 18 | Yes | Unique identifier for ledger associated with transaction. | |
REPROCESS_DATA_SET | VARCHAR2 | 500 | Yes | Budgetary control transaction or group of transactions processed in each ESS request. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
XCC_BC_REPROCESS_DATASETS_U1 | Unique | DATA_SET_ID |
XCC_BC_REPROCESS_DATASETS_U2 | Unique | TRANSACTION_TYPE_CODE, SOURCE_ACTION_CODE, LEDGER_ID, REPROCESS_DATA_SET |