Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

ORA-20002:3103 Exception when calling create_item_instance

edited Aug 20, 2021 9:48AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered
I am working on R12 upgrade and I am getting an ORA-20002:3103 exception when calling CSI_ITEM_INSTANCE_PUB.create_item_instance().

The full exception is as follows:
ORA-20002:3103:Attribute'.MAIL_QUERY' does not exist for item 'OKSWARWF/OKS-3164624'.

I have tried debugging through this using SQL Developer and have traced it down to a call to WF_ENGINE.startprocess();

The call being made here is: WF_ENGINE.startprocess('OKSWARWF','OKS-3164629');

When debugging, the process throws the exception at this call. When I try to step into WF_ENGINE.startprocess() SQL Developer instead creates an anonymous block that is calling WF_ENGINE.cp();

Tagged:

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