My Oracle Support Banner

Advisor Assignment Process - Bind Records Missing in the Query Options (Doc ID 2728274.1)

Last updated on NOVEMBER 17, 2020

Applies to:

PeopleSoft Enterprise CS Student Records - Version 9.2 and later
Information in this document applies to any platform.


After applying PUM 18, The Student Advisor Assignment appears there area few bind records missing in the query options - SR_STAD_ADV and SSR_STAD_STU.

Checking the prompt table on the setup record - it isn't looking into the query for a bind record, but instead looking for a query name (not expected) SELECT QRYNAME , DESCR FROM PSQRYDEFN WHERE QRYNAME LIKE 'SSR_STAD_ADV%' .

The issue can be reproduced at will with the following steps:
1. Records and Enrollment > Student Background Information > Student Advisor Assignment
2. Try to run using PS Query Optons
3. Note the process completed but no records are retrieved and no errors in the log file


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.