Course Index Pre-Process Failing Using Query SSR_BC_INDX_BY_EFFDT_SYNC: ORA-01427: single-row subquery returns more than one row
(Doc ID 2873141.1)
Last updated on MARCH 08, 2023
Applies to:PeopleSoft Enterprise CS Student Records - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Fluid course catalog index pre-process (Curriculum Management>Fluid Browse Course Catalog>Course index Pre-Process; app engine SSR_BC_INDX), using the Query SSR_BC_INDX_BY_EFFDT_SYNC, which has a prompt for date (entered less than 8/25/22) - is failing with the error:
- Navigate to Home > Curriculum Management > Fluid Browse Course Catalog > Course index Pre-Process
- Add/enter run-control ID
- Choose Selection Tool = Query
- Enter Query Name = SSR_BC_INDX_BY_EFFDT_SYNC
- Select Edit Prompts link
- Enter As of Date = 8/25/22
- Select Run
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