Error when running Customer Profile Engine
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'