Technology Stack - EBS (MOSC)

MOSC Banner

Error when running Customer Profile Engine

edited Aug 20, 2021 10:55AM in Technology Stack - EBS (MOSC) 3 commentsAnswered

I am creating a new Relationship Plan at the Customer level but when I run the Customer Profile Engine I get this error:

Evaluate_Checks4_Var(check_id => 1081, Error => -1008 ORA-01008: not all variables bound)

This is my Suggested Batch SQL set in the Profile Variables tab of the Customer Profile Setup :

SELECT count(*)

FROM hz_parties hz,hz_cust_accounts hca,hz_customer_profiles cp,hz_cust_profile_classes cpc

WHERE hz.party_id = :party_id

and NVL(hz.status,'x') = 'A'

and hz.party_type IN ('PERSON', 'ORGANIZATION')

and hca.party_id = hz.party_id 

and NVL(hca.status,'x') = 'A'

Tagged:

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