SQL Query to fetch the Learner Course Progress Report
Do you know how to fetch the learner course completion details in Oracle Learning Cloud? Read on to know more details.
All posts on BI Publisher
SQL query to fetch Payslip and W-2 delivery preferences
Do you know how to fetch the Payslip and W-2 delivery preferences setup by users? Read on to know more details.
SQL Query to fetch employees with missing bank account
Do you know how to fetch employees without bank account attached to them? Read on to know more details.
SQL Query to fetch Assignment Level Element Entries
Do you know how to fetch the element entries assigned at Assignment level? Read on to know more details.
How to use the Sensitive Data Access Audit feature from 21B?
Do you know how to track the sensitive Data Access Audit? We can track IP Address, Browser, Device, OS, Date, Time, etc and create an OTBI/BI Report out of it. Read on to know more details.
How to find the HCM Groups assigned to Employees?
Do you know what is HCM Group and how to find out employees assigned to different HCM Groups? Read on to know more details.
SQL Query to fetch Benefit Life Events processed for employees
Do you know what is Life Event in Benefits? How to extract the Life Events that were processed for employees? Read on to know more details.
How to Invoke BI Publisher and OTBI Analysis using Web Services?
Do you know how to invoke the Bi Publisher reports and OTBI Analytics using Web Services? What if the BI Publisher has input parameters? Can we still invoke using Web Services? Read on to know more details.
Do you know how to query the payroll flow tables to get the payslips generated count?
Do you know how to query the payroll flow tables to get the count of employees for whom the payslip has been generated? Read on to know more details.
SQL Query to fetch Data Roles and Security Profiles
Do you know how to extract the data roles from a POD? Check which security profiles are mapped to data roles. Read on to know more details.