EBS Customizations (MOSC)

MOSC Banner

Custom trigger on view is not working

We just upgrade to R12.2, created a new simple DB trigger on view, but seem this DB object cannot be triggered.

After that, we compile the trigger directly on table, it is work. And then we drop the trigger on table, and compile once again on view, it is work too. I would like anything wrong with the custom DB object?

Attached as below for reference.


CREATE OR REPLACE TRIGGER APPS.XXPO_PARENT_REQ_LINE_ID_T2

  BEFORE INSERT

  

 ON "PO"."PO_REQUISITION_LINES_ALL#"   FOR EACH ROW

WHEN (

NEW.REQUISITION_LINE_ID IS NOT NULL AND NEW.PARENT_REQ_LINE_ID IS NULL AND NEW.ATTRIBUTE15 IS NOT NULL

Tagged:

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