Incorrect AP And PO Accrual Reconciliation Report (Doc ID 2233825.1)

Last updated on FEBRUARY 14, 2017

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Excise - Procure to Pay Cycle

ACTUAL BEHAVIOR
---------------
AP and PO Accrual Reconciliation Report is showing lines which are fully written off.

EXPECTED BEHAVIOR
-----------------------
Write off Functionality after application should not leave any rounding balances that must be written off again.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables - India localization - 12.1.3
Production instance

2. Path: Other -> Requests -> Run
3. Run the AP and PO Accrual Reconciliation Report

AP and PO Accrual Reconciliation Report is showing lines which are fully written off.
For example: PO 30009292 9 25 1 2

The difference is already written off but it is still appearing in Report with total as 0.
There are around 10000 Lines appearing due to this issue.


Workaround:
Use auto-write-off Functionality to write off the zero and other small transactions appearing
on the report.
Refer to:
How to perform the Write off for amounts in AP And PO Accrual Reconciliation
Report and things to consider (Doc ID 2147171.1)

Feedback: Since write Off is done using the write Off Functionality there should
be no zero balances appearing on the Report after Write Off is completed.

4. For example PO#30009292

PO_DISTRIBUTION_ID 22449158

PO BALANCE -28,567.90

AP Balance 32,397.79
  ============
Difference 3829.89

Write Off -3,829.90
  ============

Balance -0.01


Write off Functionality after application should not leave any rounding balances that must be written off again.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:

There are more than 2500 po_distribution_ids appearing and that is causing more than 10000 incorrect lines in GRNI report.

It is affecting an internal audit and Quarter end is already done.
Need the fix asap before reporting which is anytime now.

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