Core Workflow - EBS (MOSC)

MOSC Banner

Main plsql function is not working in custom subscription

hi All,

We have a have custom subscription under which we have attached our plsql function.

There are scenarios where we have observed that if there are 6 lines in a sales order only 2 are getting processed. So we added two insert statements right above and below where main is called and got to know about this issue.

Can anyone guide why this is happening and better ways to debug it?

create or replace PACKAGE BODY        "GEPS_ONT_SMAX_INT_PKG" IS

FUNCTION co_subscription (

p_subscription_guid IN RAW,

p_event IN OUT wf_event_t

)

RETURN VARCHAR2

AS

ln_header_id NUMBER;

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