My Oracle Support Banner

Brazilian Receivables Create Collection Remittance Batch Program Fails With SP2-0103: Nothing in SQL buffer to run. (Doc ID 1236044.1)

Last updated on MARCH 14, 2018

Applies to:

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


Symptoms

When attempting to run JLBRRSAB Brazilian Receivables Create Collection Remittance Batch Program
the following error occurs.

SP2-0103: Nothing in SQL buffer to run.



Steps to Reproduce:

Responsibility:  Brazil Receivables
Navigation

  1. Assign the Receipt Method(Brazilian Localization) to the specific Customer data as a payment method.
  2. Create a Remittance Batch via Bank transfer batches forms
  3. Brazilian Receivables Create Collection Remittance Batch Program  completed normal.

Changes

Upgrade from 12.0.6 to 12.1.1

Cause

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.