How 450gowsik/kovaion_finance works
Kovaion Finance is an Oracle APEX finance operations application for invoice ingestion and reconciliation, payments, and financial reporting. The primary workflow runs from an analyst uploading a file through import processing and database synchronization, then presents invoice, payment, dashboard, and tax insights through APEX pages. The README documents the package and data relationships, but no source excerpts were supplied, so the graph reflects documented behavior only; the package path points to the package-spec SQL file listed in the tree.
Main entry points: master_schema.sql Analytical views · step1_package_spec.sql Import coordinator · p00001-home.apx Executive dashboard · p00010-invoices.apx Invoice grid
Components 19
APEX experience
- Executive dashboard
pages/p00001-home.apx - Invoice grid
pages/p00010-invoices.apx - Invoice form
pages/p00011-invoice-form.apx - Invoice uploader
pages/p00012-import-invoices.apx - Financial reports
pages/p00040-reports.apx - Payments
pages/p00050-payments.apx - Payment form
pages/p00051-create-payment.apx - Login
pages/p09999-login.apx
Invoice ingestion
- Import coordinator
step1_package_spec.sql - Normalize and cast
step1_package_spec.sql - Target synchronization
step1_package_spec.sql
Finance data
- Upload staging
master_schema.sql - Vendor records
master_schema.sql - Invoice records
master_schema.sql - Import errors
master_schema.sql - Payment records
master_schema.sql - Audit logs
master_schema.sql
Reporting
- Analytical views
master_schema.sql
Other components
- Finance analyst
Connections 19
- Finance analyst → Invoice uploader: uploads file
README.md - Finance analyst → Executive dashboard: views dashboard
README.md - Finance analyst → Invoice grid: manages invoices
README.md - Finance analyst → Financial reports: views reports
README.md - Finance analyst → Payments: tracks payments
README.md - Invoice uploader → Import coordinator: passes upload
README.md - Import coordinator → Upload staging: purges staging
README.md - Import coordinator → Normalize and cast: parses and normalizes
README.md - Import coordinator → Target synchronization: synchronizes records
README.md - Target synchronization → Vendor records: upserts vendors
README.md - Target synchronization → Invoice records: inserts invoices
README.md - Target synchronization → Import errors: logs exceptions
README.md - Payments → Analytical views: reads summaries
README.md - Executive dashboard → Analytical views: reads live metrics
README.md - Invoice grid → Analytical views: reads invoice data
README.md - Financial reports → Analytical views: reads tax reports
README.md - Analytical views → Invoice records: aggregates finance data
README.md - Analytical views → Payment records: aggregates payments
README.md - Analytical views → Vendor records: joins vendor data
README.md