My Oracle Support Banner

Import Standard Purchase Orders Program Completing in Error ORA-06510 (Doc ID 2966358.1)

Last updated on AUGUST 13, 2023

Applies to:

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

Symptoms

When attempting to import standard Purchase orders,
the following error occurs.

ERROR
-----------------------

Below error is observed in Import program log file


ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind in Package po.plsql.PO_PDOI_PVT. Procedure start_process.110;SQLERRM = ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind

ORACLE error 6510 in FDPSTP

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

fnd log messages has below content

po.plsql.PO_PDOI_HEADER_PROCESS_PVT..fetch_headers.0.EXCEPTION ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind in Package po.plsql.PO_PDOI_HEADER_PROCESS_PVT. Procedure fetch_headers.0;SQLERRM = ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
po.plsql.PO_PDOI_MAINPROC_PVT..process_headers.10.EXCEPTION ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_headers.10;SQLERRM = ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
po.plsql.PO_PDOI_PVT.set_draft_errors.END End of subprogram.
po.plsql.PO_PDOI_MAINPROC_PVT..process.10.EXCEPTION ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process.10;SQLERRM = ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
po.plsql.PO_PDOI_PVT.set_draft_errors.BEGIN Start of subprogram.
po.plsql.PO_PDOI_PVT..start_process.110.EXCEPTION ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind in Package po.plsql.PO_PDOI_PVT. Procedure start_process.110;SQLERRM = ORA-06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
po.plsql.PO_PDOI_PVT.wrap_up.BEGIN Start of subprogram.
po.plsql.PO_INTERFACE_ERRORS_UTL.flush_errors_tbl.BEGIN Start of subprogram.
po.plsql.PO_INTERFACE_ERRORS_UTL.init_errors_tbl.BEGIN Start of subprogram.
po.plsql.PO_INTERFACE_ERRORS_UTL.init_errors_tbl.END End of subprogram.
po.plsql.PO_INTERFACE_ERRORS_UTL.flush_errors_tbl.END End of subprogram.
po.plsql.PO_PDOI_GRP..start_process.20.EXCEPTION User-Defined Exception in Package po.plsql.PO_PDOI_GRP. Procedure start_process.20;SQLERRM = User-Defined Exception
po.plsql.PO_PDOI_PVT.wrap_up. Timing Stat: PDOI_ALL-1: Start=13:28:54.831, End=13:29:08.911, Duration=+00 00:00:14.080159
po.plsql.PO_PDOI_PVT.wrap_up. Timing Stat: PREPROCESSING-1: Start=13:28:54.883, End=13:29:04.720, Duration=+00 00:00:09.837061
po.plsql.PO_PDOI_PVT.wrap_up. Timing Stat: HEADER_GROUPING-1: Start=13:29:04.721, End=13:29:08.650, Duration=+00 00:00:03.928959
po.plsql.PO_PDOI_PVT.wrap_up. Timing Stat: MAIN_PROCESSING-1: Start=13:29:08.651, End=, Duration=
po.plsql.PO_PDOI_PVT.wrap_up. Timing Stat: HEADER_PROCESS-1: Start=13:29:08.652, End=, Duration=
po.plsql.PO_PDOI_PVT.wrap_up.END End of subprogram.
po.plsql.PO_PDOI_GRP.start_process.END x_return_status = U

 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Insert data to PO_HEADERS_INTERFACE, PO_LINES_INTERFACE, PO_LINE_LOCATIONS_INTERFACE, PO_DISTRIBUTIONS_INTERFACE
2. Execute Import standard Purchase order
3. Error is observed in log file

Cause

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
Symptoms
Cause
Solution
References


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