| Client | VMC |
| Industry | Technology Services |
| Oracle Version | Oracle E-Business Suite 11i |
| Modules | PO AP GL PL/SQL |
| Engagement Period | 2006 – 2007 |
| Project Type | Oracle EBS Implementation with Custom PL/SQL Development |
| Complexity | Medium · 226 Files · Training Included · Custom Development |
VMC engaged William Delaney Consulting for an Oracle EBS 11i implementation combining standard module configuration (PO, AP, GL) with custom PL/SQL development to address business requirements that Oracle's standard functionality did not cover. The engagement also delivered training materials and multimedia content (.swf, .avi files indicate screen-capture based training videos) — an elevated training investment reflecting either a complex system or a user population requiring more than document-based training.
The combination of Oracle functional configuration, custom PL/SQL development, and video-based training indicates an engagement designed for sustained user adoption — not just system go-live. Custom development without training investment frequently produces systems that are technically correct but operationally underutilized.
Technology services organizations implementing Oracle EBS commonly have IT staff who understand Oracle technically but lack Oracle functional expertise. This creates a distinctive engagement dynamic: the client's IT team can maintain and support Oracle technically, but needs the consultant to design and configure the functional layer correctly. The custom PL/SQL development in this engagement was likely produced collaboratively — the consultant designed the solution and the client's IT team participated in build and testing.
Video-based training (.swf Flash files were the standard screen-capture training format of the 2006–2007 era) indicates that VMC's users were geographically distributed or that the training content needed to be reused beyond the initial go-live training sessions — a recognition that one-time classroom training is insufficient for Oracle EBS adoption.
Standard Oracle Purchasing, Accounts Payable, and General Ledger configuration covered the core P2P and financial reporting cycle. Configuration decisions were documented with business rationale — enabling the client's Oracle administrator to understand and maintain settings post-engagement.
Custom PL/SQL packages were developed to address gaps between Oracle's standard functionality and VMC's specific business requirements. The development followed Oracle's customization guidelines — custom objects in a separate schema, use of Oracle public APIs where available, and documentation sufficient for ongoing maintenance by a new developer.
Screen-capture training videos (Flash/.swf format) were produced for key Oracle processes — providing an on-demand training resource that new users could access after go-live without requiring consultant availability. Videos were organized by role and process, covering the most frequently performed Oracle tasks.
| Deliverable | Type | Purpose |
|---|---|---|
| PO/AP/GL Configuration Documentation | Configuration Document | Oracle module configuration with business rationale for all key configuration decisions |
| Custom PL/SQL Package Documentation | Development Documentation | Technical specification, source code, and maintenance guide for custom PL/SQL components |
| Screen-Capture Training Videos (.swf) | Training | On-demand process training videos for key Oracle workflows by role |
| Training Guide Documents | Training | Companion text guides for training videos with step-by-step instructions and screenshots |