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.

Symptoms

Online SFS sales files are getting rejected with the below error:

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.

Changes

Cause

	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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

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)

Applies to:

Symptoms

Changes

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!