MFA for Oracle Community

Starting September 2025, Oracle Community will require Multi-Factor Authentication (MFA) for all member logins. This simple extra step helps protect your account—and the community data—by adding an additional layer of security during sign-in.

Sql query to get payroll process name Under a batch Name /Instance name

Oct 20, 2023 11:11AM in BI Publisher Learning Center 3 comments

Hi ,

I am looking for SQL table to get payroll process name currently i can get batchname/Instance name via below query :

SELECT pfi.instance_name FROM pay_flows pf,pay_flow_instances pfiWHERE 1=1AND pf.base_flow_id = pfi.base_flow_idAND pfi.LAST_UPDATE_DATE < sysdate AND pf.base_flow_name = -- - give the name of your HCM extract

Please help me get underlying process name too , I need the process name inside yellow circle

MFA for Oracle Community

Sql query to get payroll process name Under a batch Name /Instance name

Howdy, Stranger!