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 11.5.10.2 to 11.5.10.2 [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

Symptoms

When attempting to run the France - DAS2 Verification Report (JEFRDVER), the following error occurs:

ERROR
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



Changes

 

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


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