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 220.127.116.11 [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
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
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!