My Oracle Support Banner

AR_S_00065 DATA ISSUE IN AR_DISTRIBUTIONS FOR TAX AND DEFERRED_TAX LINES (Doc ID 2739659.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Receivables - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

BEST PRACTICES:

  1. Run the Receivables Period Close Analyzer before closing the period to proactively identify this issue, as well as many other issues that will prevent you from closing the period.

  2. If you post to multiple EBS subledgers, use the EBS Period Close Process Analyzer for a smoother period close.

 

 

Release 12 Subledger Accounting.

When running Create Accounting there is receipt with following error:
The subledger journal entry does not balance in the entered currency.  Please verify the entered amounts on the journal entry lines.

The accounted amount and entered amount for the subledger jounral entry line have different sign.  Please inform your system
administrator or support representative that:
The sources assigned to the accounting attributes Accounted Amount and Entered Amount have different sign for extract line number
XXXXXXX. Please make sure the sources assigned to the two accounting attributes have same sign, or assign different sources to these
accounting attributes.

Issue is happening when applying receipt to certain invoices and using deferred tax, there is issue in ar_distributions.
In ar_distributions for some TAX and DEFERRED_TAX lines the amounts are populated with amount_dr and acctd_amount_cr or amount_cr and acctd_amount_dr.

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
Cause
Solution
References


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