Online SFS Sales Files are Getting Rejected with Error "ORA-01722: Invalid Number Returned by Program Unit STKLEDGR_SQL.WRITE_FINANCIALS"
(Doc ID 2794141.1)
Last updated on OCTOBER 03, 2022
Applies to:Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.
Online SFS sales files are getting rejected with the below error:
Error ORA-01722: invalid number returned by program unit STKLEDGR_SQL.WRITE_FINANCIALS
Steps To Recreate:
1. Load a RTLOG for SFS (ship from store) scenario.
2. Run Sales jobs to load the sales in ReSA(Retail Sales Audit).
3. Upload the POSU file in RMS(Retail Merchandising System).
4. Notice SFS sales for online stores are not getting loaded in TRAN_DATA though loaded and exported from ReSA.
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