Country Label Changed on the Redwood Personal Details Page in Demographic Info Region

A story about Consultant how he/she received a requirement to test a fature:

Client said as we are testung the new features of 25B, and recently oracle has released a update where oracle mentioned that now Country label change to Country for Demographic Reporting in Personal Details page for an employee, where client wants to understand after this update somehow it will impact on any workflow then consultant did some reasched and found that as this is only a label change, so consultant mententioned that I dont think so there would be any impact. As this is only label change.

This was first challenge, now again client come to the consultant and said do you know where exectly store this value in the table or in OTBI.

Consultant did some researched and identified that yes this is a table and column and also consultant shows that the OTBI screenshot where the value store.

Attached SQL

SELECT 
    ppf.person_number AS PERSON_NUMBER,
    paa.legislation_code AS COUNTRY_CODE,
    ft.territory_short_name AS COUNTRY_NAME
FROM 
    per_all_people_f ppf
JOIN 
    per_all_assignments_m paa ON ppf.person_id = paa.person_id
JOIN 
    fnd_territories_vl ft ON paa.legislation_code = ft.territory_code
WHERE 
    ppf.person_number = :person_number
    AND ppf.effective_end_date = TO_DATE('4712/12/31','YYYY/MM/DD')
    AND paa.effective_end_date = TO_DATE('4712/12/31','YYYY/MM/DD')
    AND paa.primary_flag = 'Y'

Attached OTBI Screenshot

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.