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.
Module: Budgetary Control
DATA_SET_ID
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. | ||||
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, 2024, Oracle and/or its affiliates.