My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.