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:

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

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