Looking for federal EIN number

Trupti Khodke

Does anyone know under which subject area is the Federal EIN located ? What is the name of the field ?

Nathan CCC

Hi Trupti,

Is this something you have in the United States of America (US)? Is this a Federal Employment Identification Number (EIN). Please confirm what is this field in the user interface.

https://en.wikipedia.org/wiki/Employer_Identification_Number

Assume this is perhaps an attribute about a legal entity? Select Navigator, select Show More, in folder My Enterprise select work area Setup and Maintenance, select setup offering Workforce Deployment, functional area Legal Structures, task Manage Legal Entity Registrations. Assume that your EIN/TIN are perhaps stored in the database as field Registration Number?

Oracle Fusion Cloud Financials

Tables and Views for Financials

F92647-02 24B

table XLE_REGISTRATIONS

https://docs.oracle.com/en/cloud/saas/financials/24b/oedmf/xleregistrations-26554.html#xleregistrations-26554

view HR_LEGAL_ENTITES

https://docs.oracle.com/en/cloud/saas/human-resources/24b/oedmh/hrlegalentities-3933.html#hrlegalentities-3933

Is this your data?

select all t.registration_number as EIN
, t.* 
from xle_registrations t 
order by t.registration_number asc nulls last, t.registration_id asc nulls last

if so, next look in your data lineage guide to see how many subject areas presentation columns this is mapped to

for example in HCM

https://community.oracle.com/customerconnect/discussion/40249/hcm-otbi-subject-areas-to-database-lineage-mapping-spreadsheet