EAR 9.2: Path Not Found Error Message When Interfacing ExcelUploadForDeposits.xlsm Spreadsheet Data Into PeopleSoft Excel Deposit and Payment Records (Doc ID 2827664.1)

Last updated on FEBRUARY 07, 2024

Applies to:

Symptoms

After a systems upgrade to PeopleSoft Enterprise FSCM 9.2 Image #39, the Users are getting an Error Message when trying to interface ExcelUploadforDeposits_2007.xlsm spreadsheet Deposit and Payment transaction data into the PeopleSoft Excel Records.

It may seem as if the Error Message refers to the path of the XML flat file created (AR_DEPOSIT_MESSAGE.XML), containing the transaction data, as if the VisualBasic delivered codeline cannot locate it.

REPLICATION STEPS:

    1.- Ensure that the FSCM 9.2 environment is at FSCM 9.2 Image #39, or at least has applied the fix from Defect # 32266940 (AR9.2: EXCELUPLOADFORDEPOSITS PERFORMANCE ISSUE WHEN GENERATE XML FILE)
    2.- Configure all the needed Integration Broker settings to ensure security is properly granted for such Excel Upload interface
    3.- Get the new ExcelUploadforDeposits_2007.xlsm spreadsheet delivered by Defect # 32266940
    4.- Fill in all the Deposit and Payment information in the Data Sheet tab
    5.- Save the changes
    6.- Click on the 'Generate XML and Post' button
    7.- Save the XML flat file into the same folder the ExcelUploadforDeposits_2007.xlsm spreadsheet is located
    8.- Click OK on the pop up messages triggered
    9.- Confirm that the system throws a final Error Message pop up window

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

ERROR MESSAGE:

Changes

Cause

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