NNG — Oracle EBS Supplier Management, Legal Entity Configuration & Ongoing Functional Support

Client	NNG Group
Industry	Technology — Navigation Software & Location Services
Oracle Version	Oracle E-Business Suite R12
Modules	PO AP GL
Engagement Period	2019 – 2021
Project Type	Oracle EBS Functional Support & Configuration — Ongoing Retainer
Complexity	Low-Medium · Ongoing Support · ISO 27001 Context · Supplier Management Focus

Executive Summary

NNG — a Budapest-based navigation software company known for the iGo navigation platform deployed across automotive and mobile OEM markets worldwide — engaged William Delaney Consulting for ongoing Oracle EBS functional support spanning supplier management process design, legal entity configuration, and ISO 27001 information security compliance support. The engagement operated as a retainer model with bi-weekly support cycles, covering a range of Oracle functional and configuration topics as they arose in NNG's Oracle environment.

The engagement artifacts reflect a mature Oracle environment requiring targeted functional expertise rather than a ground-up implementation: supplier deactivation process design, legal entity upgrade troubleshooting scripts, key account configuration management, and information security policy communications aligned to NNG's ISO 27001 certification requirements. The Supplier Deactivate Process (documented in Visio and PDF) represents the most substantial process deliverable — a controlled procedure for retiring inactive supplier records without corrupting AP transaction history.

Engagement Context

Navigation software companies have a distinctive Oracle supplier base: map data providers (HERE, TomTom, OpenStreetMap licensors), automotive OEM integration partners, hardware certification vendors, and global distribution channel partners. The supplier master in this environment accumulates inactive records over time as technology partnerships shift — map data sources change, OEM relationships consolidate, and legacy distribution partners are replaced. A controlled supplier deactivation process is not a trivial maintenance task; it requires careful attention to open transactions, purchase order history, and the distinction between inactivation (no new transactions) and end-dating (historical reference preserved).

ISO 27001 certification — the international standard for information security management systems — imposes requirements on Oracle EBS access controls, audit logging, and data handling procedures. For a technology company like NNG with IP-sensitive navigation software and OEM partner data, information security governance extends to Oracle EBS configuration. The ISO 27001 communications in the engagement artifacts reflect active coordination between NNG's information security team and the Oracle functional configuration.

Legal entity configuration in Oracle EBS — particularly Legal Entity Upgrade Troubleshooting — is one of the more technically sensitive areas of Oracle functional administration. Legal entities anchor the Multi-Org hierarchy and are referenced throughout Oracle's financial and tax configuration. Troubleshooting legal entity issues typically involves Oracle's Legal Entity Configurator, the Intercompany framework, and E-Business Tax configuration — areas where configuration errors surface as difficult-to-diagnose transaction failures.

Functional Support Scope

Supplier Deactivation Process Design

The supplier deactivation process documented in this engagement defines the controlled procedure for inactivating Oracle supplier records that are no longer in active use. The process addresses: identification of inactive suppliers (no PO activity for a defined period), verification of open AP invoices and outstanding balances, hold placement on the supplier to prevent new transactions, formal approval by the procurement manager, and the Oracle-level inactivation steps — supplier site end-dating, responsibility restriction, and status update. The Visio diagram makes the approval workflow explicit and provides an audit-ready process reference for NNG's ISO 27001 compliance.

Legal Entity Configuration Support

Legal Entity Upgrade Troubleshooting scripts addressed configuration gaps that surfaced during or after an Oracle R12 upgrade — a common pattern in R12 environments where the Legal Entity Configurator in R12 differs architecturally from the Multi-Org setup in 11i. The SQL scripts (LegalEntryScript1.sql, LegalEntryScript2.sql) provided diagnostic and remediation capability for legal entity relationship data that did not survive the upgrade intact.

Key Account Management

The Key Accounts configuration workbook provided a structured reference for NNG's strategic supplier accounts — payment terms, approved payment methods, designated approval authorities, and any special handling requirements. Key account documentation is a best practice in AP environments with large supplier bases, enabling consistent handling of high-value or high-risk supplier relationships across the AP team.

Key Deliverables

Deliverable	Type	Purpose
Supplier Deactivation Process (Visio + PDF)	Process Document	Controlled procedure for retiring inactive Oracle supplier records with approval workflow and compliance documentation
Legal Entity Diagnostic Scripts	SQL Scripts	Diagnostic and remediation SQL for legal entity configuration issues arising from R12 upgrade
Key Accounts Configuration Reference	Configuration Reference	Structured reference for strategic supplier account configurations, payment terms, and handling rules
ISO 27001 Compliance Communication	Compliance Artifact	Oracle EBS configuration documentation supporting NNG's ISO 27001 information security certification

Consultant Insights

On Supplier Deactivation as a Governance Process: In mature Oracle environments, supplier master hygiene is a recurring governance challenge — active supplier counts grow steadily as new vendors are added, while old vendors are rarely formally deactivated. A controlled deactivation process with explicit approval, open transaction verification, and hold-before-inactivate sequencing prevents both data corruption and audit findings. The process should be triggered on a defined schedule (annual supplier review) rather than ad hoc, and should be owned by Procurement, not AP.

On Legal Entity Troubleshooting in R12: Oracle R12's Legal Entity Configurator replaced 11i's Multi-Org setup screen with a more structured legal entity hierarchy framework. Clients upgrading from 11i to R12 frequently encounter legal entity relationship gaps that manifest as transaction failures in AP, AR, or GL — errors that are cryptic because they reference legal entity IDs rather than business names. Diagnostic SQL against LE_LEGAL_ENTITIES and HZ_PARTY_USG_ASSIGNMENTS is the fastest path to root cause identification in these scenarios.

On Oracle EBS in ISO 27001 Environments: ISO 27001 certification scope frequently includes ERP systems as critical information assets. Oracle EBS administrators in ISO 27001 environments should maintain documented evidence of: access control procedures, privileged account management, change management for configuration changes, and audit log review. The supplier deactivation process produced in this engagement is an example of the kind of documented, approved procedure that satisfies ISO 27001 control requirements for operational processes involving sensitive vendor data.