My Oracle Support Banner

JEDEAPPL German Payables Separate Payment Letter fails with REP-1401 ORA-00001 (Doc ID 298255.1)

Last updated on APRIL 25, 2019

Applies to:

Oracle Financials for EMEA - Version 11.5.9 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Financials for EMEA - Version: 11.5.9
This problem can occur on any platform.
JEDEAPPL - German Payables Separate Payment Letter

Symptoms

 Responsibility: Oracle Payables
Path: Other -> Requests -> Run

The German Payables Separate Payment Letter (JEDEAPPL) finishes with the following errors:

REP-1401: 'afterreport': Fatal PL/SQL error occurred.
ORA-00001: unique constraint (.) violated

For example:

A batch name longer than 30 is allowed, however, it seems only the first 30 characters is taken, and when inserting into table je_de_ap_batches, the error 'ORA-00001: unique constraint (.) violated' will occur if the same name already exists. Entering 'KP Test 12/20/2004 - Scenario 3', for example, but in the table there exists 'KP Test 12/20/2004 - Scenario', which is the first 30 characters.

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!


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