My Oracle Support Banner

Create Accounting fails with Error : Entered Amount and Accounted Amount for Line Are Not on the Same Side (Doc ID 1457829.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Receivables - Version 12.0.6 to 12.1.3 [Release 12.0 to 12.1]
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.

 

Create Accounting fails for few cases with the following error:

ERROR
-----------------------
The entered amount and accounted amount for line 1 are not on the same side.

The accounted amount and entered amount for the subledger journal 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 -1934520.
Please make sure the sources assigned to the two accounting attributes have same sign, or assign different sources to these accounting attributes.

Responsibility:  Receivables Manager
Navigation:  Transactions > Transactions
1. Create an Invoice with multiples lines
2. Choose a small exchange rate
3. The Sum of Invoice lines should be zero
    For e.g., create an Invoice in foreign currency with 0.026228647759481894190031122047886025153 and enter 6 lines with following amounts
       3346.88
    -16734.38
       3346.88
       3346.88
       3346.88
       3346.88

Subledger Accounting Program Report shows

Journal Entry Description Invoice Transaction Type - Inv-Consult-East
Invoice Transaction Number - 505733 Document Sequence Category - Document
Number - Journal Entry Status Invalid

                                                     --Entered--- -Accounted--
 Line Accounting Class  Account             Currency Debit Credit Debit Credit
 1    Receivable       01-000-1210-0000-000 INR       0.02                0.02
 2    Revenue          01-140-4150-0000-000 INR              0.02  0.02
 Journal Entry Total 0.02 0.02
 
 Line Error Number Error Message
 2 95314 The entered amount and accounted amount for line 1 are not on the same side.

XLA_AE_LINES shows:
RECEIVABLE Entered_DR = 0.02, Accounted_CR = 0.02
REVENUE     Entered_CR = 0.02,  Accounted_DR = 0.02

It may come if header level rounding is disabled in System Options.

NOTE: Data issues similar to this may also occur for Receipts.

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
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patches
 Still Have Questions?
References


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