Unable to Reprocess Records on Abrupt Failure of Salesprocess.ksh
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.
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:
Salesprocess~20160929102058~CHECK_FHEAD~CORESVC_SALES_UPLOAD_SQL.VALIDATE_FHEAD Process id: 11525 Failed
Steps to Reproduce:
- Create 2 new items.
- Create POSU file containing both items.
- Run Uploadsales.ksh.
- 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”.
- Delete the records loaded into SVC_POSUPLD_STAGING.
- Execute Salesprocess.ksh.
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