Brazilian Localization: Receipt Batch Shows Out Of Balance and You Cannot the Close Period (Doc ID 2173458.1)

Last updated on AUGUST 23, 2016

Applies to:

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

Symptoms

On : 12.2.4 version, Receipts Related

You are attempting to run the PostBatch Program (ARCABP) and receive the following error:

created receipt num=136032428799 amount=2973.88
customer=550070xxx - xxxxxCOPY LTDA
get receipt lines: last_rec=0, sqlerrd=34
Brazilian Localization calling hook
 SQL Code before calling JL:
AR-arcipra: Error inserting record in AR_RECEIVABLE_APPLICATIONS
ORA-01422: exact fetch returns more than requested number of rows
ORA-
AR-arcipra: Error exit.
Current system time is 31-MAR-2016 14:15:19
AR-arcrollback: Rollbacked.
Current system time is 31-MAR-2016 14:15:19
AR-arcrollback: Calling arcubr1...
Current system time is 31-MAR-2016 14:15:19
Updating batch_applied_status to POSTBATCH_WAITING.
AR-arcubr1: The batch_applied_status of batch 110616 is not IN_PROCESS



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