Salesprocess.ksh Batch is Failing for Larger POSU Files

(Doc ID 2316808.1)

Last updated on OCTOBER 15, 2017

Applies to:

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

Symptoms

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

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms