My Oracle Support Banner

The Reversal Acc Entries LCY Amount Is Not Same As Txn Creation Acc Entries In ACVW_ALL_AC_ENTRIES (Doc ID 2982981.1)

Last updated on OCTOBER 26, 2023

Applies to:

Oracle Banking Payments - Version and later
Information in this document applies to any platform.


On : version, Implementation Support

The reversal acc entries LCY amount is not same as txn creation acc entries in ACVW_ALL_AC_ENTRIES

Observation :
The LCY_AMOUNT is not having same value for Reversal entries to DRLQ and CRLQ.
In accounting reversal logs however its is observed the value is correct, and also in PMTB_ACCOUNTING_ENTRIES, but the XML request created is having 1 unit difference in CRLQ/ DRLQ to REVR Acc entries.

The issue can be reproduced at will with the following steps:
1. Create a Xborder current value dated Txn in PXDOTONL with same Dr and Cr CCY but it should not be same as branch's LCY CCY.
2. Save and authorize the same.
3. Launch PXSOVIEW and filter for the newly created txn.
4. Select the txn and click on Reverse.
5. In PXDTRNRV provide the appropriate reason code and authorize the reversal.
6. Query the Txn in ACVW_ALL_AC_ENTRIES with EXTERNAL_REF_NO for the column LCY_AMOUNT.

The issue has the following business impact:
Due to this issue, User cannot get the reversal acc entries LCY amount is not same as txn creation acc entries .


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

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