My Oracle Support Banner

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


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


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

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