Payables and Cash Management - EBS (MOSC)

MOSC Banner

Loading of States for Colombia

Hi

We are trying to use LOV for state field for vendor sites for colombia country,

Created Value set for DFF field (Address) STATE using value set HZ_CO_STATES based on table HZ_GEOGRAPHIES

and where clause

WHERE GEOGRAPHY_TYPE = 'STATE'

AND COUNTRY_CODE = 'CO'

AND SYSDATE >= START_DATE

AND SYSDATE <= NVL(END_DATE, SYSDATE)

ORDER BY GEOGRAPHY_CODE

For now only 3 values are available  (DISTRITO CAPITAL, NO_STATE_VALUE, SANTA FE) We need to add more states to this list would like to know is there a way to add

states to geographies is there anyway to add states for colombia.

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