For FSCM 9.0, VP1/VP1 will work.

We tried with VP1/VP1 also, its not working. Could you please share the excel?

if you still have this issue...

Please can you confirm what error you see.

I tried VP1/VP1 too and got error 'Login was not successful. Please check your user id or password.'

Hi,

I don't know you find solution for this or not...anyway my suggestion..

Use User id/ Password which you are using for PIA login, In my excelspreadsheet it's not asking for userid and password, if you properly update for 'machine name, Integration Gatway, From node, To node and Generate URL' rows in the 'template' sheet for exceluploadforvoucher.

Click on this link once before try for upload, to check whether successfully connecting or not...

you can see the error message and reason for failed in navigation for this exceluploadforvoucher in : Integration broker -> Monitor Integration -> Message Details...

if your previous upload failed and in 'error' status...just calcel that in monitor message-> subcontracts page and try again..

Thanks
Rajendran Mariappan

did you ever find out what the problem was with the login error you were receiving? i am having the same issue.

Try this.

1. Make sure that Configuration Properties in IB Properties configuration file @ admin level are all setup correctly.

2. Go to Main Menu>>PeopleTools>>IB>>Configuration>>Gateways and open Local Gateway. Go to HTTPTARGET Connector ID's Properties link and see the PRIMARYURL value. This PRIMARYURL value must be same as that of PS Instance as "http://ServerURL:PortNumber/PSIGW/HttpListeningConnector"

3. Run ExceltoCi utility, if it shows error the open " http://ServerURL:PORT_number/PSIGW/errorLog.html "
in IE where ServerURl and Port Number should be for your Peoplesoft Instance for which you trying to upload Vouchers. See what the error is?

Thanks for the response. I was able to get past the error. There were issues with the generated URL and the other link that's on the spreadsheet.

thank you.

Try to bounce the IB