ITS erroring with ORA-20002: 3135: 'Wf_Item_Activity_Status.Set_Error(error_process)' (Doc ID 1065030.1)

Last updated on JULY 13, 2016

Applies to:

Oracle Order Management - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
*** Checked for relevance on 07-Nov-2014 ***

Symptoms

On : 11.5.10.CU2 version, Finance & Accounting
When attempting to run the ITS interface for a Stop ID the following error occurs.

ERROR
-----------------------
Generated CCID :10606
Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED
Item Type : OECOGS
Item Key : #SYNCH
Activity Id : 174696
funcmode : RUN
Input Paramerers :
Line id :3913
Organization id :145
Output :
Generated CCID :1687
Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived
Return CCID :
Concat Segments :
Concat Id :
Concat Descriptions :
Error Message : ORA-20002: 3135: 'Wf_Item_Activity_Status.Set_Error(error_process)' is not permitted in synchronous processes.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. As OM Super User
2. Navigate -> Shipping -> Interfaces
3. Select the "Interface Trip Stop" program
4. Enter required Stop parameter.
5. Review generated ITS (debug) log

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