My Oracle Support Banner

Data Conflict or SQL Errors Adding a Row to the Academic Program Table After PI11 and PI14. (Doc ID 2479404.1)

Last updated on AUGUST 19, 2019

Applies to:

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

Symptoms

An error is returned when attempting to add a row to the ACAD_PROG_TBL  This issue first started after PI11 and is still an issue in PI14.


ERROR
-----------------------
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.

This may also manifest in 'A SQL error has occurred.'


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

  1. Apply CS 9.2 PI 11
  2. Query the Academic Program table
  3. Add a new effective dated row for any existing record
  4. Upon Save, the error will be returned

 

Cause

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
Symptoms
Cause
Solution
References


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