EAR8.4+: Running ExcelUploadforDeposits.xls Does Not Upload the Excel Upload Payment Tables
(Doc ID 859238.1)
Last updated on JULY 25, 2023
Applies to:
PeopleSoft Enterprise FIN Receivables - Version 8.4 to 9.1 [Release 8.4 to 9]Information in this document applies to any platform.
*** ***
*** Checked for Relevance on 29-Jan-2014***
*** Checked for Relevance on 30-Jun-2015***
Symptoms
The flow for processing spreadsheet payments is as follows up to the point where the Excel Upload Tables are correctly uploaded into the system.
…..
Step 1 - Enter Data in Excel SpreadSheet “ExcelUploadDeposits.xls”
Step 2 - Generate XML and Post from Data Sheet (Excel VB Macros) “ExcelUploadDeposits.xls”
Step 3 - Step2 will run Integration Broker Automatically depending on your Integration Broker Setup.
For Integration Broker Setup, please refer to the following document
EAR9.x+: Excel Spreadsheet AR Payment Upload Setup Document (Doc ID 794695.1)
Excel Payment Upload Tables
DEPOSIT_EXCEL
PAYMENT_EXCEL
ID_ITEM_EXCEL
ID_CUST_EXCEL
…..
If those tables are not uploaded, consequently, you also have no rows populated in Receivables>Payments>Electronic Payments>Excel Error Correction Page, you will have to go into People Tools > Integration Broker > Service Operations Monitor > Monitor – Asynchronous Page to see if there is any transaction with Status ‘ERROR’ for Queue “AR_EXCEL_PAY_UPLOAD” among all of the existing transactions there.
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 |