My Oracle Support Banner

Brazilian Receivables Post Bank Return Program Error unique constraint (JL.JL_BR_AR_OCCUR_DOCS_U1) violated (Doc ID 2699612.1)

Last updated on AUGUST 11, 2020

Applies to:

Oracle Financials for the Americas - Version 12.1.1 and later
Information in this document applies to any platform.


Reported Issue
Brazilian Receivables Post Bank Return Program ending in error.

ERROR at line 1:
ORA-00001: unique constraint (JL.JL_BR_AR_OCCUR_DOCS_U1) violated
ORA-06512: at line 591
ORA-06512: at line 3323

Steps to replicate
The issue can be reproduced at will with the following steps:
1. Submit the concurrent: JLBRRCRB: Brazilian Receivables Post Bank Return Program.
2. Observe the program ends in error.

Expected Behavior
Expects that the program should complete normal without any error
and process the bank returns.


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.