My Oracle Support Banner

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 JULY 04, 2023

Applies to:

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


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

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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