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

(Doc ID 1065030.1)

Last updated on DECEMBER 16, 2017

Applies to:

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


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

Generated CCID :10606
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.

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


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