GP CHE - Dashboard - Municipality Error During The Validation

(Doc ID 2330265.1)

Last updated on NOVEMBER 20, 2017

Applies to:

PeopleSoft Enterprise HCM Global Payroll Switzerland - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Dashboard ending in error

[error] : Line= 217397 Column= 76 Text: org.xml.sax.SAXParseException: cvc-datatype-valid.1.2.1: 'Bo�te 2600' is not a valid value for 'integer'.

Actually a code change from long ago got reversed (even in standard).

In GPCH_EG_INS_DW.Funclib for municipality we need to read ADDR_FIELD3 instead of ADDRESS3

Function Get_Address()
  /*************************************************************************************/
  /*FMB 20120530 */
  rem SQLExec("Select ADDRESS1,ADDRESS2,POSTAL,CITY, ADDRESS3, ADDRESS4 from PS_ADDRESSES where EMPLID = :1 AND ADDRESS_TYPE = :2 AND EFFDT = (Select MAX(EFFDT) from PS_ADDRESSES WHERE EMPLID = :1 AND ADDRESS_TYPE = :2 and EFFDT <= %Datein(:3) )", &Emplid, &Addr_Type, GPCHINS_AET.GPCH_AL_CPAY_ENDDT, &Addr1, &Addr2, &Postal, &City, &Municipality, &Postbox);
  SQLExec("SELECT COUNTRY, ADDRESS1,ADDRESS2,POSTAL,CITY, ADDR_FIELD3, ADDRESS4, STATE FROM PS_ADDRESSES WHERE EMPLID = :1 AND ADDRESS_TYPE = :2 AND EFFDT = (SELECT MAX(EFFDT) FROM PS_ADDRESSES WHERE EMPLID = :1 AND ADDRESS_TYPE = :2 AND EFFDT <= %Datein(:3) )", &Emplid, &Addr_Type, GPCHINS_AET.GPCH_AL_CPAY_ENDDT, &ACountry, &Addr1, &Addr2, &Postal, &City, &Municipality, &Postbox, &AState);
  
  &Addr_xml = AddCreateElement(&Particulars_xml, "Address");


The field ADDR_Field3 gets only filled for Swiss addresses and the contents gets validated.
The above change will solve the issue.

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