trigger on gl_interface [message #527586] |
Wed, 19 October 2011 02:17 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/eb0f4179984ae4d3f2cb3a3ee7923f16?s=64&d=mm&r=g) |
asmirnov9
Messages: 8 Registered: October 2011
|
Junior Member |
|
|
Hello dear,
This is R12.1.3.
It looks like I am missing something but don't know what...
I have a trigger on gl_interface - can't be simpler
CREATE OR REPLACE TRIGGER APPS.XXGL_INTERFACE_TRG
BEFORE INSERT
ON GL.GL_INTERFACE
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
BEGIN
:new.attribute20 := 'XXX';
END xxgl_interface_trg;
but it only fires if a record stays in gl_interface, for example speaking about XLARGLTR (AR to GL transfer) program - if I run it while I have SLA: Disable Journal Import profile set to Yes the trigger fires, attribute20 in the gl_interface gets a value. But if the above profile option is set to N the trigger doesn't fire. Is this the way it should be or I am missing something?
Thank you
Anatoliy
|
|
|
|
|
|
|
|