Item Induction IINDBATCH Concurrency Issue Running Items Ind And Cost Changes Ind At Same Time (Doc ID 2853766.1)

Last updated on JANUARY 11, 2024

Applies to:

Symptoms

On : NA version, Merch - Items

ACTUAL BEHAVIOR
---------------
Item Induction IINDBATCH concurrency issue running Items ind and Cost Changes ind at same time.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Setup have both “IINDBATCH_PROCESS_ADHOC” (to process Items) and “IINDBATCH_CC_PROCESS_ADHOC” (to process cost changes) jobs running as Standalone jobs in POM.
2. “IINDBATCH_JOB” in POM is configured to pick up “ITEM_MASTER_RRP” files.
3. “IINDBATCH_JOB” in POM is configured to pick up “COST_CHANGE_MFCS” files.
4. When both jobs run at same time (with files to process), they fail.
5. In MFCS “Data Loading Status” screen, we can see that each induction job (Items/ CostChanges) tried to process both Items and Cost Changes files.
6. “IINDBATCH_JOB” (Items) execution logs:
  - can see it runs with the right parameters;
  - picks up the right Items file (ITEM_MASTER_RRP_BATCH_00000000000000000561.xml) and with right template (TVG_SP_ITEM_MASTER);
  - but then it also tries to process the Cost Changes file (COST_CHANGE_MFCS_BATCH_00000000000000000560.xml) with the Items template (TVG_SP_ITEM_MASTER), which fails.
7. “IINDBATCH_CC_JOB” (Cost Changes) execution logs:
  - can see it runs with the right parameters;
  - but it tried first to load the Items file (ITEM_MASTER_RRP_BATCH_00000000000000000561.xml) but using Cost Changes template (TVG_SP_COST_CHANGE), which fails;
  - later it also tried to process correctly the Cost Changes file (COST_CHANGE_MFCS_BATCH_00000000000000000560.xml) and also using the correct Cost Changes template (TVG_SP_COST_CHANGE).
  

Cause

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