My Oracle Support Banner

Salesprocess.ksh Batch is Failing for Larger POSU Files (Doc ID 2316808.1)

Last updated on APRIL 16, 2020

Applies to:

Oracle Retail Merchandising System - Version 14.1 and later
Information in this document applies to any platform.


Salesprocess.ksh batch fails when there is are larger POSU files.

Steps To Recreate:

1. When a POSU files contains more than 30 K records salesprocess.ksh fails with errors such as

salesprocess~20170808103327~PROCESS_SALES~CORESVC_SALES_UPLOAD_SQL.PROCESS_SALES Process:263853 Thread: Failed.

salesprocess~20170808103328~EXEC_SQL_T~ERROR: ORA-02097: parameter cannot be modified because specified value is invalid ORA-48912: The specified trace filename is too long


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.