My Oracle Support Banner

Posupld Post Function Fails With an "ORA-01480" Error Message (Doc ID 2153367.1)

Last updated on FEBRUARY 26, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.0.7 to 13.0.7 [Release 13.0]
Information in this document applies to any platform.

Symptoms

When attempting to run posupld_post batch the following error occurs:

 

Error

-------

"prepost~<TIMESTAMP>~posupld_post~~-1480~ORA-01480: trailing null missing from STR bind value~Error in call to POS_UPDATE_SQL.POS_INVC_DETAIL_INSERT."

Steps To Recreate:
1. Run Posupld batch.
2. Run Prepost for Posupld post.
3. Batch borts with an error "ORA-01480'. 

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
Symptoms
Changes
Cause
Solution
References


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