LOAD_ITEM_FORECAST_WEEKLY_JOB Stops Processing After 50 Bad Records
(Doc ID 2950601.1)
Last updated on MAY 22, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
Received a weekly file from RDF team through an SR, the file had 181 Million records and as part of 3rd Dec nightly cycle. They tried to process this file through the LOAD_ITEM_FORECAST_WEEKLY_JOB. The job loaded only 158 Million records and in the logs provided by Oracle they saw that it read only 158 Million records and stopped after seeing more than 50 rejected records. Below is the stats:
ACTUAL BEHAVIOR
---------------
Total logical records read: 158076238
Total logical records rejected: 51
EXPECTED BEHAVIOR
-----------------------
Records should be processed
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Create/get a wsdemand.csv.ovr file with more than 50 bad records
2) Execute the batch on end of week
3) Check the logs and see it stops processing after count of rejected records is more than 50 i.e. is 51.
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 |