Unable to Reprocess Records on Abrupt Failure of Salesprocess.ksh

(Doc ID 2208834.1)

Last updated on OCTOBER 31, 2017

Applies to:

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

Symptoms

During the execution of the Salesprocess.ksh batch, the PROCESS_SALES function is called for all the chunks being processed. The PROCESS_SALES function encapsulates a PL/SQL function call and if for some reason, the database connection is abruptly terminated, the remaining code of the PROCESS function will not be executed. This prevents the reprocessing to be done as all the data previously loaded from the POSU files into the staging tables will be gone and the check done by CHECK_FHEAD function will raise the following error when the program is restarted:

ERROR

Salesprocess~20160929102058~CHECK_FHEAD~CORESVC_SALES_UPLOAD_SQL.VALIDATE_FHEAD Process id: 11525 Failed


Steps to Reproduce:

  1. Create 2 new items.
  2. Create POSU file containing both items.
  3. Run Uploadsales.ksh.
  4. Update SVC_POSUPLD_STATUS and set the status to “C” where the chunk_id is null. For the records where the chunk_id is not null, the status must remain as “N”.
  5. Delete the records loaded into SVC_POSUPLD_STAGING.
  6. Execute Salesprocess.ksh.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms