WFORDUPLD_JOB Fail To Create Franchise PO For Items With Mult Sups With Same Origin Country ID (Doc ID 2992474.1)

Last updated on DECEMBER 12, 2023

Applies to:

Symptoms

Provided wford_20231008.zip with 1040 Franchise Order files. Below are the observations:
1. Batch has loaded all the 1040 Franchise PO data to Stage tables
select count(*) from SVC_WF_ORD_HEAD; -- 1040
select count(*) from SVC_WF_ORD_DETAIL; -- 13987

2. Batch has errored out 46 PO's with data errors -- As expected

3. Batch has not processed 137 PO's i.e. The Process status in the SVC_WF_ORD_HEAD table is "N" for the 137 PO's. -- This is not expected.

Batch has failed with below error:

2023-10-12T12:53:28,871 [Thread-246] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/rms/oracle/proc/bin/batch_wfupload.ksh: Thu Oct 12 12:53:28 Program: wfordupld: PID=21365: wfordupld job completed.
2023-10-12T12:53:35,986 [Thread-246] DEBUG BatchShellCommandRunnerBatchlet - EXT_PROG_SYS_OUT:/u01/retail/rms/oracle/proc/bin/batch_wfupload.ksh: batch_wfupload~20231012125335~BATCH_FAILED~Errors encountered while processing input files for the batch wfordupld.ksh

Steps
1. Login to POM
2. Place the .zip file containing the franchise order files
3. Run the WFORDUPLD_PRE_JOB
4. Run the WFORDUPLD_JOB

Cause

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