My Oracle Support Banner

Advisement Report Result Tables RQ_GRP_LINE_NBR is Always Blank (Doc ID 2926772.1)

Last updated on FEBRUARY 08, 2023

Applies to:

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


In the AA Report Results table (PS_SAA_ADB_RESULTS), the RQ_LINE_NBR returns a row but the RQ_GRP_LINE_NBR" is blank (no rows returned).

The issue can be reproduced at will with the following steps:
1. Do a query on AA Report Results table (PS_SAA_ADB_RESULTS)  for RQ_LINE_NBR and RQ_GRP_LINE_NBR
2. Note that the RQ_GRP_LINE_NBR returns no values
3. Note that the RQ_LINE_NBR returns a value


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.