My Oracle Support Banner

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.


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.
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 3208



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


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.