Canada AP Check does not have payer province in xml output from format payments
We are creating an rtf template for use with the payment process using the standard xml output from the format payment instructions request. The XML output does not have the province value for the payer. The state value is blank and there is no other xml token that would hold this value. I've tried to drill down into the code that generates this xml and I think it's in the IBY_FD_EXTRACT_GEN_PVT.Get_Hr_Address which looks at the IBY_XML_HR_ADDR_1_0_V view. This view contains the logic below:
XMLElement("State", decode(hr_loc.country, 'CA', null, hr_loc.region_2))
Tagged:
0