How to Update The Lookup Values: Meaning IN_STATES And IN_PIN_CODES Needs Updated for India States?
(Doc ID 2535299.1)
Last updated on JUNE 16, 2022
Applies to:Oracle Human Resources - Version 12.2 HRMS RUP12 and later
Information in this document applies to any platform.
On : 12.2 HRMS RUP12 version, People Management
In the IN_STATES HRMS lookup table the meanings are not matching to what is in Taleo and as well as not matching based on google keyword searching. Since these are system access level tables.....
1a) Update the meaning for code CG as it is spelled incorrectly it should be Chhattisgarh (according to keyword search online),
1b) If this cannot be updated, add a new value CT and meaning Chhattisgarh (the correct spelling)
1c) If Chhattisgarh (CT) is added then the IN_PIN_CODES lookup table need to have it added there as well with code = CT and meaning 49
2a) Update the mearning for code UA Uttaranchal to Uttaranchal (according to keyword search using google Uttarakhand (/ˌʊtəˈrɑːkʌnd/), formerly known as Uttaranchal
2b) If this cannot be updated, can a new value be added with the correct spelling code Add Uttarakhand (UT)
2c) If Uttarakhand (UT) is added then the IN_PIN_CODES lookup table need to have it added there as well with code = UT and meaning 24, 26
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