EAR9.1: Accounting Entry Out Of Balance Error When Loaded Items From ExcelToCI

(Doc ID 2324051.1)

Last updated on NOVEMBER 01, 2017

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On: 9.1 Bundle 25, ExcelToCI

Issue:
------------------------------
After loading data via ExcelToCI, and when trying to post it, "Accounting entries are out of balance (6030,20)" error occurred.
When the last line is deleted and re-entered with the same information, it is balance and successfully posted.
The out of balance is due to ledger base amount, where the ledger base amount is multiplying upon adding of the line.

Error:
------------------------------
Accounting entries are out of balance (6030,20)

Step:
------------------------------
1. Create group control, pending item and distribution in the ExcelToCI template with CREATE mode (Entry Type = CR) and load it. Load completed correctly.
2. Verify records are loaded on the Pending Item page.
3. Try to update records which has already loaded with UPDATE mode (add 1 more distribution line.) and load it. (Load completed correctly.) => populate MONETARY_AMOUNT
4. Verify records are loaded on the Pending Item page. (Added 1 more distribution line.)
5. Select “Batch Priority” for Posting Action but Accounting Entry Out of Balance error occurred.

Actual Result:
------------------------------
After loading data via ExcelToCI, and when trying to post it, "Accounting entries are out of balance (6030,20)" error occurred.

Expected Behavior:
------------------------------
When trying to post loaded data via ExcelToCI, no errors occur.

Business Impacts:
------------------------------
Due to this issue, users cannot post data which loaded via ExcelToCI.

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