A New Supplier Is Not Created In EBS Due To Error ORA-06512: At "APPS.POS_SUPP_APPR" During Approval
Last updated on NOVEMBER 13, 2017
Applies to:Oracle iSupplier Portal - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Registration and Onboarding
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
Due to this issue, users cannot approve the supplier
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms