All posts on Sample SQL Queries

Passing Logged in User details to HCM Extract

  • Post published:July 24, 2020
  • Post category:HCM Extract
  • Post comments:0 Comments
  • Post last modified:July 24, 2020
Passing Logged in User details to HCM Extract
Passing Logged in User details to HCM Extract

Do you know that you can get the Logged In User details in HCM Extract? Why the seeded functions which return user details in BIP does not work in advanced filter directly? Read on to know more details.

Continue Reading Passing Logged in User details to HCM Extract

SQL Query to find the Position Incumbents

  • Post published:July 24, 2020
  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:July 24, 2020
SQL Query to find the Position Incumbents
SQL Query to find the Position Incumbents

Do you know how to build query to find out the Position Incumbents? Position Incumbents are nothing but the employees hired into the Position. Read on to know more details.

Continue Reading SQL Query to find the Position Incumbents

Running the latest extract version using Payroll Flow

  • Post published:July 1, 2020
  • Post category:HCM Extract
  • Post comments:0 Comments
  • Post last modified:July 1, 2020
Running the latest extract version using Payroll Flow
Running the latest extract version using Payroll Flow

Have you faced issues with multiple versions of extracts? How do you migrate the extract changes to other instances when the target instance already has the extract? Read on to know more details.

Continue Reading Running the latest extract version using Payroll Flow

SQL Query to find pending approval transactions from Workflow tables

  • Post published:June 26, 2020
  • Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:June 26, 2020
SQL Query to find pending approval transactions from Workflow tables
SQL Query to find pending approval transactions

Have you used the approval related tables to fetch the In Progress/Approved/Withdrawn transactions? Can you do another transaction on the business object which has an in process approval? Read on to know more details.

Continue Reading SQL Query to find pending approval transactions from Workflow tables