DW_BC_DATA_SET_D (Preview)

This table requires activation of Budgetary Control functional area. 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

Module: Budgetary Control

Key Columns

DATA_SET_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DATA_SET_ID NUMBER 38 0 True Unique identifier for this budgetary control engine run.
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Source record identifier. Value is derived from a combination of Asset adjustment identifiers.
TRANSACTION_TYPE_CODE VARCHAR2 32 Identifies the type of transaction.
ACTION_CODE VARCHAR2 32 Action that occurred on the transaction or set of transactions.
LEDGER_ID NUMBER 38 0 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 32 Reservation mode can be either DRAFT or FINAL.
CALLING_METHOD_CODE VARCHAR2 32 Calling method can be ONLINE_SINGLE, ONLINE_BATCH, BACKEND_SINGLE or BACKEND_BATCH.
OVERRIDE_MODE_CODE VARCHAR2 32 Override mode is either NONE, OVERRIDE or CHECK.
RESULT_CODE VARCHAR2 32 Resulting funds status such as SUCCESS, WARNING, PARTIAL, FAILED, MIXED, ERROR, NOT_APPLICABLE.
FATAL_ERROR_MESSAGE VARCHAR2 999 Error message in the case of fatal errors.
OVERRIDE_AVAILABLE_FLAG VARCHAR2 16 Indicates if override is available. Value is always No unless the override mode is CHECK and one or more distributions failed funds validation.
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 999 Justification for the override.
OVERRIDE_FLAG VARCHAR2 16 Indicates whether any of the transactions in the data set have been overridden.
REPROCESS_FLAG VARCHAR2 16 Indicates whether data set is reprocessed. Valid values are Y and N.
CREATED_BY_USER_ID VARCHAR2 64 Who column: indicates the user who created the row.
UPDATED_BY_USER_ID VARCHAR2 64 Who column: indicates the user who last updated the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.