Brazilian Receivables Occurences Remittance Batch (JLBRROIT) Error - REP-1401 ORA-01403: No Data Found (Doc ID 2018451.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

You are attempting to create an Occurrence Batch and receive the following error:

JLBRROIT module: Brazilian Receivables Occurrences Remittance Batch File
error-
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-01403: no data found
REP-0069: Internal error

Steps to Reproduce:
Responsibility:  Receivables
Navigation: Transactions > Transactions
1. Create and Complete a Transaction
2. Installment - Associate a Bank Collection Payment Method in GDF
Responsibility: Receivables
Navigation: Transactions > Transactions > Actions > Installment
3. Generate the Collection Remittance batch
Responsibility: Brazilian Localization
Navigation: Transactions > Bank Collections > Remittance Batches > Bank Transfer Batches
4. Format Collection Remittance batch file
Responsibility: Brazilian Localization
Navigation: Transactions > Bank Collections > Format Batches
5. Generate Occurrences
Responsibility: Brazilian Localization
Navigation: Transactions > Bank Collections > Occurrences
6. Generate Occurrence Batch
Responsibility: Brazilian Localization
Navigation: Transactions > Bank Collections > Remittance Batches > Occurrence Batches
7. Format the Occurrence Remittance batch
Responsibility: Brazilian Localization
Navigation: Transactions > Bank Collections > Format Batches

Current version:  JLBRROIT.rdf 120.8.12010000.3

Changes

Upgraded from 11i to R12

Cause

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 hundreds of Community platforms