My Oracle Support Banner

Fusion Global HR: TOWN_OR_CITY From PER_ADDRESSES_F Table Attribute Size Change Starting with Release 23A (Doc ID 2870877.1)

Last updated on MAY 20, 2022

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.22.04.0 and later
Information in this document applies to any platform.

Details

Starting with Release 23A TOWN_OR_CITY attribute field length from PER_ADDRESSES_F table will be increased from 30 characters to 60 characters.

Reason for this change is to allow saving in PER_ADDRESSES_F table the data entered into the TCA Geography data for a Town or City having more than 30 characters.
This change will apply to all addresses saved within Human Capital Management (HCM), not limited to a person's address, but also the work location address, Health and Safety Incident address or a Candidate address.

Actions

There are 3 main areas consumers of address must review and determine if changes are needed:

1. BI Reports

Consider adjusting the layout of the report to accommodate 60 characters.

If using OTBI reports, download the HCM OTBI subject areas to database lineage mapping spreadsheet and filter by database table = PER_ADDRESSES_F and column= TOWN_OR_CITY to find all Subject Areas with references to impacted object. Review Reports associated to these Subject Areas.

 

2. System Extracts

Any system extract that references the Town or City: if the application that receives the output file can't handle 60 characters for the Town or City, you may need to adjust your system extract layout to limit it to your downstream application field size. 

Review the following:

2.1. Any Fast Formulas using below Database Item Groups (DBIs):

1 HRM_PLAN_EXTERNAL_CANDIDATE_TOWN_OR_CITY   14 PER_ADD_TOWN_OR_CITY   27 PER_LOC_TOWN_OR_CITY
2 HRX_AU_TFN_PAYEE_SUBURB_TOWN_OR_CITY   15 PER_ASG_ADD_TOWN_OR_CITY   28 PER_ORG_LOC_TOWN_OR_CITY
3 HRX_FR_EXT_BIAF_LOC_TOWN_OR_CITY   16 PER_ASG_LOC_TOWN_OR_CITY   29 PER_PER_ADD_TOWN_OR_CITY
4 HRX_FR_EXT_LOC_TOWN_OR_CITY   17 PER_ASG_LOCATION_ADD_USAGE_TOWN_OR_CITY   30 PER_PER_CONTACT_TOWN_OR_CITY
5 HRX_HK_HOME_ADDRESS_FULL   18 PER_EXT_ADDR_TOWN_OR_CITY   31 PER_PER_HOME_ADDR_TOWN_OR_CITY
6 HRX_HK_POSTAL_ADDRESS_FULL   19 PER_EXT_CONT_TOWN_OR_CITY   32 PER_PER_MAILING_ADDR_TOWN_OR_CITY
7 HWM_PER_ASG_LOC_TOWN_OR_CITY   20 PER_EXT_HIST_ADDR_TOWN_OR_CITY   33 PER_PER_PERSON_ADD_USAGE_TOWN_OR_CITY
8 HWP_PER_HOME_CITY   21 PER_EXT_HIST_LOC_TOWN_OR_CITY   34 PER_PER_PRIMARY_ASG_LOC_CITY
9 IRC_CSP_CANDIDATE_CITY   22 PER_EXT_HIST_ORG_LOC_TOWN_OR_CITY   35 PER_TRM_LOC_TOWN_OR_CITY
10 IRC_CSP_REQ_WORKLOCATION_OTH_CITY   23 PER_EXT_LOC_TOWN_OR_CITY   36 US_GET_RESIDENT_CITY
11 IRC_CSP_REQ_WORKLOCATION_PRIM_CITY   24 PER_EXT_LOCATION_CHANGES_TOWN_OR_CITY   37 US_QTD_ARCHIVE_PR_LOC_ADD_CITY
12 NL_EMP_DSR_TOWN_CITY   25 PER_EXT_ORG_LOC_TOWN_OR_CITY      
13 ORA_PAY_BANK_PAYMENT_CHECK_TOWN_OR_CITY   26 PER_EXT_PER_ADDR_TOWN_OR_CITY      

 

2.2. Any HCM Extracts using below DBIs:

1 Address Town or City   13 Extract Historical Organization Location Town Or City   25 Location Town Or City
2 Assignment - Location Town or City   14 Extract Historical Person Address Town or City   26 NL Digital Sickness Report Employee Address City
3 Assignment Location Address Usage Town or City   15 Extract Location Town Or City   27 ORA_PAY_BANK_PAYMENT_CHECK_TOWN_OR_CITY
4 Assignment Location Town or City   16 Extract Organization Location Town Or City   28 Organization Location Town or City
5 Australian TFN Declaration Report Payee Suburb Town Or City   17 Extract Person Address Town or City   29 Person Address Usage Town or City
6 Cities of the other work locations of the requisition   18 Extract Person Contact Town or City   30 Person Home Town or City
7 City of the candidate   19 Extract Succession Plan External Candidate Town Or City   31 Person Mailing Town or City
8 City of the primary work location of the requisition   20 French BIAF Location Town or City   32 Person Primary Assignment Work Location City
9 Extract Address Town or City   21 French Location Town or City   33 Person Town or City
10 Extract Changed Location Town Or City - Obsolete   22 Home city   34 US_QTD_ARCHIVE_PR_LOC_ADD_CITY
11 Extract Contact Town or City   23 Hong Kong Person Home Address   35 Work Term Location Town or City
12 Extract Historical Location Town Or City   24 Hong Kong Person Postal Address      

You can run queries to retrieve above list as well. Refer to HCM Extracts & DBIs impacted - Helper Queries. For details on how to run a query check Doc ID 1910762.1.

 

3. REST APIs

Integrations consuming the Town or City by any of the following REST APIs:

Workers, Public Workers, Locations V2, HCM Contacts, Recruiting Candidates or Recruiting CE Candidate Details.

 

Note: If you're displaying the Town or City attribute in any of your custom application pages, then you may need to adjust the attribute length to fit 60 characters.

Contacts

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
Details
Actions
Contacts
References

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