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 MAY 11, 2016

Applies to:

Oracle iSupplier Portal - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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.

ERROR
-----------------------
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
 small"
 
 "create_supplier_address sqlerrm is ORA-06502: PL/SQL: numeric or value
 error: character string buffer too small"

 

STEPS
-----------------------
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

Cause

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