EGL9.2:After Enabling Journal Source Security, If Multiple Journals Are Posted Using A Single Run Control ID, The Journal Security Log Is Not Created For All Journals. (Doc ID 2913801.1)

Last updated on JANUARY 24, 2023

Applies to:

Symptoms

Issue
---------------

Journal security log has not generated for multiple requests in Journal Post Run Control ID.


Replication Steps
-----------------------
1. Enable Journal Source Security with "Period End Cut Off day"
Main Menu > Set Up Financials/Supply Chain > Security > Journal Source Security BU
Use ALO source for our test

2. Enable Journal Source Security by User id and select the checkbox "Override Period End Cutoff"
Main Menu > Set Up Financials/Supply Chain > Security > Journal Source Security User (check Override Period End Cutoff)

3. Setup Period End Cutoff Date for ALO source with "7th Sep 2022"
Main Menu > Set Up Financials/Supply Chain > Common Definitions > Journals > Journal Source Security > Period-End Cutoff Schedule
Any journals with date bigger date as 07th Sep 2022 will be posted because the VP1 will override the Period End Cutoff and the Journal Security will create a log

4. Create 2 journals and edit them: "0000000763 and 0000000764"
Main Menu > General Ledger > Journals > Journal Entry > Create/Update Journal Entries

5. Run Journal Post process for both journals having 2 requests included
Main Menu > General Ledger > Journals > Process Journals > Post Journals

6. Checked the log message of GL_JP and observed that both journals were posted as per "Journal Source Security by User id" setup

7. Journal Source Security log was created and observed that only one request in Run Control ID is posted. Only one journal id 0000000764 is mentioned in the log which is incorrect. It should be both journal ids mentioned since both overrides the Period End Cutoff setup.

This is the issue.

Please see Replication screenshots for more details.

Cause

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