XCC_STREAM_DATA_SETS_GT
This temporary table contains identifiers of budget import runs and budgetary control validation requests that have not yet been updated to the budgetary control balances cubes. Oracle internal use only.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
XCC_STREAM_DATA_SETS_GT_PK |
DATA_SET_ID, CUBE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DATA_SET_ID | NUMBER | 18 | Yes | Identifies the budget import runs or budgetary control validation requests with pending updates. | |
| CUBE_ID | NUMBER | 18 | Yes | Identifies the budgetary control balances cube with pending updates. | |
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Identifies the type of transaction with pending updates. | ||
| DATA_SET_TRANSFER_STATUS_CODE | VARCHAR2 | 30 | Indicates the update status of the balances to the budgetary control balances cube by data set. Valid values are PENDING, SUCCESS, MIXED, FAILED, and NO_CUBES. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XCC_STREAM_DATA_SETS_GT_U1 | Unique | DATA_SET_ID, CUBE_ID |