Unable to Reprocess Records on Abrupt Failure of Salesprocess.ksh (Doc ID 2208834.1)

Last updated on MARCH 08, 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 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:



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”.
Delete the records loaded into SVC_POSUPLD_STAGING.
5. Execute salesprocess.ksh.



Changes

 

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