ITS error: 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 MARCH 23, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR

When attempting to progress a delivery or trip stop through Interface Trip Stop, receive error

Error

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

EXPECTED BEHAVIOR

Interface Trip Stop should complete normally and progresses the line to shipped status.

Steps

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

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

              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

Changes

Cause

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