My Oracle Support Banner

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.


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.

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

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 






To view full details, 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 a vibrant support community of peers and Oracle experts.