XCC_DATA_SETS
The table contains a row for each call to the budgetary control engine. It contains the parameters the engine was run with, the return budgetary control status, and the transfer status.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
XCC_DATA_SETS_PK |
DATA_SET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DATA_SET_ID | NUMBER | 18 | Yes | Unique identifier for this budgetary control engine run. | |
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Identifies the type of transaction. | ||
| ACTION_CODE | VARCHAR2 | 30 | Action that occurred on the transaction or set of transactions. | ||
| LEDGER_ID | NUMBER | 18 | Ledger to be processed in this budgetary control engine run. It is required for all products other than GL, XLA and XCC. | ||
| RESERVATION_MODE_CODE | VARCHAR2 | 30 | Reservation mode can be either DRAFT or FINAL. | ||
| CALLING_METHOD_CODE | VARCHAR2 | 30 | Calling method can be ONLINE_SINGLE, ONLINE_BATCH, BACKEND_SINGLE or BACKEND_BATCH. | ||
| OVERRIDE_MODE_CODE | VARCHAR2 | 30 | Override mode is either NONE, OVERRIDE or CHECK. | ||
| RESULT_CODE | VARCHAR2 | 30 | Resulting funds status such as SUCCESS, WARNING, PARTIAL, FAILED, MIXED, ERROR, NOT_APPLICABLE. | ||
| FATAL_ERROR_MESSAGE | VARCHAR2 | 2000 | Error message in the case of fatal errors. | ||
| OVERRIDE_AVAILABLE_FLAG | VARCHAR2 | 1 | Indicates if override is available. Value is always No unless the override mode is CHECK and one or more distributions failed funds validation. | ||
| TRANSFER_STATUS_CODE | VARCHAR2 | 30 | Yes | Status of the transfer to essbase can be NOT_READY, READY, TRANSFERRED, NOT_APPLICABLE. | |
| NEEDS_PURGE_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the pending activities for this data set need to be purged. | |
| OVERRIDE_USER_GUID | VARCHAR2 | 64 | Current user for the purposes of overrides. May be different from the actual user calling funds reservation in some circumstances. | ||
| OVERRIDE_REASON | VARCHAR2 | 1000 | Justification for the override. | ||
| OVERRIDE_FLAG | VARCHAR2 | 1 | Indicates whether any of the transactions in the data set have been overridden. | ||
| SUMMARIZED_FLAG | VARCHAR2 | 1 | Indicates if summarized amounts across all the transactions in the data set are available in a dummy header. | ||
| REPROCESS_FLAG | VARCHAR2 | 1 | Yes | Indicates whether data set is reprocessed. Valid values are Y and N. | |
| 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. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| XCC_DATA_SETS_N1 | Non Unique | FUSION_TS_TX_DATA | TRANSFER_STATUS_CODE |
| XCC_DATA_SETS_N2 | Non Unique | Default | CREATION_DATE |
| XCC_DATA_SETS_U1 | Unique | FUSION_TS_TX_DATA | DATA_SET_ID |