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 APRIL 04, 2025

Applies to:

Symptoms

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.

Cause

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