GLXRCENT GLXRCREV Journal Reconciliation/Reverse Reconciliation Forms Do Not Synchronize Totals When Lock Error Occurs (Doc ID 2051900.1)

Last updated on JULY 21, 2017

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
Form:GLXRCENT.FMB - Journal Reconciliation
Form:GLXRCREV.fmb - Reverse Reconciliation

Symptoms

On : 12.1.3 version, Journal Entry

ACTUAL BEHAVIOR
---------------
If multiple users reconcile/unreconcile the same journal at the same time, then a locking error occurs and the Totals amount is not synchronized causing data corruption.

EXPECTED BEHAVIOR
-----------------------
Even if lock error occurs, the Totals amounts are initialized.

STEPS
-----------------------
Navigate: Journals > Reconciliation > Reconcile
S1 = User 1
S2 = User 2
1. S1 - Query Reconcile Journal Lines
2. S2 - Query Reconcile Journal Lines
3. S2 - Check any Reconcile Journal Line
4. S1 - Check Reconcile Journal Line same as Step3. Lock error occurs and Totals are updated.
5. S1 - No to the lock error message. OK to FRM-40501 message. Totals is not cleared.
6. S1 - Check Reconcile Journal Line couple of Step3. Totals are balanced
7. S1 - Click Reconcile button, it will saved and create invalid reconcile.

Navigate: Journals > Reconciliation > Reverse
1. S1 - Query Reverse Reconcile Journal Lines
2. S2 - Query Reverse Reconcile Journal Lines
3. S2 - Check any Reverse Reconcile Journal Line
4. S1 - Check any Reverse Reconcile Journal Line  couple of Step3
5. S1 - Check any Reverse Reconcile Journal Line same as Step3. Lock error occurs and Totals are updated.
6. S1 - No to the lock error message. OK to FRM-40501 message. Totals is not cleared.
7. S1 - Click Unreconcile button
8. S1 - Click Unreconcile button, it will saved and create invalid unreconcile.

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