IAGACK – Transaction Data Platform

Tech Stack: Oracle Database 19c • PL/SQL • DBMS_SCHEDULER • SQL Developer • Oracle Analytics Cloud (OAC)
Use Cases: GL ↔ Sub-ledger reconciliation • Variance checks • ETL orchestration • Financial KPI reporting

Author: Tarek I. Adam — Oracle Cloud Certified Consultant (Top 10 in Race to Certification 2025)

IAGACK is an Oracle-based PL/SQL platform for GL and sub-ledger reconciliation, variance checks, ETL automation, and operational KPI reporting.
It provides robust audit control, automated job scheduling, and analytics-ready outputs for finance teams using Oracle Analytics Cloud (OAC).

---

Table of Contents

• Features
• Files
• Quick Start
  • Database Setup
  • Application Setup
  • Commands (optional)
• Author

---

Features

• Sub-ledger → GL reconciliation (daily ETL validation)
• Variance checks and audit trail tracking
• Finance KPIs and exception reporting
• Automated DBMS_SCHEDULER job for nightly reconciliation
• Sample data and PL/SQL packages for demonstration

---

Files

• schema.sql – Core GL/Subledger tables
• sample_data.sql – Demo dataset
• plsql_packages.sql – Reconciliation & variance package
• reports_queries.sql – Finance KPIs and exceptions
• jobs_scheduler.sql – Nightly scheduler job

---

Quick Start

Database Setup {#database-setup}

-- 1) Create tables
@schema.sql

-- 2) Load sample data
@sample_data.sql

-- 3) Create PL/SQL packages (recon & variance)
@plsql_packages.sql

-- 4) Create KPI/exception views & queries
@reports_queries.sql

-- 5) Schedule nightly reconciliation
@jobs_scheduler.sql

Application Setup {#application-setup}

1. Clone the repository
2. Install dependencies
3. Run the app

Commands (optional)

# Clone
git clone https://github.com/tibrahim62/iagack-transaction-data-platform.git
cd iagack-transaction-data-platform

# (Optional) Run SQL scripts from sqlplus (you'll be prompted for the password)
# Use a DB alias or wallet alias (e.g., DBNAME_HIGH)
sqlplus admin@your_db_alias @schema.sql
sqlplus admin@your_db_alias @sample_data.sql
sqlplus admin@your_db_alias @plsql_packages.sql
sqlplus admin@your_db_alias @reports_queries.sql
sqlplus admin@your_db_alias @jobs_scheduler.sql

⬆️ Back to top

---

Author

Built by Tarek I. Adam – Oracle Cloud Certified Professional
as a public demonstration of practical Oracle analytics on Oracle Cloud.
Stack: Oracle ADB (Vector Search), PL/SQL, APEX, OAC, OIC
LinkedIn | GitHub

⬆ Back to top