Fail To Insert Change Record In Table UPA_UD_FORMFIELDS (Doc ID 2689445.1)

Last updated on MARCH 25, 2025

Applies to:

Goal

We are getting below error in OIM diagnostic logs, can you please assist us how to resolve?

[2020-07-06T05:11:28.258-05:00] [oim_server1] [ERROR] [] [XELLERATE.DATABASE] [tid: [ACTIVE].ExecuteThread: '14' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: oiminternal] [ecid: 27749c4f-53c7-4cd5-b8e9-cbf4296f1235-0000007a,1:1325] [APP: oim] [partition-name: DOMAIN] [tenant-name: GLOBAL] Class/Method: tcDataBase/writeStatement encounter some problems: ORA-04092: cannot ROLLBACK in a trigger[[
ORA-06512: at "DEV_OIM.OIM_PKG_MVIEW_TRIG_EVALFORM", line 178
ORA-01403: no data found
ORA-06512: at "DEV_OIM.OIM_PKG_MVIEW_TRIG_EVALFORM", line 80
ORA-06512: at "DEV_OIM.OIM_TRIG_MVIEW_STMTLEVEL", line 2
ORA-04088: error during execution of trigger 'DEV_OIM.OIM_TRIG_MVIEW_STMTLEVEL'
 java.sql.SQLSyntaxErrorException: ORA-04092: cannot ROLLBACK in a trigger
ORA-06512: at "DEV_OIM.OIM_PKG_MVIEW_TRIG_EVALFORM", line 178
ORA-01403: no data found
ORA-06512: at "DEV_OIM.OIM_PKG_MVIEW_TRIG_EVALFORM", line 80
ORA-06512: at "DEV_OIM.OIM_TRIG_MVIEW_STMTLEVEL", line 2
ORA-04088: error during execution of trigger 'DEV_OIM.OIM_TRIG_MVIEW_STMTLEVEL'
 

Solution

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