Error '805 - ORA-00001: unique constraint (SYSADM.PS_VERIF_FLD_TOLS) violated' in Change Assistant when Installing PRP 35069540: 2024-2025 FM VERIFICATION UPDATES
(Doc ID 3011538.1)
Last updated on OCTOBER 08, 2024
Applies to:
PeopleSoft Enterprise CS Financial Aid - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
When trying to apply the Patch, PRP 235069540: 2024-2025 FM VERIFICATION UPDATES using Change Assistant, the following error occurs on the “Run Data Conversion AE - DC35069540” step:
Process 5090677 resumed after step DC35069540.MAIN.[start] (108,538)
Message Set Number: 108
Message Number: 538
Message Reason: Process 5090677 resumed after step DC35069540.MAIN.[start] (108,538)
SQL error. Function: SQLExec
Error Position: 0
Return: 805 - ORA-00001: unique constraint (SYSADM.PS_VERIF_FLD_TOLS) violated
Statement: INSERT INTO PS_VERIF_FLD_TOLS (INSTITUTION, AID_YEAR, EFFDT, FIELD_NUMBER, USE_FOR_FED, USE_FOR_INST, USE_FOR_IND_FED, USE_FOR_DEP_FED, USE_FOR_IND_INST, USE_FOR_DEP_INST, TOL_AMT_FED, TOL_AMT_INST, TOL_PCT_FED, TOL_PCT_INST, AMT_PCT_IND_FED, AMT_PCT_IND_INST) SELECT INSTITUTION,'2025','1900-01-01',181,'Y','N','Y','Y','N','N',0,0,0,0,' ',' ' FROM PS_VERIF_FLD_TOLS WHERE AID_YEAR = '2025' AND FIELD_NUMBER = 1
Message Set Number: 108
Message Number: 538
Message Reason: Process 5090677 resumed after step DC35069540.MAIN.[start] (108,538)
SQL error. Function: SQLExec
Error Position: 0
Return: 805 - ORA-00001: unique constraint (SYSADM.PS_VERIF_FLD_TOLS) violated
Statement: INSERT INTO PS_VERIF_FLD_TOLS (INSTITUTION, AID_YEAR, EFFDT, FIELD_NUMBER, USE_FOR_FED, USE_FOR_INST, USE_FOR_IND_FED, USE_FOR_DEP_FED, USE_FOR_IND_INST, USE_FOR_DEP_INST, TOL_AMT_FED, TOL_AMT_INST, TOL_PCT_FED, TOL_PCT_INST, AMT_PCT_IND_FED, AMT_PCT_IND_INST) SELECT INSTITUTION,'2025','1900-01-01',181,'Y','N','Y','Y','N','N',0,0,0,0,' ',' ' FROM PS_VERIF_FLD_TOLS WHERE AID_YEAR = '2025' AND FIELD_NUMBER = 1
Changes
The issue occurs after applying the fixes related to the 2024-2025 Updates for Verification- as documented in Note 3007479.1. The fixes were originally delivered in the indicated PRP and then included in the Campus Solutions 9.2 Image, starting with Image 9.2.32.
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 |