EAR 9.2:Duplicate Journals Created In GL If Complete Flag Unchecked on Direct Journal Deposit After Running ARUPDATE (Doc ID 2237485.1)

Last updated on FEBRUARY 27, 2017

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On 9.2 version, the user is able to uncheck the Complete box on the Direct Journal Deposit page after having ran the AR Update. After making modification and checking back the flag and running again the AR Update, the system creates the second GL journal corresponding to the Direct Journal Deposit

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

  1. Add a new regular deposit and select Journal Directly
  2. Create accounting entries for previously created deposit
  3. Accounting entries are created with GL_DISTRIB_STATUS=I as accounting entries are not marked as complete
  4. Mark accounting entries as complete; GL_DISTRIB_STATUS=N on PAY_MISC_DST
  5. Run Journal Generator
  6. After the journal is created the GL_DISTRIB_STATUS=D (Distributed) on PAY_MISC_DST
  7. Uncheck the Complete flag then delete the accounting entries
  8. GL_DISTRIB_STATUS is updated to I after disabling the Complete flag and deleting the accounting entries on the deposit
  9. Recreate accounting entries
  10. GL_DISTRIB_STATUS remains I
  11. Do not Mark accounting entries as complete yet
  12. GL _DISTRIB_STATUS remains I
  13. Mark accounting entries as complete
  14. GL _DISTRIB_STATUS is updated to N
  15. Run Journal generate
  16. After running the journal generator we have a new journal ID and GL_DISTRIB_STATUS updated to D
  17. As of now we have 2 journal created for our deposit ID

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