My Oracle Support Banner

Interface Trip Stop Errors With ORA-20002: 3135: 'Wf_Item_Activity_Status.Set_Error(error_process)' Is Not Permitted In Synchronous Processes Due To OE_Flex_Cogs_Pub.Start_process : E (Doc ID 1517072.1)

Last updated on JUNE 21, 2024

Applies to:

Oracle Order Management - Version 11.5.10.2 and later
Oracle Shipping Execution - Version 11.5.10.CU2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run Interface Trip Stop(ITS), the following error is raised:


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
User-Defined Exception:80
NO. OF OE MESSAGES :1
RETURN STATUS FROM OE_FLEX_COGS_PUB.START_PROCESS IS E
CONCAT_SEGS IS
CONCAT_IDS IS
CONCAT_DESCRS IS
L_CONGS_RETURN_CCID IS
Cost Of Goods Sold Account Generation Failed with error : ORA-20002: 3135: 'Wf_Item_Activity_Status.Set_Error(error_process)' is not permitted in synchronous processes.
l_account ==> is NULL
Exiting WSH_SHIP_CONFIRM_ACTIONS.GET_ACCOUNT



STEPS

The issue can be reproduced at will with the following steps:

  1. Order Management Super User Responsibility
  2. Navigate to Menu path > Order, Returns > Launch Sales Order form.
  3. Enter order header with salesrep field populated, enter order lines, books and progress line to Awaiting_Shipping status.
  4. Navigate to Menu path > Shipping > Release sales order > In order number field > enter order number.
  5. In the release sales order > shipping tab > enable auto pick confirm, auto create delivery > specify a shipping rule for Auto Ship.
  6. Execute Pick Release with Auto Ship as Yes.
  7. Interface trip stop concurrent program is launched after pick release is executed, and it can be seen that ITS ends with above error.

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.