XCC_UNDO_REDO_DATA_SETS_GT
Contains a row for each distinct transaction type, action, and ledger combination being processed by the current run of the budgetary control undo and re-reserve process. It contains the data set identifier assigned by the budgetary control undo and re-reserve process to this transaction type, action, and ledger combination. In the case of General Ledger and Subledger Accounting, a -99 is stored instead of a ledger, as a data set can go across ledgers.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
XCC_UNDO_REDO_DATA_SETS_G_PK |
TRANSACTION_TYPE_CODE, SOURCE_ACTION_CODE, LEDGER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Transaction type to be processed by the budgetary control undo and re-reserve process. | |
| SOURCE_ACTION_CODE | VARCHAR2 | 30 | Yes | Source action to be processed by the budgetary control undo and re-reserve process. | |
| LEDGER_ID | NUMBER | 18 | Yes | Ledger to be processed by the budgetary control undo and re-reserve process. This is set to -99 for General Ledger and Subledger Accounting. | |
| DATA_SET_ID | NUMBER | 18 | Yes | Data set assigned to this transaction type, source action, and ledger combination. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XCC_UNDO_REDO_DATA_SETS_GT_U1 | Unique | TRANSACTION_TYPE_CODE, SOURCE_ACTION_CODE, LEDGER_ID |
| XCC_UNDO_REDO_DATA_SETS_GT_U2 | Unique | DATA_SET_ID |