Order Management - EBS (MOSC)

MOSC Banner

Error in Updating Sales Order Line Status - WF_ITEM_ACTIVITY_STATUSES

edited Mar 17, 2025 3:35PM in Order Management - EBS (MOSC) 3 commentsAnswered

Hi all,

We are trying ITM Adapter Integration with GTM, after getting response back from GTM while processing the response for Order Export Compliance → Line Status not updating from Awaiting Export Screening to Awaiting Shipping. we traced it and getting the error as mentioned below from WF_ITEM_ACTIVITY_STATUSES table. Please help us to go forward.

Error Name → -4061,

Error Message → ORA-04061: existing state of  has been invalidated

Error Stack →

OE_EXPORT_COMPLIANCE_WF.Update_Screening_Results(OEOL, 337948510, 370096, RUN)

Wf_Engine_Util.Function_Call(OE_EXPORT_COMPLIANCE_WF.UPDATE_SCREENING_RESULTS, OEOL, 337948510, 370096, RUN)

Here is the Query for reference:-

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center