My Oracle Support Banner

CODIN Response Data Errors with the Following Message: "ORA-00001: unique constraint (SYSADM.PS_LOAN_DISB_MSG) violated" (Doc ID 2771285.1)

Last updated on APRIL 23, 2021

Applies to:

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

Symptoms

When running FAPCODIN the process is erring with the following error:

FAPDLINB - SQL ERROR IN SECTION: I-DISBMSG (UPDATE)

Application Program Failed
In Pgm Section : I-DISBMSG (UPDATE)
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_LOAN_DISB_MSG) violated


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

  1. Financial Aid --> File Management --> COD Full Participant --> Import COD Response Data
  2. Create a new Run Control ID or use an Existing ID
  3. Update the File Path and Name field so the process finds the file to be imported
  4. Run the job and review results.

Changes

 

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