My Oracle Support Banner

Purchase Order Approval Fails With 'PDF Document Generation Failure' at WAITFORCONCURRENTPROGRAM Activity (Doc ID 2920384.1)

Last updated on JUNE 11, 2024

Applies to:

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

Symptoms

On : 12.2.8 version, Approvals - Req, PO

Purchase order approval fails with error notification sent to buyer with subject 'PDF Document Generation Failure - Standard Purchase Order nnnnn' and the following error:

  ERROR
  -----------------------
  The system could not generate and/or communicate at least one of the documents to the supplier or the approver. Please contact the system administrator.

WFStat output shows that the failure occurs at activity 'Wait for Concurrent Program' (WAITFORCONCURRENTPROGRAM) as follows:

DATE    Process / Activity    Process Name    Activity Name    RESULT
11/12/2022 10:10    EMAIL_DOC_PROCESS / PO_NEW_COMMUNICATION-2    Email PO    PO New Communication    Y
11/12/2022 10:11    EMAIL_DOC_PROCESS / WAITFORCONCURRENTPROGRAM-1    Email PO    Wait for Concurrent Program    ERROR
11/12/2022 10:11    EMAIL_DOC_PROCESS / NOOP1    Email PO    Noop    #NULL
11/12/2022 10:11    EMAIL_DOC_PROCESS / NOTIFY_PDF_ERROR    Email PO    Notify PDF Error to Buyer    #NULL

Concurrent program "PO Output for Communication" (POXPOPDF) is launched to process the PDF generation and fails showing the following exception in its log:

POXPOPDF: PO Output for Communication
+---------------------------------------------------------------------------+
Current system time is 12-NOV-2022 10:11:45
+---------------------------------------------------------------------------+
CP main executing runProgram for oracle.apps.po.communicate.PoGenerateDocumentCP
...
Calling the getPOXml method
GenerateDocument::getPOXml() : l_exists 1
GenerateDocument::getPOXml() : m_whichTables MAIN
GenerateDocument::getPOXml()- Calling the POXMLGEN method Wed Dec 14 06:53:48 EST 2022
GenerateDocument::getPOXml() - Exception   
 genDoc() : PoPDFExceptionoracle.apps.po.communicate.PoPDFException: PO_PDF_XML_FAILED
oracle.apps.po.communicate.PoPDFException: PO_PDF_XML_FAILED
rolling back the complete program
CP main completed runProgram for oracle.apps.po.communicate.PoGenerateDocumentCP
+---------------------------------------------------------------------------+

Debug log for the running of the concurrent shows the following exception:

po.plsql.PO_COMMUNICATION_PVT.Get_Preparer_Profile.BEGIN    2    Start of subprogram.
po.plsql.PO_COMMUNICATION_PVT.Get_Preparer_Profile.000    1    p_document_id = 234567
po.plsql.PO_COMMUNICATION_PVT.Get_Preparer_Profile.000    1    p_document_type = PO
po.plsql.PO_COMMUNICATION_PVT.Get_Preparer_Profile.000    1    p_profile_option = ENABLE_TIMEZONE_CONVERSIONS
po.plsql.PO_COMMUNICATION_PVT.Get_Preparer_Profile.002    1    x_item_type = POAPPRV
po.plsql.PO_COMMUNICATION_PVT.Get_Preparer_Profile.002    1    x_item_key = 234567-654321
po.plsql.PO_COMMUNICATION_PVT.Get_Preparer_Profile.013    1    l_profile_value = Y
po.plsql.PO_COMMUNICATION_PVT.Get_Preparer_Profile.BEGIN    2    Start of subprogram.
po.plsql.PO_COMMUNICATION_PVT.Get_Preparer_Profile.000    1    p_document_id = 234567
po.plsql.PO_COMMUNICATION_PVT.Get_Preparer_Profile.000    1    p_document_type = PO
po.plsql.PO_COMMUNICATION_PVT.Get_Preparer_Profile.000    1    p_profile_option = SERVER_TIMEZONE_ID
po.plsql.PO_COMMUNICATION_PVT.Get_Preparer_Profile.002    1    x_item_type = POAPPRV
po.plsql.PO_COMMUNICATION_PVT.Get_Preparer_Profile.002    1    x_item_key = 234567-654321
po.plsql.PO_COMMUNICATION_PVT.Get_Preparer_Profile.013    1    l_profile_value is null
po.plsql.PO_COMMUNICATION_PVT.POXMLGENTimezone:     1    Inside Timezone Exception Handler
po.plsql.PO_COMMUNICATION_PVT.POXMLGEN    1    ORA-01403: no data found

Steps to reproduce the issue:
 1. Navigate to Purchasing Responsibility > Purchase Orders
 2. Create a purchase order and submit it for approval
 3. Choose Approve button
 4. Then user gets workflow notification with the error mentioned above.

Changes

 

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
Changes
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.