My Oracle Support Banner

SALESGENREJ Batch Creates Duplicate Rejected Files (Doc ID 2133623.1)

Last updated on OCTOBER 02, 2020

Applies to:

Oracle Retail Merchandising System - Version 14.0.3 and later
Information in this document applies to any platform.


While executing the Salesgenrej.ksh batch, duplicate rejected files are generated.

Steps to Reproduce:

  1. Run UPLOADSALES_ALL.KSH to upload POSU_XXX.1 file into RMS staging tables and ensure POSU file has some invalid records.
  2. Run SALESPROCESS.KSH job to process records from SVC staging to RMS and notice a few chunk fails in SVC_POSUPLD_STATUS table with status E or R.
  3. Run SALESGENREJ.KSH batch to create reject file POSU_XXX.rej.
  4. Complete sales flow by running SALESUPLOADPURGE.ksh and SALESUPLOADARCH.ksh batch.
  5. Now upload POSU_XXX.rej into RMS by running UPLOADSALES_ALL.ksh, SALESPROCESS.ksh.
  6. Note the rejected file POSU_XXX.rej again failed in SVC_POSUPLD_STATUS with status E or R, but with new process ID.
  7. Now run SALESGENREJ.ksh by calling process_id with status as <> C in SVC_POSUPLD_STATUS.
  8. Notice two rejected files created for both POSU_XXX.1 and POSU_XXX.rej. Ideally rejected file should be created only for the latest file POSU_XXX.rej instead of both the files. This leads to duplicate rejected file creation.




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.