EGL 8.9+: Journal Edit Program Not Assigning Book Code To Inactive Accounts On The Journal.

(Doc ID 1218463.1)

Last updated on SEPTEMBER 27, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.9 and later
Information in this document applies to any platform.
***Checked For Relevance on 12-Jun-2013***

Symptoms

On : 8.9, 9.0 and 9.1 version, Journal Edit

Journal Edit program not assigning Book Code to Inactive Accounts on the journal.
After running journal edit the journal status is in Error and the journal cannot be posted.
The following error occurs.

ERROR
-----------------------

Header Errors:
US001 JRNL_HDR_STATUS Journal Header Status 5860 51 Suspense account, ALTACCT, or its mapping for balancing errors is not valid.
US001 JRNL_HDR_STATUS Journal Header Status 5860 53 Journal line errors exist for this header.
US001 JRNL_HDR_STATUS Journal Header Status 5860 48 Journal is not balanced on journal totals or balancing ChartField totals.

Line Errors:
2 JRNL_LINE_STATUS Journal Line Status 5860 24 Suspense account, ALTACCT, or its mapping for edit errors is not valid.
2 ACCOUNT Account 9600 32 ChartField error for value 621100 fieldname Account, (prompt table GL_ACCOUNT_TBL).


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Set Up Financials/Supply chain > Install > Installation Options > Overall and make sure Balance Sheet Indicator and Book Code are both enabled.
2. Navigate to Set Up Financials/Supply chain > Common Definitions > Journals > Source and make sure to set Journal Balance Option and Journal Edit Errors Option to Suspend. Also define Balance Suspense ChartFields and Edit Suspense ChartFields.
3. Navigate to General Ledger > Journals > Journal Entry > Create/Update Journal Entries and add a new journal. Make sure one or several lines have an inactive account. Run online journal edit process.


EXPECTED RESULT
-----------------------
Edit Suspense account associated with the Book code (Account Balancing Group) for the Inactive account must be populated and the journal must be balanced and ready to be posted.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot edit and post journals with an inactive account.

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