My Oracle Support Banner

Adjustment JLT for DEFERRED_TAX is Missing for AAD: MFAR_ADJ_ACCRUAL_ACCOUNT - Create Accounting Error - The Subledger Journal Entry Does Not Balance in the Entered Currency. Please Verify the Entered Amounts on the Journal Entry Lines (Doc ID 1666982.1)

Last updated on JULY 14, 2020

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
EXECUTABLE:ARACCPB - Submit Accounting
EXECUTABLE: XLAACCUP - Accounting Program


In Accounts Receivable, you are creating Adjustments against Invoices, with deferred tax.
The DEFERRED_TAX / Tax Journals are generated correctly, in the AR_DISTRIBUTIONS_ALL table.
In XLA, the DEFERRED_TAX side of the Journal is missing.

The Create Accounting program is successfully processing the invoices, but the Adjustment fails the Create Accounting with the following error:

The subledger journal entry does not balance in the entered currency. Please verify the entered amounts on the journal entry lines.

Reviewed the adjustment diagnostics and it indicates the accounting for AR_DISTRIBUTIONS_ALL.SOURCE_TYPE = DEFERRED_TAX (line_id 217362) was not generated in XLA_DISTRIBUTION_LINKS.

Ledger linked to Application Accounting Definitions (AAD): Multi-Fund Account Receivables Accrual - Account Method (MFAR_ACCRUAL_ACCOUNT).

Steps to Reproduce:
Create an adjustment against a deferred tax invoice number.
Run create accounting for the adjustment and it fails due to unbalanced journal.


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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