XCC_STREAM_CUBES_GT
This temporary table contains budgetary control balance updates for cubes that have pending updates from budget import and transactions that have passed budgetary control validation. Oracle internal use only.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
XCC_STREAM_CUBES_GT_PK |
CUBE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CUBE_ID | NUMBER | 18 | Yes | Identifies the budgetary control balances cube with pending updates. When CUBE_TRANSFER_STATUS_CODE is NO_CUBES, this is set to -99. | |
| APPLICATION_NAME | VARCHAR2 | 60 | Name of the budgetary control balances cube. | ||
| CALENDAR_ID | NUMBER | 18 | Identifies the budget calendar. | ||
| BUDGET_CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Identifies the key flexfield structure for control budget accounts. | ||
| CUBE_TRANSFER_STATUS_CODE | VARCHAR2 | 30 | Yes | Indicates the update status of the balances to the budgetary control balances cube. Valid values are PENDING, SUCCESS, FAILED, and NO_CUBES. | |
| CUBE_NAME | VARCHAR2 | 60 | Name of essbase cube that stores budgetary control balances |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XCC_STREAM_CUBES_GT_N1 | Non Unique | CUBE_TRANSFER_STATUS_CODE |
| XCC_STREAM_CUBES_GT_U1 | Unique | CUBE_ID |