Pending Stuck Transactions due to OE_Flex_Cogs_Pub.Start_process : E
Last updated on JUNE 28, 2017
Applies to:Oracle Order Management - Version 188.8.131.52 and later
Information in this document applies to any platform.
***Reviewed for Validity 02-DEC-2014***
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.
Exiting OE_Flex_Cogs_Pub.Start_process : E
NO. OF OE MESSAGES :1
RETURN STATUS FROM OE_FLEX_COGS_PUB.START_PROCESS IS E
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)
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
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) *
The issue has the following business impact:
Due to this issue, users cannot close period.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms