1. Tables and Views for Sales and Fusion Service
  2. CN_TP_PROCESS_BATCHES_ALL

CN_TP_PROCESS_BATCHES_ALL

CN_PROCESS_BATCHES is an internal table used to manage the calculation process. The table is automatically populated and updated during calculation. No attempt must be made to insert or modify rows in this table. . You need one row for each salesperson's period (CN_SRP_PERIODS) that will be calculated. . LOGICAL_BATCH_ID is a unique identifier assigned to all CN_SRP_PERIODS in a single calculation run. . PHYSICAL_BATCH_ID is a non-unique identifier assigned to each group of CN_SRP_PERIODS within the logical batch depending upon the number of transactions in each of these CN_SRP_PERIODS references. Each physical batch is a separate commit unit. . STATUS_CODE indicates whether the batch has been processed: 'IN_USE' indicates that the batch is ready for processing, 'VOID' indicates that the batch has been processed and can be purged. . PROCESS_BATCH_TYPE indicates whether this salesperson period belongs to the direct or credited salesperson.

Details

  • Schema: FUSION

  • Object owner: CN

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CN_TP_PROCESS_BATCHES_ALL_PK

PROCESS_BATCH_ID

Columns

Name Datatype Length Precision Not-null Comments
PROCESS_BATCH_ID NUMBER 18 Yes Primary key
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.
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to the row.
LOGICAL_BATCH_ID NUMBER 18 Yes Logical batch unique identifier
PHYSICAL_BATCH_ID NUMBER 18 Physical batch unique identifier
SRP_PERIOD_ID NUMBER 18 Period Identifier
PERIOD_ID NUMBER 18 Period Identifier
PARTICIPANT_ID NUMBER 18 Yes Points to hz_parties.party_id
START_DATE DATE START DATE
END_DATE DATE END DATE
START_PERIOD_ID NUMBER 18 Yes Period-id of start_date
END_PERIOD_ID NUMBER 18 Period_id of end_date
PROCESS_BATCH_TYPE VARCHAR2 60 Process Batch Type
SALES_LINE_TOTAL NUMBER Total Number of Transaction Lines
RECORD_CNT NUMBER Number of records to be processed for the participant
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.
STATUS_CODE VARCHAR2 30 Yes Batch status
CURRENT_PHASE VARCHAR2 30 Indicates the current phase of the batch
CALC_COMP_PLANS VARCHAR2 1 Flag that indicates if the compensation plans were already calculated for the participant
SIMULATION_ID NUMBER 18 Indicates the calculation simulation that will be executed in this batch
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table Foreign Table Foreign Key Column
CN_TP_PROCESS_BATCHES_ALL cn_srp_participants_all PARTICIPANT_ID

Indexes

Index Uniqueness Tablespace Columns
CN_TP_PROCESS_BATCHES_N1 Non Unique Default LOGICAL_BATCH_ID, PHYSICAL_BATCH_ID
CN_TP_PROCESS_BATCHES_N2 Non Unique Default LOGICAL_BATCH_ID, PARTICIPANT_ID, START_PERIOD_ID, END_PERIOD_ID, START_DATE, END_DATE
CN_TP_PROCESS_BATCHES_U1 Unique Default PROCESS_BATCH_ID