My Oracle Support Banner

Program 'Create Accounting' Is Running For Exceedingly Long Time (10+ Hours) (Doc ID 1510610.1)

Last updated on JUNE 13, 2018

Applies to:

Oracle Payroll - Version 12.1 HRMS RUP4 and later
Information in this document applies to any platform.

Symptoms


Program 'Create Accounting' is running for 10 hours

From the trace file we can see that the following statement is the issue :
 

  *****************************************************************************
 
  OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
 
  call     count       cpu    elapsed       disk      query    current        rows
  ------- ------  -------- ---------- ---------- ---------- ----------  ----------
  Parse       32      0.03       0.02          0          0          0           0
  Execute     69      3.85   17922.75          8        992        762          53
  Fetch     1291      6.10      10.10       3300     145355          0       25125
  ------- ------  -------- ---------- ---------- ---------- ----------  ----------
  total     1392      9.99   17932.88       3308     146347        762       25178
 
  Misses in library cache during parse: 23
  Misses in library cache during execute: 22
 
 
  OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
 
  call     count       cpu    elapsed       disk      query    current       rows
  ------- ------  -------- ---------- ---------- ---------- ----------  ----------
  Parse     4959      0.23       0.25          0         34         50           0
  Execute  14939      1.04       1.89        429       4185       2029         201
  Fetch    21669      2.11      14.65       4830     207510        132      114692
  ------- ------  -------- ---------- ---------- ---------- ----------  ----------
  total    41567      3.38      16.79       5259     211729       2211      114893
 
  Misses in library cache during parse: 124
 
  Declare
  l_flag Boolean;
  BEGIN
  l_flag := XLA_CREATE_ACCT_RPT_PVT.BeforeReport ;
  if (l_flag) then
  :XDO_OUT_PARAMETER := 1;
  end if;
  end;
 
  call     count       cpu    elapsed       disk      query    current        rows
  ------- ------  -------- ---------- ---------- ---------- ----------  ----------
  Parse        1      0.00       0.00          0          0          0           0
  Execute      1      3.23   17922.21          8         84        738           1
  Fetch        0      0.00       0.00          0          0          0           0
  ------- ------  -------- ---------- ---------- ---------- ----------  ----------
  total        2      3.24   17922.21          8         84        738           1

 

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Running Concurrent Program " Create Accounting"

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.