R12: AP: Which Table Stores The Country Name For The Country Code Added At The Supplier's Address (Doc ID 2184995.1)

Last updated on JULY 27, 2017

Applies to:

Oracle Payables - Version 12.0.1 and later
Information in this document applies to any platform.

Goal

Country field in the supplier's Address Book. Supplier Site table (AP_SUPPLIER_SITES_ALL ) stores the country code in ISO Format (2 letter name).

What is the table that stores the country name?

For example, for the country code SG, the country name is Singapore that is shown in the LoV while choosing the Country at Supplier's Address Book. Where is the country name 'Singapore' stored?
 

Solution

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