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
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

[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!