Enterprise engineering
Commission Posting Integration
Automated commission posting integrations for digital wallet partners and NETTV.
- Role
- Oracle EBS technical engineer
- Timeline
- 2024 to Present
- Outcome
- Automates recurring commission postings across multiple partner channels.
The problem
Commission amounts owed to digital wallet partners and NETTV were calculated outside Oracle EBS and required manual posting into the financial ledger each cycle.
The approach
Built PL/SQL integrations that validate commission data per partner channel and post the corresponding entries into Oracle EBS on a scheduled basis, removing manual posting effort.
Implementation
- Commission posting integration for eSewa, Khalti, and FonePay
- NETTV commission posting integration
- Per-channel validation before posting
- Scheduled processing for recurring commission cycles
Technology
Oracle E-Business Suite R12, Oracle GL, Oracle Database, PL/SQL, Concurrent Processing