My Oracle Support Banner

Sales Reject Batch Creating Files With Duplicate Header (Doc ID 2601311.1)

Last updated on NOVEMBER 26, 2019

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

Sales Reject is creating files with duplicate header.
When the sales runs for the second time to process reject files, it further rejects few files due to duplicate header.

Set the Max DB seq for Process id to a max of 4. Else to reproduce this issue will be difficult as the max seq is set to 9999999999.
1. Created 5 POSU and all the POSU's should be modified to get these records rejected.
2. Upload the 1st POSU by running uploadsales, salesprocess, salesgenrej and salesuploadarch batch (For ex: Process id 1 will be assigned) and the record gets rejected to staging table SVC_POSUPLD_REJ_RECS
4. Upload the 2nd POSU by running uploadsales and salesprocess batch (Process id 2 was assigned) and the record gets rejected to staging table SVC_POSUPLD_STATGING_REJ
5. Upload the 3rd POSU by running uploadsales and salesprocess batch (Process id 3 was assigned) and the record gets rejected to staging table SVC_POSUPLD_STATGING_REJ
6. Upload the 4th  POSU by running uploadsales and salesprocess batch (Process id 4 was assigned) and the record gets rejected to staging table SVC_POSUPLD_STATGING_REJ
7. Upload the 5th  POSU by running uploadsales and salesprocess batch (Process id 1 was assigned) and the record gets rejected to staging table SVC_POSUPLD_STATGING_REJ
8. Run the salesgenrej batch.

Even if the 1st POSU and 5th POSU assigned with the same process id, the reject records should not have duplicate FHEAD and FTAIL in the file.

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


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