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 DECEMBER 06, 2016

Applies to:

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

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms