About the role
- Must have and good to have skills
Mandatory Skills
- General Ledger (GL) & Financial Architecture
- Hierarchies & COA: Hands-on experience designing and maintaining Value Sets, Flexfield structures (KFF/DFF), and Tree Hierarchies. Must be able to manage the impact of hierarchy changes on reporting cubes (Essbase).
- Ledger Engineering: Expertise in configuring Primary/Secondary Ledgers, Reporting Currencies, and Ledger Sets. Must understand the technical logic behind "Subledger Accounting" (SLA) to customize how data flows from AP/AR/CM/PPM into the GL.
- Expertise in configuring cross validation rules, data access sets, segment value security.
- Financial Accounting Hub (FAH)
- Account Rules & Mapping Sets: Designing rules to dynamically derive Chart of Accounts (COA) segments based on source data attributes, Defining journal line and description rules.
- Subledger Accounting Methods (SLAM): Grouping all rules together into a cohesive accounting method assigned to the ledger.
- Transaction Types: Identifying and categorizing the different business events coming from the legacy system.
- Source Data Definition: Defining the header and line-level data elements (sources) that need to be captured from the external system to drive accounting rules and reporting.
- Cash Management & Banking
- Bank Integration (Host-to-Host): Technical mastery of the bank transmission and secure file transmission (SFTP/PGP) for automated statement retrieval.
- Reconciliation Engines: Expert knowledge of Manual and Automated Reconciliation Rule Sets, including the use of "Tolerance Rules" and "Mapping Sets" to handle high-volume bank statement lines.
- External Transactions: Ability to develop automated "sweep" or "zero-balance" technical logic for global liquidity management.
- Embedded banking: Knowledge of embedded banking feature in Fusion Cash Management.
- Configuration and maintenance of cash posting rules.
Other Skills
- Payables (AP) & Payments
- PTP: Experience in Oracle Supplier Portal, IDR or DocIO for vendor onboarding and invoice processing
- Payment File Formatting: Hands-on development of ISO 20022, NACHA, and SWIFT payment templates using BI Publisher (eText/XSL-FO) to facilitate direct integration with global banks.
- Tax & Withholding: Technical configuration of tax engines, including tax rules, regimes, and automated tax calculation logic for cross-border transactions.
Fixed Assets (FA)
- Asset Lifecycle Automation: Technical expertise in configuring Asset Books (Corporate/Tax), Depreciation Methods (STL, DB), and Prorate Conventions.
- Mass Additions Logic: Hands-on experience with the FA Mass Additions process, specifically troubleshooting the technical interface between AP/Projects and the FA module.
Accounts Receivable (AR) & Collections
- Auto-Invoice Architecture: Mastery of the Auto-Invoice Master Program; must be able to debug interface table errors and design custom validation logic for high-volume billing imports from external CRMs (e.g., Salesforce).
- Lockbox & Receipt Processing: Experience designing and building Auto-Lockbox transmission formats and "Auto-Match" rule sets for high-accuracy receipt application.
Soft Skills
- Excellent communication and stakeholder management skills
- Ability to work independently in an onsite client facing environment
- Strong documentation and presentation skills
- Proven leadership and mentoring capabilities
Mandatory Skills
Oracle EBS - Finance, Oracle SaaS Accounting Hub (AHCS)