Pending Stuck Transactions due to OE_Flex_Cogs_Pub.Start_process : E (Doc ID 1517072.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Order Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Reviewed for Validity 02-DEC-2014***

Symptoms

Customer states
 Need to resolve Unprocessed Shipping Transactions as seen in Period Close Report.

Review associated Interface Trip Stop log file.
The reason for the stuck transactions is due to the following error s


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 (12/26/2012 07:03:59 PM, .65 seconds)
  RET_STATUS:E ACCOUNT_ID:
Unable to get account for delivery detail id 2328399

 

The output of HTMomse11i.sql shows
1) order lines are closed
2) delivery details are all shipped and interfaced to OM but only PARTIALLY interfaced to INV



STEPS
-----------------------
1. To create report, do:

Login to Oracle E-Business Suite
Select the responsibility "Oracle Diagnostics Tool"
Select application "Oracle Inventory" from the "Application" list of values
Click the "Advanced" tab
Scroll down to group "Activity"
Select test name "Period Closing"
Input Parameters (* required)
  Responsibility Id (LOV) *  
  Inventory Organization Id (LOV) *  
  Inventory Period Name (LOV) *  
  Information Level (Summary or Detail) (LOV) *




BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot close 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