My Oracle Support Banner

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 APRIL 25, 2023

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Have more questions?
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.