Enterprise engineering
Fleet System Integration
An end-to-end Oracle EBS integration automating the fleet procurement cycle from requisition through purchase order, goods receipt, and AP invoice processing.
- Role
- Oracle integration developer
- Timeline
- 2024 to Present
- Outcome
- Removes manual handoffs across the full requisition-to-payment cycle for fleet transactions.
The problem
Fleet transactions span purchase requisition, purchase order, goods receipt, and invoice stages, with data originating outside Oracle EBS and requiring validation, matching, and exception handling at each step before financial processing.
The approach
Built a staged PL/SQL integration that automates the requisition-to-invoice flow, applying business-rule validation, purchase-order matching, and rounding or amount-mismatch handling before records reach the Oracle AP interface.
Implementation
- Automated purchase requisition to purchase order flow for fleet transactions
- Goods receipt processing and matching against purchase orders
- External fleet invoice data preparation and Oracle AP integration
- Business-rule validation and purchase-order matching before AP interface processing
- Rounding and amount-mismatch handling
- Exception handling for failed transactions across the requisition-to-invoice cycle
Technology
Oracle E-Business Suite R12, Oracle Purchasing, Oracle Accounts Payable, Oracle Database, PL/SQL, AP Open Interfaces, ERP Integration