R12:PA: EXC: Transaction Exception Details By Pa Period With AP Invoice Exceptions Performance Is Slow (Doc ID 1356489.1)

Last updated on AUGUST 01, 2016

Applies to:

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

Symptoms


The PAXEXCPS EXC: Transaction Exception Details by PA Period report has poor performance when run with the parameter: ap_inv_excp is selected. No performance issue is encountered when run with any other parameter or with no parameter.

The most expensive query is:

SELECT DECODE(NVL(:B4 ,'N'), 'Y', PA_UTILS2.GET_PA_DATE( :B3 ,:B2 ,:B1 ), 'N',
PA_INTEGRATION.GET_RAW_CDL_PA_DATE(:B3 ,:B2 ,:B1 ))
FROM
DUAL


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 9918438 3049.64 3042.95 0 0 0 0
Fetch 9918438 572.08 573.99 0 0 0 9918438
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 19836877 3621.72 3616.94 0 0 0 9918438

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