EGL9.2:CONTROL TOTALS AND ACTUAL TOTALS ARE NOT UPDATED ONCE A JOURNAL IS IMPORTED AND UPDATED USING SPREADSHEET JOURNAL TEMPLATE (Doc ID 2981295.1)

Last updated on OCTOBER 17, 2023

Applies to:

Symptoms

Issue
---------------
General Ledger -  Control Totals and Actual Totals are not updated once you import and modify a spreadsheet journal

Replication Steps
-----------------------
The issue can be reproduced at will with the following steps:

1. Configure the Spreadsheet Journal Template (JRNL1_WS)

2. Create and upload a new journal with 'Edit' option ON

3. Navigate to: Menu > General Ledger > Journals > Journal Entry > Create/Update Journal Entries

The journal Status is V (Valid)

4. Modify the same Journal id using Spreadsheet Template > Journal Lines Amount

5. Reimport the Journal in PIA journal with 'Edit' option ON

6. Navigate to: Menu > General Ledger > Journals > Journal Entry > Create/Update Journal Entries

The journal Status is V (Valid)

7. Observe that Total Debits and Total Credits were correctly updated 

8. Go to Totals Tab and notice that Control Totals / Actuals Totals are not updated.

Please see Replication screenshots for more details.

NOTE: In the <images, examples, video > and/or the attached document, user details/company name/address/email/ telephone number all represent a fictitious sample from the Oracle Demo Vision Database.
Any similarity to actual companies or actual persons, living or dead, is purely coincidental and is in no way intentional on the part of Oracle.

Changes

 Modified the App Engine program GL_JRNL_UPLD ChkUpdt GBL so that the Journal Control Totals are updated upon reimports

Cause

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