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 11.13.20.07.0 and later
Oracle Fusion Purchasing - Version 11.13.20.01.0 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