⚡ Enterprise IT APEX

Multi-Client Financial Activity Platform

DB Realm Inc. (Internal)

Challenge

Needed a unified platform to track credit card transactions, bank activity, invoices, expenses, and rental property finances across multiple clients with automated tax calculations.

Solution

Built a 42-page Oracle APEX application with 17 FIN_* tables, 8 views, automated invoice extraction via n8n pipelines (135+ PDFs processed), multi-client billing with per-client rate history, and Canadian GST/HST/PST tax calculations.

Results

  • ✓ 42 production APEX pages
  • ✓ 135+ invoices auto-extracted from Google Drive
  • ✓ 17 database tables with full audit trails
  • ✓ Plaid API integration for automated bank sync
APEX 24.2 Oracle 23c n8n Plaid API PL/SQL

The Financial Activity Platform keeps the financial records for DB Realm Inc. and its clients in one Oracle APEX application: credit card reconciliation, bank transaction categorization, invoices, expenses and rental property accounting.

Invoices come in through an n8n pipeline. It has processed 135+ PDFs from Google Drive, parses each one with AI-assisted extraction, and loads the results into Oracle through staging tables, using bind variables throughout.

Bank accounts sync through the Plaid API. Canadian federal and provincial taxes (GST/HST/PST) are calculated from rate tables that can be changed without a code release.

Ready to Build Something Similar?

Let's discuss how we can bring the same expertise to your organization.

Start a Conversation