# 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. |  |

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