11.5.10 Accrual Reconciliation Report - Latest Fixes as of July 2017 (Doc ID 427771.1)

Last updated on JULY 22, 2024

Applies to:

Purpose

In Release 11.5.10, there have been several bug fixes related to the Accrual Reconciliation Report and Accrual Reconciliation Rebuild process (formerly called the 'Accrual Rebuild Reconciliation Report). This document is provided to guide customers in how to obtain the latest bug fixes and performance enhancements related to these concurrent programs.

Scope

To get the latest fixes for the Accrual Reconciliation Rebuild process and the Accrual Reconciliation Report, the following steps should be performed in the order listed:

1. Apply <Patch 5109317> ("CONSOLIDATED FIXES FOR THE ACCRUAL RECONCILIATION REPORT").

Updated files versions:
POXACCWO.fmb version 115.23.11510.12
poxacwro.ldt version 115.0.11510.3
POXACREC.rdf version 115.80.11510.34
POXACCWO.pld version 115.10.11510.10

2. Apply <Patch 5161329> ("CST:POXACRCR ACCRUAL REBUILD RECONCIL RPT ERRORS FOR A LARGE PERIOD").

Note: Although the readme file in patch 5109317 states to apply patch 5115636, this one should actually be applied instead. Patch 5161329 contains an updated version of file cst4151070.sql which was not available at the time 5109317 was created.

Updated file versions:
POXACREC.rdf version 115.80.11510.36

3. Apply <Patch 5200436> ("Consigned Inv consolidated bugfix patch -- CORRUPT CONSUMPTION ADVICE RELEASES CREATED").

Updated file versions:
i4645731.ldt version 115.0.115100.3
invcons.odf version 115.13.115100.3
INVMCTUPG.sql version 115.1
INVRCADB.pls version 115.55.115100.30
INVVTPSB.pls version 115.22.115100.4

4. Apply <Patch 5715136> ("ACCRUAL RECON REPORT (POXACREC) DOES NOT DISPLAY THE BLANKET RELEASE NUMBER").

Updated file versions:
POXACCWO.fmb version 115.23.11510.15
po_accrual_reconcile_temp_v.xdf version 115.0
POXACREC.rdf version 115.80.11510.51
POXACCWO.pld version 115.10.11510.12

5. Apply <Patch 6618320> ("ACCRUAL RECONCILIATION REPORT NO LONGER HAS ACCRUAL ACCOUNT PARAMETER").

Updated file versions:
cstcp6618320.ldt version 115.0
POXACREC.rdf version 115.80.11510.57

6. Apply <Patch 8653574> ("7243510 ACCRUAL RECONCILE REPORT, LOV").

Updated file version:
cstvs8653574.ldt version 115.0.115100.1

7. Apply <Patch 12587113> - ("DISCREPANCY IN AP ACCRUAL RECONCILLATION REPORT AND GL ACCOUNT ANALYSIS REPORT.")

Updated file version:
POXACREC.rdf version 115.80.11510.81

8. Apply <Patch 14224615> ("ACCRUAL RECONCILIATION REPORT OMITS RETROACTIVE PO PRICE ADJUSTMENT.")

 Update file version:

POXACREC.rdf version 115.80.11510.83

You can use sql plus to confirm if the patches are applied:

SQL>select bug_number, creation_date from ad_bugs
where bug_number in ('5109317','5161329','5200436','5715136','6618320','8653574','12587113','14224615');

Note: After these patches are applied, the "Accrual Reconciliation Rebuild" process should no longer be submitted directly by users. Instead, a new concurrent program called the "Accrual Reconciliation Rebuild Manager" has been created and should be used instead. It will launch child processes which will rebuild the accrual data for each of the accrual accounts. It may be necessary for the System Administrator to add this new concurrent program (POXARRM) to the request group of the responsibility being used.
Details about these changes are available in the Patch Readme files. (The information has been added below)

8. In System Administrator, run 'Compile Report Parameters'
9. In System Administrator, run 'Gather Schema Statistics'.
10. Submit the Accrual Reconciliation Rebuild Manager.
11. Submit the Accrual Reconciliation Report.

--------------------------------------------------------------------------------
The following is the excerpt from the Patch Readme's regarding the change over to the
Accrual Reconciliation Rebuild Manager.

As part of the performance changes for patch 6639490 the following
changes have been done and hence is important for anybody to read the
following before applying this patch.

A) Accrual Reconciliation Rebuild program can no more be run directly.

B) New Concurrent program "Accrual Rebuild Manager" has been created

C) The new concurrent program launches spawned child workers which
process the Accrual data and once all the launched child requests
complete, the parent request completes.

D) The Number of child workers spawned/launched is based on the
parameter "No. of Child Workers" value provided while launching
the new concurrent program. However, if the Number of Accrual Accounts
are less than the value provided for the new parameter, then only
that many child requests are launched as the Number of Accrual Accounts.

E) In case any child requests errors out, then the the parent request
is also errored out after all the other child requests are complete
so as to avoid any possible locking issues in case the Accrual
Reconciliation Manager program is launched again.

F) In case the "Accrual Rebuild Manager" completes in error, then this
program has to launched again with the same set of parameters so that
the Accrual data is processed again for all the Accounts correctly.

Details

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