Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error when installing trigger in .xdf file: ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword

Jose ArósteguiJun 5 2023

Hi experts,

We're using EBS 12.2.10 and there's a custom trigger we want to deploy to Prod environment via .xdf file.

Command for downloading .xdf

perl $FND_TOP/bin/xdfgen.pl apps/<APPS_PWD> XX_PO_REQ_INTERFACE_BRI

Command to install .xdf:

perl $FND_TOP/bin/xdfcmp.pl po/<PO_PWD> xx_po_req_interface_bri.xdf apps/<APPS_PWD>

This is the skeleton of the trigger. It's working OK into DEV environment, but we get the “ORA-04071: missing BEFORE, AFTER or INSTEAD OF keyword” when deploying (even in the same DEV environment)

CREATE OR REPLACE TRIGGER "APPS"."XX_PO_REQ_INTERFACE_BRI" 
BEFORE INSERT ON "PO"."PO_REQUISITIONS_INTERFACE_ALL#"
FOR EACH ROW 
WHEN  (NEW.interface_source_code IN('INV','CTO'))
DECLARE
 CURSOR c_specs IS
......
BEGIN
 ....
END;

Any suggestions?

Thanks in advance,
Jose.

Comments
Post Details
Added on Jun 5 2023
0 comments
266 views