My Oracle Support Banner

R12: AP/XLA: Error ‘95340: The Total Debits and Credits Do Not Balance for This Subledger Journal Entry’ When Attempting To Account a Standard Invoice After Prepayment Application Using a Custom Subledger Accounting Method (Doc ID 3059114.1)

Last updated on NOVEMBER 14, 2024

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle Subledger Accounting - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the Create Accounting concurrent program, the following error occurs for a standard invoice after the prepayment application:

Error Number: 95340

Error Message: The total debits and the total credits do not balance for this subledger journal entry. Please ensure that the application accounting definition XXX_AP_ACCRUAL owned by User contains journal line types for the event class Prepayment Applications and event type Prepayment Applied that can create a balanced entry. Also verify that any conditions associated with a journal line type are correct.


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

  1. Create a foreign currency Prepayment invoice with exchange rate X.
  2. Pay the prepayment invoice.
  3. Create a foreign current Standard invoice with exchange rate Y.
  4. Apply Prepayment invoice to standard Invoice.
  5. Run concurrent program Create Accounting
    Go to Payables responsibility
    Other - Requests - Run
    Single Request - OK

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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