R12 AP: Performance Problem with Invoice Validation (APPRVL) (Doc ID 1112874.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.0.4 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
Performance Problem with Invoice Validation (APPRVL)
***Checked for relevance on 25-Dec-2015***

Symptoms

Performance Problem with APPRVL

$Header: apiindis.pls 120.14.12000000.3 2009/06/08 05:50:13 vasvenka ship $ *
$Header: apiindib.pls 120.59.12000000.28 2010/03/09 11:02:09 sbonala ship $ *
$Header: zxifnewsrvcspubs.pls 120.0.12000000.1 2008/09/19 23:00:48 hongliu noship $ *
$Header: zxifnewsrvcspubb.pls 120.0.12000000.1 2008/09/19 23:00:37 hongliu noship $ */
$Header apetxsrs.pls 120.10.12000000.5 2009/07/14 11:55:04 dcshanmu ship $
$Header apetxsrb.pls 120.81.12000000.88 2009/08/20 13:38:20 pgayen ship $
$Header apsin.odf 120.46.12000000.14 2009/05/13 19:12:28 bgoyal ship $
$Header: apaprvlb.pls 120.94.12000000.94 2009/08/26 10:57:07 sbonala ship $
zxifgblparampkgs.pls 120.89.12000000.8


Following SQL was performing poorly:

 

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