R12: Import Price Catalog Errors with ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 1361669.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
Executable:POXPDOI - Import Price Catalogs


Symptoms

When attempting to run Import Price Catalog the following error occurs.

ERROR 1
-----------------------
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_ERR_UTL. Procedure add_error.0
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_ERR_UTL. Procedure process_val_type_errors.20
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_LINE_PROCESS_PVT. Procedure validate_lines.40
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_update_lines_in_group.0
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines_sync.90
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines.30
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process.10
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_PVT. Procedure start_process.110
User-Defined Exception in Package po.plsql.PO_PDOI_Concurrent. Procedure POXPDOI.30


Steps to Reproduce:
============
1. Responsibility: Purchasing
2. Select the View menu: Request
3. Run Import Price Catalog with parameters
   Document Tye: Blanket
   Create and Update Item : No
   Create Sourcing Rule : No
   Approval Status: Approved
4. Observe program completed with ORA-06502: PL/SQL: numeric or value error: character string buffer too small

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