The System Could Not Generate the PDF by ORA-06502 on PO_COMMUNICATION_PVT if Buyer Phone Number Have Over 45 Characters Length (Doc ID 2281770.1)

Last updated on JULY 05, 2017

Applies to:

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

Symptoms

When user views an approved PO PDF document, user gets the following error messages on OAF window instead of an approved PO PDF if buyer's work phone number have over 45 characters length.

ERROR
The following error messages appears on OAF window instead of an approved PO PDF.

\n\ Problem: The system could not generate the PDF document.
\n\ Reason: The system detected an error in the following code/object.
\n\ Code: XML
\n\ Object: PO
\n\ Action: Please contact the system administrator and try again.

In this case, the following error messages also log on FND_LOG_MESSAGES.

po.plsql.PO_COMMUNICATION_PVT.POXMLGEN "ORA-19202: Error occurred in XML processing
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at ""APPS.PO_COMMUNICATION_PVT"", line 7457"

po.communicate.PoGenerateDocument GenerateDocument::getPOXml()- Exception
po.communicate.PoGenerateDocument GenerateDocument::genDoc() - PoPDFException oracle.apps.po.communicate.PoPDFException: PO_PDF_XML_FAILED
po.communicate.webui.poViewDocumentCO poViewDocumentCO::processRequest - PoPDFExceptionoracle.apps.po.communicate.PoPDFException: PO_PDF_XML_FAILED
po.communicate.webui.poViewDocumentCO Error MessagePO_PDF_XML_FAILED
fnd.common.Message.auto_log POPO_PDF_XML_FAILED

Steps to Reproduce

  1. Create new PO
    Purchasing Responsibility(N) Purchase Order > Purchase Order
  2. Save the PO and approve it
    Approve(B) > Approve
  3. View PDF
    Inquire(T) > View Document
  4. Show the above error on OAF window instead of Approved PO PDF

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