R12 AP: Invoice Validation Performance Slow
(Doc ID 1141814.1)
Last updated on JANUARY 16, 2018
Applies to:Oracle Payables - Version 12.1.1 to 12.1.1 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 14-Dec-2015***
On 12.1.1 ,
There is a delay when the invoice validation is requested from the following path
Account Payable > invoices > invoice actions > validate
One of the SQL statements that is taking long time is the following:
SET tax_already_calculated_flag = NULL
WHERE ail.invoice_id = p_invoice_id
AND nvl(ail.tax_already_calculated_flag, 'N') = 'Y'
AND NOT EXISTS
(SELECT 'Line Determining Factors Exist'
from zx_lines_det_factors zf
where zf.application_id = 200
and zf.entity_code = 'AP_INVOICES'
and zf.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES',
and zf.trx_id = ail.invoice_id
and zf.trx_line_id = ail.line_number);
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|