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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

[VALUESET]ibge code associated with the city in geographies

edited Jan 11, 2024 11:37AM in Payroll and Global Payroll Interface (GPI) 1 comment

Hello Experts,

In Brazil we associate a code, called "IBGE code" to every city, in geographies we have this code loaded, we discovered that this code is stored in hz_geography_identifiers where identifier_subtype = 'IBGE_CODE'.

Our requisition is to create a value set to be used in the task "Hire an Employee" and verify based on the city based on the city value filled in on the screen, use this "IBGE CODE" to filter our value set and show the neighborhood only to that city.

Is there any valueset with the citys from a geography to use? how can i check the city filled on screen as a clause on sql for a value set?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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