R12 PROJECTS AUD Supplier Cost Audit Report Is Taking 16 Hrs To Run For 1 Project/2 Months (Doc ID 1547279.1)

Last updated on AUGUST 01, 2016

Applies to:

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

Symptoms

The PAXAUGLT AUD: Supplier Cost Audit Report performance is slow and takes more than 16 hours to complete for a single project.  The SQL query with the slow performance is:

SELECT vend . segment1 Supplier_Number , vend . vendor_name Supplier_Name ,

to_number ( DECODE ( : P_SORT_ORDER , 'PO' , PA_Adjustments . Get_PO_Info (
'PO HEADER ID' , apdist . po_distribution_id ) , NULL ) ) PO_Header_ID ,
DECODE ( : P_SORT_ORDER , 'PO' , PA_Adjustments . Get_PO_Info ( 'PO NUM' ,
apdist . po_distribution_id ) , NULL ) PO_Number , to_date ( DECODE ( :
P_SORT_ORDER , 'PO' , PA_Adjustments . Get_PO_Info ( 'PO DATE' , apdist .
po_distribution_id ) , NULL ) , 'DD-MON-YYYY' ) PO_Date , PA_Adjustments .
Get_Displayed_Field ( 'INVOICE TYPE' , ap . invoice_type_lookup_code )
Invoice_Type , ap . invoice_num Invoice_Number , ap . invoice_date
Invoice_Date , to_number ( DECODE ( : P_SORT_ORDER , 'AP' , PA_Adjustments
. Get_PO_Info ( 'PO HEADER ID' , apdist . po_distribution_id ) , NULL ) )
AP_PO_Header_ID , DECODE ( : P_SORT_ORDER , 'AP' , PA_Adjustments . .....

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