My Oracle Support Banner

ORA-01480 Error while Executing the Batch 'posupld' (Doc ID 1277611.1)

Last updated on AUGUST 05, 2020

Applies to:

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

Symptoms

The batch posupld aborts with the following error while processing return of a consignment item for which the primary supplier Return address is NULL as RET_ALLOW_IND is N for the supplier.

ERROR
-----------------------
posupld_1046~20100408041349~rtv_head~rtv_head~-1480~ORA-01480: trailing
null missing from STR bind value~INSERT: Record#=0000
000003, rtv_order_no=152768


Steps To Recreate:

  1. Create a consignment item and attach a supplier such that RET_ALLOW_IND=’N’ for the supplier and the Return address is NULL.
  2. Process return for this item.
  3. Audit the transaction.
  4. Execute saexprms.
  5. Execute posupld batch with the POSU file generated in step 4.
  6. Notice, the posupld batch aborts with ORA-01480 error.

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.