top of page

Tags

Archive

Query to find User and manager name -Oracle Fusion


SELECT pu.username "LOGIN_USERNAME",

pu.SUSPENDED,

papf.person_number,

to_char(pu.creation_date, 'DD-MON-YYYY') "LOGIN_CREATION_DATE",

hp.person_first_name "FIRST_NAME", hp.person_last_name "LAST_NAME",

hp.email_address,

gcc.segment2 employee_cost_center,

pu1.username "MGR_USERNAME",

hp1.person_first_name "MGR_FIRST_NAME", hp1.person_last_name "MGR_LAST_NAME",

papf1.person_number manager_person_number

FROM per_users pu,

hz_parties hp,

per_all_assignments_m paa,

PER_ASSIGNMENT_SUPERVISORS_F pas,

per_users pu1,

hz_parties hp1,

per_all_assignments_m paa1,

gl_code_combinations GCC,

per_all_people_f papf,

per_all_people_f papf1

WHERE pu.username not like 'FUSION_APPS_%'

and pu.username not in ('weblogic_idm', 'oamAdminUser', 'IDROUser')

and pu.user_guid = hp.user_guid

and pu.person_id = paa.person_id (+)

and paa.assignment_id = pas.assignment_id (+)

and pas.manager_assignment_id = paa1.assignment_id (+)

and paa1.person_id = pu1.person_id (+)

and pu1.user_guid = hp1.user_guid (+)

and (paa.effective_end_date > sysdate OR paa.effective_end_date IS NULL)

and ( paa1.effective_end_date > sysdate OR paa1.effective_end_date IS NULL)

and paa.DEFAULT_CODE_COMB_ID = gcc.code_combination_id (+)

and (paa.PRIMARY_ASSIGNMENT_FLAG = 'Y' or paa.PRIMARY_ASSIGNMENT_FLAG IS NULL)

and pu.person_id = papf.person_id (+)

and pu1.person_id = papf1.person_id (+)

ORDER BY pu.username




11,688 views0 comments

Recent Posts

See All

When transactions are entered, Dynamic Insertion in Oracle Fusion General Ledger (GL) allows an organisation to automatically insert extra segments or values in the GL chart of accounts. This feature

Oracle Fusion Segment Security The General Ledger (GL) feature enables an organisation to restrict access to data in the GL depending on certain parts of the GL chart of accounts. A segment is a subse

Oracle Fusion General Ledger (GL) Cross-Validation Rules are used to assure the integrity and accuracy of data entered into the GL module. They are used to ensure that data submitted in the GL is cons

Other Posts you may Interested 

bottom of page