AR To GL Reconciliation Report Runs For Long Hours (Doc ID 2262493.1)

Last updated on MAY 04, 2017

Applies to:

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

Symptoms

Applied the following RPCs and noticed the AR to GL Reconciliation Report runs for long hours.

Patch 20255342 -RG R12.1: General Ledger Recommended Patch Collection (FSG), February 2015
Patch 20251722 -GL R12.1 General Ledger Recommended Patch Collection, February 2015
Patch 21562032 -FUN R12.1: Financials Common Module Recommended Patch Collection (RPC), Aug 2015
Patch 22468218 -XLA R12.1: Subledger Accounting Recommended Patch Collection (SLA), Feb 2016
Patch 22384200 -AP R12.1: Payables Recommended Patch Collection (Core AP), Feb 2016
Patch 22471504 -AR R12.1: Receivables Recommended Patch Collection (RPC), Feb 2016
Patch 22350639 -IBY R12.1: Payments Recommended Patch Collection (IBY), Feb 2016
Patch 22455213 -CE R12.1: Cash Management Recommended Patch Collection (RPC), February 2016
Patch 22526147 -OIE R12.1: Oracle Internet Expenses - Recommended Patch Collection, Feb 2016

You applied patch 25143854 and still the issue exists.

AWR report shows:

82,816.47 0 85.60 96.84 0.02 2mvuj9mj7g7j1 ARGLRECR insert into ar_gl_recon_gt(co...
82,816.47 0 85.60 96.84 0.02 7260sgmpkw3yb ARGLRECR BEGIN ARP_RECON_REP.arglrecon_...

2mvuj9mj7g7j1
insert into ar_gl_recon_gt(code_combination_id, receivables_dr, receivables_cr, account_type, account_type_code, account, company) (select dat.code_combination_id, sum(nvl(acctd_amount_dr, 0)) receivables_debit, sum(nvl(acctd_amount_cr, 0))

Trace file shows:

Insert into ar_gl_recon_gt(code_combination_id,receivables_dr,receivables_cr,
account_type, account_type_code,account,company)
...
group by dat.code_combination_id,lookup.description,
gc.code_combination_id,gc.account_type,
gc.SEGMENT1||'-'||gc.SEGMENT2||'-'||gc.SEGMENT3||'-'||gc.SEGMENT4||'-'||gc.SEGMENT5||'-'||gc.SEGMENT6||'-'||gc.SEGMENT7||'-'||gc.SEGMENT8||'-'||gc.SEGMENT9
, gc.SEGMENT1 )

call      count    cpu         elapsed    disk        query         current    rows
------   ------ --------      ----------   ---------- ----------   ---------- ----------
Parse    1        0.17        0.16         0            0                0           0
Execute 1       14944.27  15767.98  1355717 1541181483 1           0
Fetch     0       0.00         0.00         0           0                 0           0
------- ------ --------       ---------- ---------- ---------- ---------- ----------
total      2      14944.44  15768.14 1355717 1541181483   1           0

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