Error: 95340

Create Accounting For Payments End With Error: 95340 [ID 1091089.1]

Applies to:

Oracle Payables - Version: 12.0.4 and later   [Release: 12.0 and later ]
Information in this document applies to any platform.

Symptoms

Payables Create Accounting in the secondary ledger for Payments display the following error in the Create Accounting output file.

Error 95340: The total debits and the total credits do not balance for this subledger journal entry. Please ensure that the application accounting definition Accrual Basis owned by Oracle contains journal line types for the event class Payments and event type Payment Created that can create a balanced entry. Also verify that any conditions associated with a journal line type are correct.

The difference between the accounted debits and the accounted credits is .01

Cause

This issue has been identified and clarified through Bug 7262976 SHOWSTOPPER:PAYMENTS 804 & 833 NOT CONVERTED TO SECONDARY LEDGER

Setup issue
The suspense account for secondary ledger was not enabled.
The option for balancing the Accounting lines by Ledger Currency was not enabled.

Solution

In order to correct this accounting error, perform the following setup:

1. Enable rounding suspense account for secondary ledger where the rounding difference between
LIAB/GAIN and ITEM EXPENSE can be captured thereby accounting will be successful.

In GL, in the Accounting Setup self service page, query for the ledger.
Under the Ledger Options, update -> on the second page, there are two accounts
- Suspense Account
- Rounding Differences Tracking Account
provide a rounding/suspense account where the rounding difference will be booked.

2. Set the option for balancing the Accounting lines by Ledger Currency to create the balancing
lines.

In GL, in the Accounting Setup Manager Self service page, query for the ledger.
Under Ledger Definition , there will be a checkbox for 'Balance Subledger Entries by Ledger
Currency' .
Check this option and save the changes