EGL9.2: On Fluid Page,the Pending Approval Count Not Matching With The Total Items That Appear For Classic View Manage Journal Approvals
Last updated on SEPTEMBER 27, 2017
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On : 9.2 version, Journal Entry
Case 1: On the Fluid page, the pending approval count is not matching with the total items that appear for approval when user process a journal to be deleted from the journal lines page. Still the list with all the journals that needs approval matches the Manage Journal Approval page results.
Case 2: Journals which were getting edited ,after submitted for approval, clears the old thread that was created during the first time submission and new thread is getting generated for second time submission of the journal .
The record PS_EOAW_SUMM_DTL is remaining with pending status for the thread that was cleared first time of submission.
The above two scenarios are constituting the issue with respect to count.
PS_HMAP_SUMMDTL_VW is responsible for the count across the Fluid page.
PS_HMAP_SUMMDTL_VW is a join of two physical records and one which is creating the issue is because of PS_EOAW_SUMM_DTL’s EOAWUSTEP_STATUS field which is having status as P, even though the Journal is approved.
The Fluid page counter should show the correct number of journals pending approval.
The issue can be reproduced at will with the following steps:
1. Create a journal entry, edit and submit for approval
2. Select Delete journal from Journal lines tab > Process
3. Check the results on:
a) General Ledger > Journals > Journal entry > Manage journal approvals
b) Fluid Home > Approvals > Journal entry
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