Vendor Payment Reporting (OracleFusion)

Context

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

Scope

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 code for the data model in Oracle that pulls the data for the report. This is in the Business Intelligence module in Oracle Fusion.

Oracle Fusion Business Intelligence Module where are the reports are stored

 

Final result of the created report.