R12 : Purchase Order Import Errors with "ORA-06502: PL/SQL: numeric or value error: character string buffer too small" (Doc ID 1218063.1)

Last updated on SEPTEMBER 25, 2016

Applies to:

Oracle Purchasing - Version: 12.1.2 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

When attempting to run Purchase Document Open Interface to import a PO, the following error occurs.

ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_ERR_UTL. Procedure add_fatal_error.0
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_ITEM_PROCESS_PVT. Procedure update_master_item.60
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_ITEM_PROCESS_PVT. Procedure create_items.60
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines_add.70
ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines.10
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. Insert data into interface table, and item price list attribute is null.
2. Run import program with the parameter create or update item set to yes. Program completed with error subject that list price per unit at Item master was null.

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