CNAB File Process Fails with Duplicate Key

(Doc ID 2323179.1)

Last updated on NOVEMBER 09, 2017

Applies to:

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

Symptoms

On Campus Solutions 9, Brazil localization #10 applied, the CNAB file process fails. The same bank slip/collection document is being inserted twice in the (PS_REM_TRANS_BRL) tables, when a change is identified, which results in a duplicate key error.



ERROR
-----------------------
(SQR 5528) ORACLE OCIStmtExecute error 1 in cursor 7:
  ORA-00001: unique constraint (SYSADM.PS_REM_TRANS_BRL) violated


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Student Financials, Bank Collection Brazil, Load Items Bra;
2. Select a run control;
3. Complete the run control;
4. Submit the process to the process scheduler.


PeopleSoft Enterprise Campus Solutions Community  Support Blog  Information_Centers  Maintenance_Advisor 

 

 

Changes

 

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