Internal Audit - Vendor Payment Process

HitendraD

Payment Internal Audit ensures every vendor payment is timely, compliant, and aligned with organizational policies. It helps detect exceptions, prevent fraud, and strengthen financial controls. By continuously monitoring disbursements, it protects cash outflows and improves overall process integrity.

1. Which dataset did you use?

The dataset was sourced from Oracle Fusion Cloud ERP – Payables Payments, extracted using a BIP Data Model SQL and exported as a single CSV file containing all relevant payment attributes. No star schema or multi‑table model was created.

2. How did you analyze or prepare the data?

For data preparation, the following steps were performed within Oracle Analytics:

1. Data Cleaning & Null Replacement
   • Reviewed the extracted dataset and replaced null or blank values with appropriate expected values to ensure completeness and prevent calculation issues in the visuals.
2. Data Type Corrections
   • Rectified incorrect data types (e.g., converting text to dates, numbers, and currency formats).
   • Ensured each column was mapped to the correct semantic type for accurate aggregations and filtering.
3. Dimension & Measure Refinement
   • Reclassified ID‑related fields from Measures to Dimensions to ensure proper grouping, filtering, and drill‑downs.
   • Verified that numeric fields used purely as identifiers were not included in aggregations.
4. Creation of Calculated Columns
   • Added new calculated fields required for analysis (e.g., date buckets, status flags, derived KPIs).
   • Ensured all transformations supported the final storytelling and visualizations.
5. Formatting Standardization
   • Applied proper formatting to date fields (consistent date hierarchy) and numeric fields (currency, decimal precision).
   • Ensured visual readability and consistency across the dashboard.

These preparation steps ensured the dataset was clean, structured, and ready for meaningful insights in Oracle Analytics.

3. Who is the intended audience for your visualization?

Disbursement Head of Department, Internal Audit Team, Process Manager, Finance Manager, Compliance & Risk Management Team, Senior Management

4. What is your visualization about, and what question or problem does it address?

The visualization focuses on Vendor Payments from an Internal Audit perspective, highlighting key exceptions and control gaps that require immediate attention. It provides a clear view of payment patterns, risk indicators, and audit‑critical metrics that help identify unusual transactions or potential non‑compliance.

The primary purpose of the dashboard is to help the business proactively monitor exceptions, understand the root causes, and take timely corrective actions. By surfacing audit‑relevant insights—such as Late payments, discount Lost, Unreconciled Payment, Invoice & Payments created by same User — the visualization supports stronger financial governance and improves the overall quality of the disbursement process.

5. Did you use any Oracle Analytics AI features when building your visualization (ex. AI Assistant)? If so, please describe how they were used.

I leveraged Automatic Clustering to identify and categorize users based on their behavior and transaction patterns. This AI‑driven clustering helped segment users into meaningful groups, allowing us to prioritize high‑risk or exceptional cases more effectively.

VishwasJohari

Very well put together. Clear insights and strong business relevance.

Dhiren Gangani

Very well articulated with no much noise and easy to understand.

User_NO120

مميز جدا و عمل منظم ومهم جدا للأعمال التجاريه شكرا لك

Brendan T

Good work with this with the layout, color scheme and the additional narratives for each viz.