My Oracle Support Banner

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 SEPTEMBER 29, 2020

Applies to:

Oracle Human Resources - Version 12.2 HRMS RUP12 and later
Information in this document applies to any platform.

Goal

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/),[19] 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
 

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


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