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     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.    
TRANSFER_STATUS_CODE VARCHAR2 32     Status of the transfer to essbase can be NOT_READY, READY, TRANSFERRED, NOT_APPLICABLE.    
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.    
SUMMARIZED_FLAG VARCHAR2 16     Indicates if summarized amounts across all the transactions in the data set are available in a dummy header.    
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.    

Copyright © 2019, 2023, Oracle and/or its affiliates.