My Oracle Support Banner

Does Not Show the Data in Receipt Batches Infotile But the Data is Imported (Doc ID 2592934.1)

Last updated on SEPTEMBER 30, 2019

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.13.19.07.0 and later
Information in this document applies to any platform.

Symptoms

Import the Receipt through Spreadsheet, the data is imported even though the error occurs in spreadsheet.
Also, can not purge and edit the imported data because does not show in Receipt Batches infotile

Reproducible steps:
1. Receivables > Accounts Receivable > Create Receipts in Spreadsheet
2. Enter the following:
[Header]
Business Unit : XXX_BU01_LE01
Batch Source : XXX_REC_SRC_AUTO01
Batch Name : XXX190905batch-00
Receipt Method : XXX_REC_METH01
Remit bank : XXX_INT_BANK01
Remit Bank Account : XXX_INT_BANKACCT01

Batch Date : 2019/09/05
Accounting Date : 2019/09/05
Deposit Date : 2019/09/05
Currency : JPY
Conversion Rate :
Conversion Rate Type:
Conversion Date :

[Control]
Count : 2
Amount : 30000

[Receipt]

Status Sequence Receipt Number Receipt Amount Receipt Date Accounting Date Customer Name Customer Account Customer Site
  1 XXX190905-00 10000     XXX_CUST01 XXXX_70003 XXX_CUST01_SITE01
  2 XXX190905-01 20000     XXX_CUST02 9999 9

   ** XXX_CUST02 is not existed in the system (Enter wrong value without using LOV ).

3. Upload and the following error occurs:

  ERROR
  ---------
  The receipt batch failed to upload. (AR-856899)

4. Change the Batch Date,Accounting Date ,Deposit Date , Receipt Date in lines ,and Accounting Date in lines.
[Header]
Business Unit : XXX_BU01_LE01
Batch Source : XXX_REC_SRC_AUTO01
Batch Name : XXX190905batch-00
Receipt Method : XXX_REC_METH01
Remit bank : XXX_INT_BANK01
Remit Bank Account : XXX_INT_BANKACCT01

Batch Date : 2019/08/30
Accounting Date : 2019/08/30
Deposit Date : 2019/08/30
Currency : JPY
Conversion Rate :
Conversion Rate Type:
Conversion Date :

[Control]
Count : 2
Amount : 30000

[Receipt]

Status Sequence Receipt Number Receipt Amount Receipt Date Accounting Date Customer Name Customer Account Customer Site
Failed to insert 1 XXX190905-00 10000 2019/08/30 2019/08/30 XXX_CUST01 XXXX_70003 XXX_CUST01_SITE01
Failed to insert 2 XXX190905-01 20000 2019/08/30 2019/08/30 XXX_CUST02 9999 9

 

5. Upload again and error occurs:

  ERROR
  ---------
  The receipt batch failed to upload. (AR-856899)

6. Run the query "select NAME,BATCH_DATE, STATUS from AR_BATCHES_ALL where name = 'XXX190905batch-00'"

NAME BATCH_DATE STATUS
XXX190905batch-00 2019-08-30T00:00:00.000+00:00  

  > Null status data was created.

7. Receivables > Accounts Receivable > Receipt Batches infotile
  > Does not show above data.

8. Receivables > Accounts Receivable > Create Receipts in Spreadsheet
9. Upload the data which has same batch name and error occurs:
  ERROR
  ----------
  This batch name already exists. Enter a unique batch name. (AR-855383)

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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.