Sql Query to extract all the AR receipts applied to a particular AR invoice in Oracle cloud ERP
This query extracts all the AR receipts which are applied to a particular AR invoice in Oracle cloud ERP. This query is really helpful when doing root cause analysis for a particular AR invoice issue. We have included important columns like Receipt Date, AR invoice number and Receipt Bank account name.
Read MoreSql query to extract all AR invoices for a particular customer in oracle cloud ERP
This query extracts all the AR invoices for a particular customer in oracle cloud ERP. This helps in checking which invoices have been closed and which are still open for a particular customer.
Read MoreSql 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 MoreSQL query to extract all the open AR invoices for a particular BU in oracle cloud ERP
This query helps in extracting all the open AR invoices for a particular BU in oracle cloud ERP. This is extremely helpful in sending the extract to dunning softwares. SELECT apsa.TRX_NUMBER TRANSACTION_NUMBER , hou.NAME BU_NAME, CST.ACCOUNT_NUMBER CUSTOMER_NUMBER , hp.PARTY_NAME CUSTOMER_NAME , apsa.CLASS TRANSACTION_CLASS , rctta.NAME TRANSACTION_TYPE , rctta.DESCRIPTION TRANSACTION_TYPE_DESC, apsa.INVOICE_CURRENCY_CODE TRX_CURRENCY , apsa.AMOUNT_DUE_REMAINING AMOUNT_DUE_REMAINING, apsa.AMOUNT_DUE_ORIGINAL […]
Read MoreSql query to Extract all Open AR invoices for a particular Customer in Oracle cloud
This query helps in extracting all the Open AR invoices which are still open for a particular customer in oracle cloud ERP. This is particularly helpful in dunning operations when sending data to third parties which expect to send the dunning letters to customer for unpaid invoices from their end.
Read MoreSQL Query to Find all the unreconciled Bank statement lines for a particular bank account in oracle cloud
This query helps find the bank statement lines through the Oracle cloud Database which are lying unreconcilled for a particular bank account. We have included all important columns from Bank statement headers and lines tables which we though will be important in identifying the bank statement lines. This information and extract is specially helpful to run before the month end process to enable quality cash reconcillation processes.
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 MoreQuery to get all Applied Receipts created for a particular Customer/Account in Oracle Receivables
This query gives you all the applied receipts for a particular customer account. It can also be filtered on the date range based on Receipt Date
Read More