Legal Employer table in oracle fusion

Legal Employer table in oracle fusion

Legal Employer creation is one of the first step in oracle fusion for any BU implementation. We do create the legal employer in oracle fusion as a Legal entity. We do mention all legal information’s about the firm and the complete address information’s too in the Legal Entity creation. Then we create our organization structure under that Legal employer in oracle fusion. Legal employer table helps to store the legal entity registration information’s in oracle fusion. Here below I will try to share the detail Legal entity tables and the complete sql query to extract the complete legal employer information in oracle fusion.

3 Important legal employer table in oracle fusion

1.xle_registrations

2.xle_entity_profiles

3.HZ_LOCATIONS

Detail SQL query using legal employer table in oracle fusion

This is the complete sql query which help to extract the information’s related to legal employer in oracle fusion.

select REGISTERED_NAME,REGISTRATION_NUMBER,

ADDRESS1,ADDRESS2,ADDRESS3,ADDRESS4,

CITY,STATE,PROVINCE,COUNTY,ADDRESS_STYLE,

ADDRESS_LINES_PHONETIC,COUNTRY,POSTAL_CODE

 from xle_registrations a1,

xle_entity_profiles a2,

HZ_LOCATIONS A3

where 1=1

and a2.legal_entity_id=a1.source_id

and source_table='XLE_ENTITY_PROFILES'

and a1.location_id=a3.location_id

Legal Employer table in oracle fusion