Contact person: Business Client

Phone:Show

Email:Show

Location: Dammam, Saudi Arabia

Budget: Recommended by industry experts

Time to start: As soon as possible

Project description:
"Functional Scope
1. Administration

• Organizational structure, roles, and permissions.
• Master data setup: Clients, Equipment, Drivers, Locations, and Sites.
• Reference tables (statuses, types, payment terms, roles).
• Admin dashboards and master reports.

2. Operations & Maintenance

• Workflow: Client Request → Quotation → Contract → Equipment Work Order → Delivery → Daily Operation → Fuel → Maintenance → Closing.
• All forms OP-01 to OP-10 included.
• Reports: Utilization, Fuel cost, Maintenance cost, Profit per Equipment.

3. Finance & Accounting

• Invoices, Receipts, Expense Requests, Journal Entries.
• Revenue and cost linked per equipment and contract.
• Reports: Income Statement, Balance Sheet, Cash Flow, VAT, Equipment Profitability.

4. Legal & Contracts

• Contract templates, financial guarantees, damage records, and claims tracking.
• Legal dashboards and alerts for contract expiry, claims, guarantees.

5. HR & Admin Affairs

• Employee & driver records, attendance, leaves, payroll, performance, safety training.
• Reports: Salary, Attendance, Evaluation, Training, Turnover.

6. Dashboards & KPIs

• Operational: Utilization %, Fuel vs. Revenue, Maintenance Rate.
• Financial: Profit Margin, Collection %, AR Aging, Cash Flow.
• HR: Attendance Rate, Performance Average, Safety Training.

7. Document Management
Automatic folder-like organization in APEX (digital archive):
/Administration/, /Operations/, /Finance/, /Legal/, /HR/, /Reports/.

⸻

Technical Requirements
• Platform: Oracle APEX 24.1
• Theme: Universal Theme (Vita)
• Database: Oracle Autonomous / XE
• Development Tools: Quick SQL + APEX Builder
• Language: Fully bilingual (Arabic/English)
• Layout: RTL compatible
• Security: Row-Level Security (optional OWNER_ORG_ID)
• Data Columns:
• Multi-language fields: *_AR (NVARCHAR2), *_EN (VARCHAR2)
• Audit columns: CREATED_BY/AT, UPDATED_BY/AT, STATUS
• Auto-numbering sequences (e.g., CTR-YYYY-####)

⸻

UI/UX Requirements
• Dashboard-based homepage (KPIs, summary charts).
• Professional cards, faceted search, master-detail pages, and interactive reports.
• Navigation menu (AR/EN).
• Language switch button (Arabic ↔ English).
• RTL layout for Arabic screens.
• Print-friendly invoice and reports" (client-provided description)