How IF_ROW_BATCH_NUM is calculated and how it relates to number of records in the batch? (Doc ID 2906045.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Goal

As a pert of reviewing the end-to-end process of ODI : "Process Integration for Collections Management". More specifically the batch size configuration:

The conf in AIA regarding this is:

BatchSize=5000
IF_ROW_BATCH_NUM_Error=50
IF_ROW_BATCH_NUM_CREATE=100
IF_ROW_BATCH_NUM_UPDATE=501
IF_ROW_BATCH_NUM_UpdateEnd=999
IF_ROW_BATCH_NUM_CreatedEnd=499
IF_ROW_BATCH_NUM_UpdateStart=500
IF_ROW_BATCH_NUM_CreatedStart=100

According to online Doc: https://docs.oracle.com/cd/E50268_01/doc.115/e50336/abc_collections_config.htm#CBDBGEEE

"For example, if the BatchSize property is changed to 5000 and the IF_ROW_BATCH_NUM_CreatedStart=100 and IF_ROW_BATCH_NUM_CreatedEnd=199,
then ODI can simultaneously dequeue 5000*100=500000 records into Siebel EIM table. Siebel batch size for the EIM table load must match so that it can manage this data upload from ODI."

e.g. In the conf it is noticed to have IF_ROW_BATCH_NUM_UpdateStart=500 and IF_ROW_BATCH_NUM_UpdateEnd=999. So while having 5000*500=2500000 records.
However, it is noticed that (for the EIM table), batches are often created with less records that 5000 records:

BATCH_NO | COUNT
497 | 418
498 | 418
499 | 417
500 | 418
501 | 835
502 | 835

Is that normal ? Does it mean that we are not going to have 5000*500=2500000 records ?

So please explain how IF_ROW_BATCH_NUM is calculated and how it relates to number of records in the batch?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.