SQL 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 MoreHow to create Employee from HDL in Oracle cloud HCM?
HDL is known as HCM Data Loader which is used to Create and Update HCM data.
The data Received from external sources can be created or updated through HDL data format.
For creating an employee in oracle, Following are the mandatory Data needed to be given in the HDL file
Read More