My Oracle Support Banner

Forms CSCSOREL.fmx And CSCCCCRC.fmx Failed To Generate Successfully (Doc ID 2367270.1)

Last updated on FEBRUARY 28, 2018

Applies to:

Oracle Teleservice - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

The Teleservice forms CSCSOREL.fmx & CSCCCCRC.fmx failed to compile in a a 12C database.
The error message is the same for both forms:

FRM-30064: Unable to parse statement SELECT DISTINCT hp.party_name,
 hp.party_number,
 hp.party_id,
 hp.party_type,
 hp.address1,
 hp.city,
 hp.state,
 hp.country,
 hp.status
FROM hz_parties hp,
 hz_relationship_types hrt ,
 ar_lookups al
WHERE hp.party_type = hrt.object_type
AND al.meaning = :relationships.relationship_meaning
AND hrt.subject_type = :relationships.sub_party_type
AND hrt.relationship_type = :relationships.relationship_type
AND hrt.object_type IN ('PERSON','ORGANIZATION')
AND al.lookup_code = hrt.forward_rel_code
AND al.lookup_type = :parameter.p_lookup_type
AND al.enabled_flag = 'Y'
AND hrt.status = 'A'
AND hp.status not in ('I','M','D')
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(al.start_date_active,SYSDATE)) AND TRUNC(NVL(al.end_date_active, SYSDATE))
ORDER BY 1,2,5,6.
ORA-01791: not a SELECTed expression
Record Group REL_OBJ_PARTY_NAME_GRP

Form: CSCSOREL
Form:CSCCCCRC

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.