Brazilian Bank Return Give SQL Error

(Doc ID 797235.1)

Last updated on APRIL 17, 2018

Applies to:

Oracle Financials for the Americas - Version 12.0.0 and later
Information in this document applies to any platform.
This problem can occur on any platform.
JLBRRCRB

Symptoms

You are running JLBRRCRB module: Brazilian Receivables Post Bank Return Program and get an error message in the logfile:

Concurrent Manager encountered an error while running SQL*Plus for your concurrent request 3381202.

Review your concurrent request log and/or report output file for more detailed information.

Your output report contains sql error messages:

SP2-0103: Nothing in SQL buffer to run.
DECLARE
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 3208






.

Changes

Upgraded to R12.
The organization has more than one establishment to assigned.  One of the establishments must be marked as primary.

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