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 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 MoreHow to terminate employee from HDL in Oracle cloud HCM?
HDL is HCM Data loader tool to create and Integrate the Employee Information in Oracle cloud. With the Help to HDL tool we can create and update Employee Information from External system. In the Same way if we want to Terminate the Employee from Back end or form External System then we can also do the same through HDL tool. HDL tool helps to allow the Employee Termination […]
Read More