Salesprocess.ksh Batch Fails With an Error When Executing CHECK_FTAIL Function
(Doc ID 2738651.1)
Last updated on DECEMBER 25, 2020
Applies to:Oracle Retail Merchandising System - Version 16.0.3 and later
Information in this document applies to any platform.
When running salesprocess.ksh with records to process, the batch encounters below error when it tries to execute the CHECK_FTAIL function
EXEC_SQL : O_KEY) = FALSE THEN
Identifier 'O_KEY' must be declared.
Steps To Recreate:
- Ensure that there are transactions to be exported out of ReSA and run saexprms.
- Add the thread number suffix to the generated POSU files.
- Run uploadsales_all.ksh.
- Run salesprocess.ksh.
- Check logs generated.
- Check error logs. Notice that it fails with an error.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document