EAR 9.2: Complete Flag For Direct Journal Payment Is Still Editable If Journaled Into General Ledger Module Even After The Fix From Defect # 25781759 Is Implemented (Doc ID 2285467.1)

Last updated on NOVEMBER 01, 2023

Applies to:

Symptoms

ISSUE:

A problem has been detected in the Directly Journalled Payments tab (Page PAYMENT_MISC_DST_I), from the Modify Accounting Entries functionality for Direct Journal Payment transactions. The Complete flag should always be grayed out (Record Field PS_PAY_MISC_WRK.JOURNAL_COMPLETE) if the Accounting Entries stored into Table PS_PAY_MISC_DST have already been interfaced into FMS General Ledger module (PS_PAY_MISC_DST.GL_DISTRIB_STATUS = 'D').

However, if a series of steps are followed in the proper order, the Complete flag, although initially grayed out, becomes editable for the Users, which is wrong, and can lead to reset the existing Accounting Entries so they can be interfaced into General Ledger module once again.

This is happening even after the fix from initial <Bug 25781759> (AR: Direct Journal Payment Complete Flag (PS_PAY_MISC_WRK.JOURNAL_COMPLETE) Becomes Editable Even If Accounting Entries Have Already Been Journalled Into GL Module) is applied into the environment.

REPLICATION STEPS:

     1.- Log into the FSCM Online Application as User ID VP1
     2.- Navigate to: Accounts Receivable > Payments > Online Payments > Regular Deposit
     3.- Create a new Deposit Group under Business Unit US001, and define on single Payment, marked as Journal Directly
     4.- Navigate to: Accounts Receivable > Payments > Direct Journal Payments > Create Accounting Entries
     5.- Open the recently created Deposit/Payment, and create the needed User Accounting Entries, generate the balancing Cash AR lines, and mark the transaction as Complete
     6.- Navigate to: General ledger > Journals > Subsystem Journals > Generate Journals
     7.- Create a new Run Control ID, with Business Unit US001, and Accounting Definition Name ARDIRJRNL
     8.- Launch the Journal Generator (AE Program FS_JGEN)
     9.- Navigate to: General Ledger > Journals > Journal Entry > Create/Update Journal Entries
     10.- Find the newly created Journal, and launch Journal Edit, and Journal Post
     11.- Navigate to: Accounts Receivable > Payments > Direct Journal Payments > Modify Accounting Entries
     12.- Open the Deposit/Payment at hand, and notice how the Complete flag is selected, and grayed out, in the 'Directly Journalled Payments' tab
     13.- Click on the 'Deposit Control' tab
     14.- Click on the 'Return To Search' button at the bottom of the page
     15.- From the search page, click on the Deposit ID of the transaction in question
     16.- Note that upon returning into the component, the default page is again 'Deposit Control' tab.
     17.- Click now on the 'Directly Journalled Payments' tab
     18.- The Complete flag is now editable, and user can un-select it.
     19.- Un-select the complete check box.
     20.- A Warning Message gets triggered by the system (6040,727)
     21.- Click OK on the Warning Message
     22.- Complete flag is still un-editable, at this stage, so leave it un-selected, and click on Save
     23.- Click on Return To Search button
     24.- Query PS_PAY_MISC_DST Record on the Deposit ID in question, and confirm that the Accounting Lines have a Field GL_DISTRIB_STATUS = 'I'
     25.- Re-open the Deposit ID to the 'Directly Journal;led Payments' tab
     26.- Now the Complete checkbox is editable, so select it, and Save
     27.- Query PS_PAY_MISC_DST Record on the Deposit ID in question, and confirm that the Accounting Lines have a Field GL_DISTRIB_STATUS = 'N'

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

WARNING MESSAGE:

     " Warning -- Please use Direct Journal Entry panel to update the incomplete accounting entries. (6040,727)
       Incomplete direct Journal accounting entries can be updated in the Direct Journal Entry panel. Direct Journal Review panel is used for reviewing complete accounting entries only. "

ACTUAL RESULT:

As the Complete flag is un-grayed, the user can un-select it, and save the changes, which in its turn sets the Record Field PS_PAY_MISC_DST.GL_DISTRIB_STATUS for the Accounting Entries of this Direct Journal Payment from a value of 'D' (Distributed), to 'N'. This will allow this very same Accounting Entries to be picked up by Journal Generator, and create a second Journal for the exact same transaction, which will be posted into the Ledger, duplicating the amounts initially booked.

EXPECTED BEHAVIOR:

If the Direct Journal Payment Accounting Entries have been journalled into General Ledger module, and further edited, and posted, the Direct Journal Payment should be kept as Complete, and not allow to edit this flag anymore.

Changes

Cause

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