Affichage des articles dont le libellé est PeopleSoft Voucher upload. Afficher tous les articles
Affichage des articles dont le libellé est PeopleSoft Voucher upload. Afficher tous les articles

vendredi 20 mai 2011

PeopleSoft Voucher upload configuration to work with a load balancer

You may have to modify the Excel Macro for Voucher upload, in case you are using a load balancer in front of your Web servers.
The reason for this is that the technology used in this macro (xml link) does not behave the same as a direct connection to the PIA.

Search for this code in the macro:
        xHTTP.Open "POST", Sheets(1).Range("K2") & "/Excel_Voucher_Import", False
And replace it by:
        xHTTP.Open "POST", Sheets(1).Range("K2"), False


Edit cell K2 and set it to :
https://[fqdn]/psc/ps/EMPLOYEE/ERP/s/WEBLIB_AP.VOUCHER_ID.FieldFormula.Iscript_Excel_Voucher