Getting this error:
SQL Error: ORA-02070: database does not support in this context
02070. 00000 - "database %s%s does not support %s in this context"
when running the following using DB link:
INSERT into XXCRM_ATTRIBUTE_LOOKUPS@APEXTST_XXCRM
(
attribute_id,
sr_attribute_drop_down_name,
incident_type_id,
sr_attribute_options
)
SELECT
att.sr_type_attr_map_id attribute_id,
nvl(att.sr_attribute_list_name,'None Defined') sr_attribute_drop_down_name,
att.incident_type_id,
nvl(ddlu.description,'None Defined') sr_attribute_options
FROM
cug_sr_type_attr_maps_b att,
fnd_lookup_values atlu,
cs_incident_types inct,
fnd_lookup_values ddlu
WHERE
att.sr_attribute_code = atlu.lookup_code
and att.incident_type_id = inct.incident_type_id
and ddlu.lookup_type(+) = att.sr_attribute_list_name
and atlu.lookup_type = 'CUG_SR_TYPE_ATTRIBUTES'
and sysdate between inct.start_date_active and nvl(inct.end_date_active,sysdate);
Any ideas! I don't know what it means or where to start.
Thank you.