My Oracle Support Banner

PO Output For Communication Has Performance Issue For Large Blanket Purchase Agreements (Doc ID 2464504.1)

Last updated on FEBRUARY 25, 2019

Applies to:

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

Symptoms

Actual Behavior
PO Output for Communication program (POXPOPDF) is having performance issues when it is run for large Blanket Purchase Agreements (having around 50K+ Lines). It takes hours (3+) to complete.

Expected Behavior
PO Output for Communication program should not take much more time to complete when running for large BPAs

Steps to Reproduce:
 1. Navigate to Purchasing responsibility > Purchase Orders > Purchase orders
 2. Open a Blanket Purchase Agreement (BPA) which has large number of Lines (i.e.: 50K+ lines)
 3. Modify that BPA
 4. Then submit it for approval
 5. Once BPA is approved, PO Output for Communication program is automatically launched and runs for hours before it completes
 6. Tkprof of costly sql shows figures similar to the following:

    SELECT fl.file_name, fl.file_data
    FROM fnd_attached_docs_form_vl fav, fnd_lobs fl
    WHERE ((fav.pk1_value=:1 AND fav.entity_name  ='PO_HEADERS')
    OR (fav.pk1_value = (SELECT vendor_id FROM po_headers_all WHERE po_header_id=:2 )
    AND ...

    call    count       cpu    elapsed    disk      query  current   rows
    ------ ------  -------- ---------- ------- ---------- -------- ------
    Parse       1      0.00       0.00       0          0        0      0
    Execute     1      0.68       0.68       0          0        0      0
    Fetch       1  11323.41   11515.62   27868  364449062        0      0
    ------ ------  -------- ---------- ------- ---------- -------- ------
    total       3  11324.09   11516.30   27868  364449062        0      0

Note - Issue can also occur launching PO Output for Communication program (POXPOPDF) manually for large BPAs

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.