My Oracle Support Banner

PRC:PO: Import Purchase Orders Process Is in Retrying Status - Fax Number More than 30 Characters on Supplier Contact (Doc ID 2713815.1)

Last updated on DECEMBER 02, 2020

Applies to:

Oracle Fusion Purchasing Cloud Service - Version and later
Oracle Fusion Purchasing - Version and later
Information in this document applies to any platform.


When attempting to Import Purchase Orders with 1000 Headers Process Going to Retrying status and does not complete or Error
Unless cancelled ESS Server Logs show below error

Message Execution error for request 473191. Reason: java.sql.SQLException: ORA-20001: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Supplemental Detail at line 5958 of FUSION.PO_PDOI_HEADER_PROCESS_PVT.default_fax_from_contact.20
 at line 2575 of FUSION.PO_PDOI_HEADER_PROCESS_PVT.default_headers.30
 at line 370 of FUSION.PO_PDOI_MAINPROC_PVT.process_headers.30
 at line 485 of FUSION.PO_PDOI_MAINPROC_PVT.process_headers.30
 at line 124 of FUSION.PO_PDOI_MAINPROC_PVT.process.10
ORA-06512: at "FUSION.PO_MESSAGE_S", line 386
ORA-06512: at "FUSION.PO_PDOI_MAINPROC_PVT", line 249
ORA-06512: at line 1

The issue can be reproduced at will with the following steps:
1. Prepare CSV file with Order details
2. Load file for Import which Completes successfully
3. Run Import Orders Process which is going to Retrying status




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

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