Oracle Student Financial Planning Cloud Service: Unable To Compare Student Data With ISIR Data In OAS (Doc ID 2967575.1)

Last updated on AUGUST 14, 2023

Applies to:

Symptoms

On : 23.7.0.0 version, Reports

Unable to compare Student data with ISIR data in Reporting

The report SQL needs to compare field values from the Student against field values in the ISIR. This gives the following SQL Error:

ORA-43915: unable to determine collation: arguments have conflicting collations

Using the query below in an OAS Data Model:

SELECT
S.LAST_NAME STUDENT_LAST_NAME,
I.LAST_NAME ISIR_LAST_NAME
FROM
STUDENT_CONSOLIDATED_VW S,
ISIR_ONLY_VW I
WHERE
S.LAST_NAME = I.LAST_NAME

Gives the following error when trying to save the Data Model and run the query.

ERROR
-----------------------
ORA-43915: unable to determine collation: arguments have conflicting collations

Cause

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