PL/SQL (MOSC)

MOSC Banner

TRIGGER FETCHES ONLY FEW RECORDS

edited Feb 13, 2013 3:18AM in PL/SQL (MOSC) 2 commentsAnswered
WE ARE CREATING A TRIGGER ON JTF_IH_INTERACTIONS TABLE, THAT AIMS TO CATCH THE INTERACTION DETAILS LIKE INTERACTION_ID,PARTY_ID,RESULT_ID,REASON_ID,OUTCOME_ID once a interaction is created using front end.Further we join the id details to the tables like jtf_ih_reasons_tl ,jtf_ih_outcomes_tl,hz_parties to fetch the column short _description.
 the code attched works fine (see sample output),but the reason result outcome fields do not populate..Can any one suggest?

 

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