My Oracle Support Banner

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 later
Information in this document applies to any platform.


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:

Total logical records read: 158076238
Total logical records rejected: 51

Records should be processed

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.


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

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