It is a common question I have encountered in my previous implementations in which Consultants (Technical / Functional / Techno–Functional) or even Business Users (for UAT Purposes) are interested in understanding how in Fusion Applications the UI field getsmapped to their corresponding Data Field in Database.
Truth be told, there isn’t a formal documentation available, but I came across an MOSC document titled ‘Fusion Record Names.pdf’ ( https://community.oracle.com/docs/DOC-821238) shared by Prasanna and compiled by him for few of the objects related to HCM.
I have tried to present the same in an easier, readable format, but credit for the hard work goes to Prasanna.
Before starting, let us try to define / explain the terminologies used in this article. They are:
-
Object Name
These are the specific objects or Business Entities which are generally represented as a single page or multiple pages on UI. Some examples being Person, Person Documentation,
WorkRelationshipByPerson, Location, Jobs, JobFamily, Position, Business Units, Department, Grades, Grade Rates, Element Entry, to name a few.
-
Search Records
These are the Record Types which are exposed on the UI pages to enable search (Each Page has a search button and that search is executed on a record type variable which is basically a UI Page). Few Examples being per_persons, per_all_people_f ,
per_person_names_f ,per_email_Addresses etc.
-
Base Records
These are actual Base Records (actual DB Tables). Few examples being
PER_DRIVERS_LICENSE_TYPES, PER_DRIVERS_LICENSES, PER_PERSON_DLVRY_METHO
DS,PER_IMAGES ,PER_CITIZENSHIPS,PER_CONTACT_RELSHIPS_F, PER_PERSON_TYPE_USAGES_M ,PER_RELIGIONS ,PER_PHONES ,PER_NATIONAL_IDENTIFIERS, to name a few.
In Essence, based on the spreadsheet below, first you need to identify the Business Object (from Fusion UI), and then check all the corresponding tables mentioned in it, and look for the data field. In most cases, the names of the field (called LABEL / PROMPT in UI) correspond to similar names in the Database, but in case of any discrepancy, you may raise an SR to get the same clarified. You may even verify the same by entering some data in UI, and checking the same using SQL queries on the Database side (using BI Data Model in SaaS Environment).
This is not the complete list, but it is probably the most commonly used. I would try adding more once I collect more information on it.
CONTD......
CONTD......
Apps2Fusion Articles 
Comments
RSS feed for comments to this post