ZCA_ROLLUP_UPDATE

This is a temporary dynamic table that is used to assign the source object records to balance the batches to be processed by rollup update job.

Details

  • Schema: FUSION

  • Object owner: ZCA

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Columns

Name Datatype Length Precision Not-null Comments
OBJECT_CODE VARCHAR2 30 Yes Name of the source object. This is a foreign key to LANG_INDEPENDENT_CODE column in ZCA_OBJECTS table.
OBJECT_PK NUMBER 18 Yes Primary key attribute value of the source object row.
BATCH_ID NUMBER 8 The unique identifier of the update batch.

Indexes

Index Uniqueness Tablespace Columns
ZCA_ROLLUP_UPDATE_N1 Non Unique Default OBJECT_CODE, BATCH_ID