Payables and Cash Management - EBS (MOSC)

MOSC Banner

Canada AP Check does not have payer province in xml output from format payments

edited Aug 29, 2013 9:59AM in Payables and Cash Management - EBS (MOSC) 1 commentAnswered
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))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center