Interface Trip Stop error: ORA-20002: 3135: 'Wf_Item_Activity_Status.Set_Error(error_process)' is not permitted in synchronous processes. (Doc ID 1542424.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 12.1.1 and later
Oracle Shipping Execution - Version 12.1.1 and later
Information in this document applies to any platform.
Reviewed for currency 27-Dec-2016

Symptoms

On : 12.1.3 version, Transaction Fulfillment

When attempting to progress order 618 through Interface Trip Stop, receive error.

Salesperson (Salesrep ID) is populated at the order header and is blank at the order line.


ERROR
----------------------
Entering OE_FLEX_COGS_PUB.GET_SALESREP_REV_DERIVED
Sales rep id :
Input Paramerers :
Salesrep ID :
Output :
Generated CCID :
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.

LEAVING OE_MSG_PUB.ADD
Exiting OE_Flex_Cogs_Pub.Start_process : E


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create order
2. for some reason, the salesrep at the line is blank.
3. run Interface Trip Stop. receive error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot interface the delivery to Inventory.  This leaves unprocessed shipping transactions which prevent closure of the current accounting period.

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