POXPOPDOI Ended With Error ORA-06502 (Doc ID 1637354.1)

Last updated on FEBRUARY 04, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Purchase Order

When attempting to run Order Import, you are seeing the following error in the log :

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


The issue can be reproduced at will with the following steps:
1. Purchasing > Requests > Run >> Order Import
2. Check the log file


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