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.
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.
null missing from STR bind value~INSERT: Record#=0000
Steps To Recreate:
- Create a consignment item and attach a supplier such that RET_ALLOW_IND=’N’ for the supplier and the Return address is NULL.
- Process return for this item.
- Audit the transaction.
- Execute saexprms.
- Execute posupld batch with the POSU file generated in step 4.
- 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