You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is there a Oracle DB package / function to retrieve a country code from a given location_id?

Summary:

Hello,

I'm looking for a Package / function which I can use in a BIP datamodel to retrieve a country code for a given location id.

Some of the seeded datamodel within BIP in Oracle fusion use builtin functions for retrieving certain data or to format data, e.g.

AR_BPA_UTILS_PKG
HZ_FORMAT_PUB

examples are:

fnd_currency.get_format_mask(invoice_currency_code, 40 )

AR_BPA_UTILS_PKG.fn_get_contact_name(bill_to_contact_id)

AR_BPA_UTILS_PKG.fn_get_phone(bill_to_contact_id)

or formatting functions like

HZ_FORMAT_PUB.format_address(location_id)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!