Brazil Post Bank Return not Creating Receipts (Doc ID 1473097.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Receivables - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Symptoms

Brazilian Receivables Post Bank Return Program completes successfully but no receipts are getting generated.
ARCABP - Post QuickCash is not getting kicked off.

Steps to reproduce:
1.  Run sql loader program to populate the data from the bank file to L_BR_AR_RET_INTERFACE table .
Verified that the data is loaded correctly to the interface table.  

The batch_source_id is populated with a valid value.


2.  Submit JLBRRVFD - Brazilian Receivables Import of Bank Return Program
This program validates data nd imports data from JL_BR_AR_RET_INTERFACE table to the internal tables.
If validation is successful, this record is inserted in JL_BR_AR_BANK_RETURNS table and deleted from            
JL_BR_AR_RET_INTERFACE table. If validation is unsuccessful, the record in inserted in
JL_BR_AR_RET_INTERFACE_EXT table and deleted from JL_BR_AR_RET_INTERFACE table.


JLBRRVFD - Brazilian Receivables Import of Bank Return Program completes successfully and the data is
JL_BR_AR_BANK_RETURNS.

You notice that the batch_source_id is null.   Also in this case, the occurrence_code
for each of these transactions is 2 which in this case is occurence type = COMPLETED_ENTRY.

 

3.  Submit JLBRRCRB - Brazilian Receivables Post Bank Return Program.  It completes successfully but the
logile shows ARCABP is not kicked off and receipts are not created nor are they in the interim tables,
AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL.

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