My Oracle Support Banner

GP CHE - Dashboard - Municipality Error During The Validation (Doc ID 2330265.1)

Last updated on MAY 02, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.