When Updating Applicant Academic Program/Plan from Research Enabled to Non-Research, Get Errors (18,2) and (124,64) (Doc ID 2258956.1)

Last updated on APRIL 26, 2017

Applies to:

PeopleSoft Enterprise CS Campus Community - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


When an admissions applicant changes their program/plan from one that is enabled for research management to one that is not, two errors are encountered:

ERROR
-----------------------
Error 1:
Data being added conflicts with existing data. (18,2)
When adding a new item to the database, the system found a conflicting item already exists.
This problem can happen if another user has entered similar information at the same time as you. Note the changes you have made, cancel the page, then retry your changes.
If the problem persists, it may be because of an application or other programming error and should be reported to technical support staff.
This error occurs when the keys on the record being inserted match a record that is already in the database. The application must ensure that each inserted record has unique keys.

Error 2:
Field is Required: SSR_RS_CAND_HDR - SSR_RS_CANDIT_NBR (124,64)

NOTE: When a user queries PS_ADM_APPL_PROG, the SSR_RS_CANDIT_NBR exists on all rows - not just the rows associated with plans that are research enabled. A new row with a blank SSR_RS_CANDIT_NBR is inserted into SSR_RS_CAND_HDR.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Find an application that is for a research-enabled academic plan
2. Insert a new (ADM_APPL_PROG) row with a change of plan that is not research enabled.
3. Select Save.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms