EBS Customizations (MOSC)

MOSC Banner

Problem with the WF - error with the commit statment

edited Jul 10, 2013 8:30AM in EBS Customizations (MOSC) 5 commentsAnswered
HI All,

I would appriciate help on OM WF.

Created a Custom WF to release order line holds, I get an errror 3146: Commit happened in activity/function

I understand that it has to do with the commit I perform in the Package, but how can I fix it?

Also, the reason it errors is that there is an returned error, but why, its a simple Procedure:

PROCEDURE XXCSR_RELEASE_LINE_HOLDS(itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout IN OUT NOCOPY
/* file.sql.39 change */ VARCHAR2) AS

l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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