ORA-20002 ORA-20007 Errors When A Custom Function Raises A User-Defined Exception In A Synchronous Business Event (Doc ID 465514.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Product Hub - Version 12.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 04-Nov-2014***
Business Events implemented in Advanced Product Catalog (APC)


Symptoms

Users receive technical error messages when a Custom Function raises a User-Defined Exception in a Synchronous Business Event.

Custom validations failed, please contact your System Administrator.
(PKG_NAME=EGO_WF_WRAPPER_PVT) (API_NAME=Raise_WF_Business_Event)
(SQL_ERR_MSG=ORA-20002: 3825: Error '-20007 - ORA-20007: This is a error
test.' encountered during execution of Rule function
'XXDUP_CHECK_SAMPLE.XXNAME_DUP_CHECK_SAMPLE' for event
'oracle.apps.ego.item.preAttributeChange' with key
'oracle.apps.ego.item.preAttributeChange-2454357.3449713.249514630535076436597
85832707397422799'.)

Changes

You created a synchronous business event subscription with phase 1-99. And you assigned your custom function as a rule function.

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