You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

AP_INVOICES_UTILITY_PKG.GET_APPROVAL_STATUS p[erformance

in Payables, Payments & Cash Management

Summary:

Performance issue in AP_INVOICES_UTILITY_PKG.GET_APPROVAL_STATUS pkg

Content (please ensure you mask any confidential information):

Hi,

I am using

SELECT distinct DECODE(AP_INVOICES_UTILITY_PKG.GET_APPROVAL_STATUS(AIA.INVOICE_ID,AIA.INVOICE_AMOUNT,AIA.PAYMENT_STATUS_FLAG,AIA.INVOICE_TYPE_LOOKUP_CODE),
'UNPAID' , 'Unpaid',
'APPROVED' , 'Validated',
'FULL' , 'Fully Applied',
'NEVER APPROVED' , 'Never Validated',
'NEEDS REAPPROVAL' , 'Needs Revalidation',
'CANCELLED' , 'Cancelled',
'AVAILABLE' , 'Available',
'UNAPPROVED' , 'Unvalidated',
'PERMANENT' , 'Permanent Prepayment',
'INCOMPLETE' , 'Incomplete'
) Validation_Status FROMAP_INVOICES_ALL AIA

code to retrieve the invoice status. This was working fine till 24D. We received 25A last month and since then this parameter takes a very long time to return the results.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!