ITS erroring with ORA-20002: 3135: 'Wf_Item_Activity_Status.Set_Error(error_process)'
(Doc ID 1065030.1)
Last updated on AUGUST 08, 2022
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.
Symptoms
Note: In the images bellow and/or the attached document, user details / company name / address / email / telephone number represents fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |