EBS Customizations (MOSC)

MOSC Banner

Issue in Database trigger for HZ_CUSTOMER_PROFILES PL/SQL: ORA-00936: missing expression

edited Jan 17, 2012 1:46AM in EBS Customizations (MOSC) 4 comments
Hi

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

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