JEFRDVER Fails With REP-1401 ORA-00001
(Doc ID 560180.1)
Last updated on FEBRUARY 27, 2019
Applies to:Oracle Financials for EMEA - Version 126.96.36.199 to 188.8.131.52 [Release 11.5]
Information in this document applies to any platform.
This problem can occur on any platform.
REPORT:JEFRDVER.RDF - French DAS2 Verification Report
When attempting to run the France - DAS2 Verification Report (JEFRDVER), the following error occurs:
MSG-00211: After inserting je_fr_das_310.
MSG-00212: After inserting je_fr_das_310_new.
MSG-00213: After inserting je_fr_das_020.
MSG-00214: After inserting je_fr_das_020_new.
REP-1401: 'beforereport': Une erreur fatale PL/SQL s'est produite.
ORA-00001: unique constraint (.) violated
The issue can be reproduced at will with the following steps:
1. Go to AP France Responsability;
2. run report : France DAS2 : Vérification
3. It fails with parameter extract_flag = Y
The problem is that customer cannot insert in je_fr_das_010 two lines which are the same because of
index je_fr_das_010_U1 on SET_OF_BOOKS_ID and TYPE_ENREG with unique flag to Y.
The problem is the same with je_fr_das_010_new
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