ElasticSearch - SSR_BROWSE_CATALOG Fail To Build Full Index (Doc ID 2300683.1)

Last updated on APRIL 14, 2025

Applies to:

Symptoms

On : 8.55 version, ElasticSearch

Elastic Search - SSR_BROWSE_CATALOG Fails to build full index

Error when trying to deploy SSR_BROWSE_CATALOG search definitions.

File: /vob/peopletools/src/pssys/qpm.cppSQL error. Stmt #: 7867 Error Position: 0 Return: 1799 - O RA-01799: a column may not be outer-joined to a subquery Failed SQL stmt: SELECT DISTINCT A.CRSE_ID, TO_CHAR(A.EFFDT,'YYYY-MM-DD'), A.CRSE_OFFER_NBR, A.INSTI TUTION, A.ACAD_GROUP, A.SUBJECT, A.SUBJECT || ' / ' || K.DESCR AS SSR_SUBJ_DESCR_ES, A.CATALOG_NBR , TO_CHAR(CAST((B.LAST_UPDATE_DTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), B.AUDIT_ACTN, C.DESCR , A.SUBJECT || ' ' || A.CATALOG_NBR, C.COURSE_TITLE_LONG, A.COURSE_APPROVED, TO_CHAR(TO_DATE( TO_C HAR(A.EFFDT,'YYYY-MM-DD'), 'YYYY-MM-DD')), D.DESCR, D.DESCR AS SSR_CRSE_OFF_DESCR, A.SSR_CRSE_TYPOF F_CD, CASE WHEN A.SSR_CRSE_TYPOFF_CD <> ' ' THEN 'Y' ELSE 'N' END, C.GRADING_BASIS, E.XLATLONGNAME AS SSR_GRADING_BASIS, C.RQMNT_DESIGNTN, A.OEE_IND, I.XLATLONGNAME AS SSR_OEE_IND_DESCR, A.ACAD_CAR

Cause

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