My Oracle Support Banner

Prompt on PS_CIP_CODE_TBL Not Displaying All Active Values (Doc ID 2440372.1)

Last updated on MARCH 09, 2020

Applies to:

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


On : 9.2 version, Curriculum Management

Prompt on PS_CIP_CODE_TBL not displaying all active values

In the Course Catalog component (and others), the prompt list displayed for CIP_CODE does not contain all active values in the CIP code table. It appears that effective date logic is not handled the same in PS 9.2 as it was in 9.0 with respect to some prompts. We saw the same type of problem with Define Transcript Type. If one of the CIP codes has a row with 01/01/1900 or 01/01/1901 and possibly more recent rows, then that CIP code will be displayed in the prompt list. But CIP codes that have no 01/01/1900 or 01/01/1901 row, only a more recent row, will not display in the prompt list. The component should display the values based upon the keys, but it seems to be using effective dated rows from other key values to control the list. I've attached two files to display an example of the problem.

CIP CODES prompt should display all the values based on selected key fields

The issue can be reproduced at will with the following steps:
1. Navigate to Curriculum Management - Course Catalog - Course Catalog
2. Enter effective date as 01/01/1900
3. Go to Offerings tab
4. Click on CIP Code look up
5. Search all the CIP Codes begin with '38'
6. Notice that it will just show the CIP Codes with an effective date 01/01/1900 and not the ones with greater eff dates

The issue has the following business impact:
Due to this issue, users do not get all the CIP Codes that are manually added or delivered with an effdt greater than 01/01/1900 if course catalog eff date is 01/01/1900




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.