Advanced Benefits - PSFT (MOSC)

MOSC Banner

Events and Notification framework table EOEN_CONFIG Lock issue

edited Mar 30, 2022 1:23PM in Advanced Benefits - PSFT (MOSC) 4 commentsAnswered

Hi All,

We are facing an issue events frame work table lock(EOEN_CONFIG) when multiple transactions related to job data is happening. for ex: When users running job mass update programs / running HRCMP015 / doing Job data online transactions  we could see spinning issue on the Job data page. when we query back end we could able to see that there is a table lock on record  EOEN_CONFIG . Peoplecode function GetNextNumberWithGapsCommit() is trying to get  EOEN_LAST_ID  + 1 but as there were many transaction happening on job data going on (Mass update/CMP015) it is holding up that record. We also set the DBFlagvalue to 8 in App and process scheduler configuration files to establish secondary connection as

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center