My Oracle Support Banner

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:

  1. Navigate to Home > Curriculum Management > Fluid Browse Course Catalog > Course index Pre-Process
  2. Add/enter run-control ID
  3. Choose Selection Tool = Query
  4. Enter Query Name =  SSR_BC_INDX_BY_EFFDT_SYNC
  5. Select Edit Prompts link
  6. Enter As of Date = 8/25/22
  7. 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

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