Teleservice - EBS (MOSC)

MOSC Banner

JTF_TASKS_B table- created update trigger but nothing happens

edited May 9, 2013 5:09AM in Teleservice - EBS (MOSC) 11 commentsAnswered
I've created an trgger of BEFORE UPDATE ON JTF.JTF_TASKS_B to check when a status has changed and if the new status is a specific status we want to start a workflow.

Tested the workflow and it performs as needed. However the trigger on the table appears to be not doing anything.

I created a temp table to put the task_id, old and new status_id when the trigger fires but every time I change a Task Status in the Tasks tab of the Service Request form no data gets populated into the table.

Is there something about this table that would keep the trigger from firing?

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

EBS Teleservice Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center