R12: Import Price Catalog Ending With Error ORA-06512: at "APPS.PO_PDOI_GRP", line 392 (Doc ID 2401826.1)

Last updated on MARCH 15, 2022

Applies to:

Symptoms

On : 12.1.3 and 12.2.8 version, Loading external catalog

When attempting to run the import price catalog,
the following error occurs.

Error:
Cause: FDPSTP failed due to ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.PO_PDOI_GRP", line 392
ORA-06512: at line 1


Steps to reproduce:

1. Populate interface tables to update expiration from \ to dates for quotation
2. Run the "Import Price Catalog"

FND Logging:

po.plsql.PO_PDOI_ITEM_PROCESS_PVT.update_master_item.60 intf line id = xxxxxx
po.plsql.PO_PDOI_ITEM_PROCESS_PVT.update_master_item.60 message text = Master - Child Conflict in one of these Attributes: RECEIPT_DAYS_EXCEPTION_CODE, RECEIVING_ROUTING_ID, INVOICE_CLOSE_TOLERANCE, RECEIVE_CLOSE_TOLERANCE, AUTO_LOT_ALPHA_PREFIX,DESCRIPTION
po.plsql.PO_PDOI_ITEM_PROCESS_PVT.update_master_item.60 table name = MTL_SYSTEM_ITEMS_B
po.plsql.PO_PDOI_ERR_UTL.add_fatal_error.BEGIN Start of subprogram.
po.plsql.PO_PDOI_ERR_UTL..add_fatal_error.0.EXCEPTION 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;SQLERRM = ORA-06502: PL/SQL: numeric or value error: character string buffer too small

po.plsql.PO_PDOI_ITEM_PROCESS_PVT..update_master_item.60.EXCEPTION 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;SQLERRM = ORA-06502: PL/SQL: numeric or value error: character string buffer too small

po.plsql.PO_PDOI_ITEM_PROCESS_PVT..create_items.60.EXCEPTION 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;SQLERRM = ORA-06502: PL/SQL: numeric or value error: character string buffer too small
po.plsql.PO_PDOI_MAINPROC_PVT..process_create_lines.10.EXCEPTION ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_create_lines.10;SQLERRM = ORA-06502: PL/SQL: numeric or value error: character string buffer too small
po.plsql.PO_PDOI_MAINPROC_PVT..process_lines_add.60.EXCEPTION 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.60;SQLERRM = ORA-06502: PL/SQL: numeric or value error: character string buffer too small
po.plsql.PO_PDOI_MAINPROC_PVT..process_lines.10.EXCEPTION 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;SQLERRM = ORA-06502: PL/SQL: numeric or value error: character string buffer too small
po.plsql.PO_PDOI_MAINPROC_PVT..process.30.EXCEPTION ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process.30;SQLERRM = ORA-06502: PL/SQL: numeric or value error: character string buffer too small
po.plsql.PO_PDOI_PVT.set_draft_errors.BEGIN Start of subprogram.
po.plsql.PO_PDOI_PVT.set_draft_errors.END End of subprogram.
po.plsql.PO_PDOI_PVT..start_process.110.EXCEPTION ORA-06502: PL/SQL: numeric or value error: character string buffer too small in Package po.plsql.PO_PDOI_PVT. Procedure start_process.110;SQLERRM = ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Cause

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