Unhandled Oracle Connection Error Message Passed As Parameter To PROCESS_SALES.
(Doc ID 2383435.1)
Last updated on SEPTEMBER 25, 2018
Applies to:Oracle Retail Merchandising System - Version 14.1.3 and later
Information in this document applies to any platform.
In RMS 14.1.3, While running the Salesprocess.ksh it fails with error
Unhandled oracle connection error message passed as parameter to PROCESS_SALES.
Steps To Reproduce the issue:
1. Load sales data into RMS but before running the salesprocess.ksh modify the connection string, to force an ORA error.
2. Notice that words that make up the ora error message are being used as $1/$2 parameters (instead of the process/chunk_id) in the call to the process sales function. This leads the process to abort and logs syntax errors in the error log.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!