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 MoreSQL query to find the bank statement Headers and lines for a particular bank account in Oracle ERP cloud/Fusion
This sql query shows the Important columns from Bank Statement headers table and bank statement lines table in oracle Fusion for a particular Bank account. This query forms critical base for the Oracle cash management. We have already applied filters based on Bank account but the filters based on amount, transaction date and statement number can be easily added here. Querying through the database is much faster than through the front end to find a particular statement line.
Read More