Add a New Employee in France On Job Information Throws Error - ErrorReturn-> 148 - Think-time PeopleCode event (Warning), but a SQL update has occurred in the commit interval. (2,148) (Doc ID 2369399.1)

Last updated on JANUARY 26, 2024

Applies to:

Symptoms

ISSUE :

-----------
An employee hire in France throws the following error message when trying to save

Think-time PeopleCode event (Warning), but a SQL update has occurred in the commit interval. (2,148) HCR_PUBLICATION_RULES.PersonContractPublication.OnExecute Name:PersonContractPublication PCPC:3511 Statement:51
Called from:JOB_DATA_EMP.GBL.SavePostChange Statement:16

Think-time PeopleCode events such as messages requiring a user response cannot be executed if a SQL update, insert, or delete has occurred in the commit interval. Examples of PeopleCode that invoke update type of SQL includes Process Scheduler, TriggerBusinessEvent, or MarkWorked. A unit of work cannot contain both think-time events and update type SQL.

Cause

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