Sql Query to extract all the expenses submitted during last month in oracle cloud HCM
This query extracts all the expenses with their details submitted during the last month in oracle cloud HCM. It contains all the helpful columns like Employee name and number, Expense report number, Expense report payment status and expense description.
Read MoreSQL query to extract all the expenses submitted for a particular BU in oracle cloud HCM
This Sql query helps in extracting all the Expenses submitted for a particular BU in oracle cloud HCM. This helps in reviewing the total expenses paid for a particular BU. This query includes columns like employee name, employee number, expense report number, expense currency, expense amount etc.
Read MoreSQL query to extract all the expenses submitted by an particular employee in Oracle cloud HCM
This Sql query extracts all the expenses submitted by an employee in oracle cloud HCM. It shows the Expense report level details like the expense report number, employee name and number but also drills down to the expense level details like expense description and amount.
Read More