My Oracle Support Banner

Optimistic Lock Exception In GEBSFRCY And GEBSFMLC (Doc ID 2915050.1)

Last updated on DECEMBER 13, 2022

Applies to:

Oracle FLEXCUBE Enterprise Limits and Collateral Management - Version 14.5.0.0.0 to 14.5.0.0.0 [Release 14]
Information in this document applies to any platform.

Goal

 To solve Optimistic Lock Exception in GEBSFRCY and GEBSFMLC when parallel EOD for all branches

On : 14.5.0.0.0 version, Implementation Support

ACTUAL BEHAVIOR
---------------
Optimistic Lock Exception in GEBSFRCY and GEBSFMLC


EXPECTED BEHAVIOR
-----------------------
Lock exception not occurs when parallel EOD for branches

STEPS
-----------------------
1. Triggered parallel EOD for all branches.
2. Main_Line change records in branch 021 not processed and currency revaluation in facility for branch 001 not happened.
3. From the logs it is observed that Optimistic error is encountered.
4. From our observation, optimistic error came in GEBSFMLC for 021 as it is trying to update same facility at same time in both GEBSFMLC and GEBSFRCY batch.
5. From our observation, optimistic error came in GEBSFRCY for 001 as it is trying to do revaluation for same facility in both 001 and 002 at the same time for different currency combination.

 

Solution

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
Goal
Solution


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