| Client | Pentel of America |
| Industry | Manufacturing — Stationery & Writing Instruments |
| Oracle Version | Oracle E-Business Suite R12 |
| Modules | AP AR GL FA |
| Engagement Period | 2010 – 2012 |
| Project Type | Post-Implementation Support — Diagnostics & Reconciliation |
| Complexity | Medium · 447 Files · 15 Work Streams · Diagnostics Focus |
Pentel of America — the US subsidiary of Pentel Co., Ltd., Japan's leading manufacturer of pens, pencils, and art supplies — engaged William Delaney Consulting for post-implementation support of its Oracle EBS R12 environment. The engagement focused on diagnostics, financial reconciliation, and targeted remediation across AP, AR, GL, and FA — addressing issues that had accumulated following the initial Oracle implementation and had not been systematically resolved.
Post-implementation support engagements of this type are distinct from initial implementations: the system is live and business-critical, users are dependent on it, and problems must be diagnosed and resolved without disrupting ongoing operations. The diagnostic skill set — identifying root causes of Oracle system behavior from audit trails, journal entries, subledger records, and configuration settings — is different from the configuration skill set used during implementation.
The 15-work-stream structure and 447 files document a substantive engagement that addressed issues across multiple modules and required detailed reconciliation work to bring Oracle financial records into alignment with business expectations and supporting documentation.
Pentel of America's Oracle EBS environment, as the US subsidiary of a Japanese parent, carried the additional complexity of intercompany accounting with the Japanese parent entity, transfer pricing for intercompany inventory purchases, and reporting requirements that bridged US GAAP (for US reporting) and Japanese GAAP / IFRS considerations for parent company consolidation. These dimensions add layers of complexity to standard Oracle Financials diagnostics.
Manufacturing subsidiaries of foreign parent companies commonly experience Oracle implementation challenges in areas that pure domestic implementations do not face: intercompany AR/AP matching, foreign currency revaluation at period end, and intercompany elimination entries that must reconcile across two ERP systems with different data models. Diagnosing discrepancies in these areas requires understanding not just Oracle's behavior but also the parent company's accounting expectations.
A systematic reconciliation of Oracle subledger balances to GL was conducted across AP, AR, and FA. Subledger-to-GL reconciliation identifies cases where transactions posted in a subledger did not transfer correctly to the GL — a common post-implementation issue caused by interface errors, posting failures, or accounting rule misconfigurations that were not caught during go-live testing.
AP diagnostics focused on: payment reconciliation (payments posted in Oracle not matching bank statements), invoice holds analysis (invoices on hold beyond acceptable aging), and supplier balance discrepancies (Oracle supplier balance not matching supplier statements). Each diagnostic category followed a structured investigation protocol — query the data, identify the pattern, trace to root cause, document the resolution.
AR reconciliation addressed customer balance discrepancies, unapplied cash (receipts received but not applied to invoices), and aging report accuracy. Unapplied cash is a common AR issue in Oracle implementations where the cash application process was not fully configured or where automatic receipt application rules were not set up correctly during implementation.
Fixed asset validation confirmed that asset depreciation calculations were correct, that assets were assigned to the correct depreciation books, and that the FA subledger balance reconciled to the GL fixed asset accounts. Any discrepancy between FA subledger and GL indicated either an incorrectly processed asset transaction or an accounting rule misconfiguration.
| Deliverable | Type | Purpose |
|---|---|---|
| Diagnostic Assessment Report | Analysis | Summary of issues identified across AP, AR, GL, and FA with root cause analysis and remediation priority ranking |
| Subledger-to-GL Reconciliation | Reconciliation | AP, AR, and FA subledger balance reconciliation to GL with discrepancy identification and resolution |
| AP Issue Resolution Log | Issue Tracking | Itemized log of AP issues (payment reconciliation, holds, supplier balance discrepancies) with resolution documentation |
| AR Unapplied Cash Analysis | Analysis | Identification of unapplied cash receipts with recommended application or write-off approach |
| FA Depreciation Validation | Validation | Asset-by-asset depreciation calculation review confirming accuracy of Oracle FA calculations against expected amounts |
| Configuration Remediation Guide | Configuration Document | Oracle configuration changes required to prevent recurrence of identified issues |
| Area | Lesson | Apply On Next Engagement |
|---|---|---|
| Unapplied Cash | Unapplied cash requires both configuration fix and process fix — either alone will allow the problem to recur | Deliver both AutoCash configuration update and AR team daily review procedure as paired remediation deliverables |
| Diagnostics Skill | Post-implementation support requires audit trail reading skills distinct from implementation configuration skills | Assess diagnostic capability (XLA/SLA audit trail analysis) when staffing post-implementation support engagements |