The Post Journals Program Performance Is Very Low Even For Small Batches (Doc ID 2580853.1)

Last updated on MAY 26, 2020

Applies to:

Symptoms

ACTUAL BEHAVIOR  
---------------
- When posting large journal the run-time is more than 6-7 hours.

- Even for small batches the time to post takes around 6 minutes.

EXPECTED BEHAVIOR
-----------------------
The posting Journal should not take that long

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use FBDI to upload conversion journals (6K rows).
2. Post the batch. It takes around 7 hrs.

OR

1. Post a small batch (200 lines) and the process takes 6 minutes, when it should take seconds.

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.