My Oracle Support Banner

JEFRDVER Fails With REP-1401 ORA-00001 (Doc ID 560180.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Financials for EMEA - Version to [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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.