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:
Oracle Retail Merchandising Foundation Cloud Service - Version NA and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |