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 laterInformation 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 |