A New Supplier Is Not Created In EBS Due To Error ORA-06512: At "APPS.POS_SUPP_APPR" During Approval
(Doc ID 1982884.1)
Last updated on MARCH 15, 2022
Applies to:Oracle iSupplier Portal - Version 12.1.3 and later
Information in this document applies to any platform.
When attempting to approve the supplier, the following error occurs and prevents the supplier approval from completing.
ORA-20001: An unexpected error has occurred. Please try again later if the problem persists, please contact your system administrator. ORA-06512: at "APPS.POS_SUPP_APPR", line 2636 ORA-06512: at line 1
Error from the Trace file
'ORA-06502: PL/SQL: numeric or value error: character string buffer too
"create_supplier_address sqlerrm is ORA-06502: PL/SQL: numeric or value
error: character string buffer too small"
The issue can be reproduced at will with the following steps:
1. Submit a supplier registration for approval
2. Try to approve the supplier
- Get the 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