Issue in Database trigger for HZ_CUSTOMER_PROFILES PL/SQL: ORA-00936: missing expression
We are trying to create database trigger on update of table HZ_CUSTOMER_PROFILES when CREDIT_HOLD='Y'
If this update is done from certain operating unit we are inserting into another custom table when compiling trigger we are getting error as given below
LINE/COL ERROR
-------- ---------------------------------------
5/2 PL/SQL: SQL Statement ignored
17/2 PL/SQL: ORA-00936: missing expression
SQL> l 5
5*
SQL> l 17
17* COUNTRY,
Copying code used for creating trigger
CREATE OR REPLACE TRIGGER "APPS"."SDS_CREDIT_HOLD_ROW"
BEFORE UPDATE ON HZ_CUSTOMER_PROFILES
FOR EACH ROW
WHEN ( new.CREDIT_HOLD='Y')
BEGIN
IF FND_PROFILE.VALUE('ORG_ID')=3217 THEN