My Oracle Support Banner

STKUPLD Throws "ORA-01480: Trailing Null Missing From STR Bind Value~UPDATE: Pa_sq_upd..." Error (Doc ID 2397689.1)

Last updated on MAY 11, 2018

Applies to:

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

Symptoms


When you change the value of commit_max_ctr in the RESTART_CONTROL table to more than 1, the Upload Stock Count (STKUPLD) process displays the error ORA-01480 error.

Error
-----------------------
"stkupld_17~20180226150044~insert_update_stkqty~stake_qty~-1480~ORA-01480: trailing null missing from STR bind value~UPDATE: pa_sq_upd structure of arrays."


Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:
1. In the RESTART_CONTROL table change the value of the commit_max_ctr field to 1000 for the program_name 'stkupld'.
2. Run the STKUPLD process.
3. Notice the error "insert_update_stkqty ~ stake_qty ~ -1480 ~ ORA-01480: trailing null missing from STR bind value ~ UPDATE: pa_sq_upd structure of arrays"


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!


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