My Oracle Support Banner

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

Last updated on AUGUST 25, 2022

Applies to:

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


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.

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.




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.