My Oracle Support Banner

R12:PA:Slow Performance Of Request ‘EXC: Transaction Exception Details By PA Period’ (Doc ID 1641212.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Cost Reporting

ACTUAL BEHAVIOR
---------------
Slow performance of request ‘EXC: Transaction Exception Details by PA Period’


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ‘EXC: Transaction Exception Details by PA Period’, and it shows slow performance.
Report ran more than two hours, target time is 10 minutes.

Please see the following expensive query:

begin fnd_conc_stat.collect; end;


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      2      0.00       0.00          0          0          0           1
Fetch     1610     41.77    1289.95     331279     586862          0        3218
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total     1613     41.77    1289.95     331279     586862          0        3219

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, ===> Finance reporting delayed. Not able to close period on time.

Cause

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
Symptoms
Cause
Solution
References


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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.