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 26, 2023

Applies to:

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


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:

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"




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.