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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms