EAR8.4+: Running ExcelUploadforDeposits.xls Does Not Upload the Excel Upload Payment Tables (Doc ID 859238.1)

Last updated on SEPTEMBER 22, 2016

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 Thu 17-Mar-2011***
*** Checked for Relevance on 20-Aug-2012***
*** 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

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