Saturday, December 29, 2012

How to change Name Formats using Person Name Formats

How to Change Full Name

Go to HRMS Super User à Other Definitions à Person Name Formats

Format Type: Full Name
Legislation: <Desired>
User Format Choice: Local Format


Run Program“Update Person Names” to Apply the Changes made

SELECT *
  FROM PER_ROLE_ROLES_V;

select full_name from per_all_people_f where person_id = <person_id>;

Run the Above Scripts to check if the Format of Full Name has changed


How to Change List Name à This is Display Name used in all List of Values

Go to HRMS Super User à Other Definitions à Person Name Formats
Format Type: List Name
Legislation: <Desired>
User Format Choice: Global Format


Run “Update Person Names” to Apply the Changes made

SELECT *
  FROM PER_ROLE_ROLES_V;

Run the Above Script to check if the Format of Display Name has changed


1 comment: