Vendor Payment Reporting (OracleFusion)


This report was a request from Accounts Payable. They wanted to be able to quickly reconcile vendor payments against a vendor’s weekly or monthly statement. The report needed to run lean and have parameters for a user to specify which vendor they are seeking to reconcile. Of course, another requirement was it had to be built within the current accounting system.

Tool: Oracle Fusion

Language: SQL


Data Format: Excel (when exported)

Platform: Oracle Fusion

Requirement/s: Vendor Name, Invoice Number, Payment Method, Payment Amount, Invoice Date, Invoice Amount (additional requirements may be asked by user)

Language: SQL (to extract data)

Project Description: Create a data model utilizing SQL within Oracle Fusion and create a report that will pull the data within the fields specified in the requirements. The report format and data model will be maintained and updated as needed.

SQL Query Syntax
Oracle Fusion Business Intelligence Module where are the reports are stored
Final result of the created report.