GL_ESSBASE_BALANCES_TRACKING

This table keeps track of the incremental data that needs to be published to an Oracle Essbase cube.

Details

• Schema: FUSION

• Object owner: GL

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
GL_ESSBASE_BALANCES_TRACK_PK	DELTA_RUN_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
DELTA_RUN_ID	NUMBER		18	Yes	Uniquely identifies the set of data to be processed.
CUBE_ID	NUMBER		18	Yes	Cube that the data needs to go into. Cube given is always a standard balances cube, even if the average balances cube is also impacted.
REASON_CODE	VARCHAR2	30		Yes	Reason why the balances were not immediately published to the cube. Valid values are CUBE_DOWN and UNPUBLISHED_VALUES.
STATUS_CODE	VARCHAR2	30		Yes	Status of this set of data. Valid values are READY and WAITING_TO_PUBLISH.
CREATED_BY_REQUEST_ID	NUMBER		18	Yes	Posting request that produced this set of data.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
ADB_CUBE_ID	NUMBER		18	Yes	Average daily balance cube identifier for the data.

Foreign Keys

Table	Foreign Table	Foreign Key Column
gl_essbase_balances_delta	gl_essbase_balances_tracking	DELTA_RUN_ID
gl_essbase_daily_bal_delta	gl_essbase_balances_tracking	DELTA_RUN_ID

Indexes

Index	Uniqueness	Tablespace	Columns
GL_ESSBASE_BALANCES_TRACK_N1	Non Unique	Default	CUBE_ID
GL_ESSBASE_BALANCES_TRACK_N2	Non Unique	Default	ADB_CUBE_ID
GL_ESSBASE_BALANCES_TRACK_U1	Unique	Default	DELTA_RUN_ID