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.