Job Title: Oracle Record to Report (R2R) Consultant

Key Responsibilities:
- Designing and maintaining Value Sets, Flexfield structures (KFF/DFF), and Tree Hierarchies.
- Managing the impact of hierarchy changes on reporting cubes (Essbase).
- Configuring Primary/Secondary Ledgers, Reporting Currencies, and Ledger Sets.
- Understanding the technical logic behind "Subledger Accounting" (SLA) to customize how data flows from AP/AR/CM/PPM into the GL.
- Configuring cross validation rules, data access sets, segment value security.
- Designing rules to dynamically derive Chart of Accounts (COA) segments based on source data attributes.
- Defining journal line and description rules.
- Grouping all rules together into a cohesive accounting method assigned to the ledger.
- Identifying and categorizing the different business events coming from the legacy system.
- Defining the header and line-level data elements (sources) that need to be captured from the external system to drive accounting rules and reporting.
- Technical mastery of the bank transmission and secure file transmission (SFTP/PGP) for automated statement retrieval.
- 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.
- Ability to develop automated "sweep" or "zero-balance" technical logic for global liquidity management.
- Knowledge of embedded banking feature in Fusion Cash Management.
- Configuration and maintenance of cash posting rules.
- Experience in Oracle Supplier Portal, IDR or DocIO for vendor onboarding and invoice processing.
- Hands-on development of ISO 20022, NACHA, and SWIFT payment templates using BI Publisher (eText/XSL-FO) to facilitate direct integration with global banks.
- Technical configuration of tax engines, including tax rules, regimes, and automated tax calculation logic for cross-border transactions.
- Technical expertise in configuring Asset Books (Corporate/Tax), Depreciation Methods (STL, DB), and Prorate Conventions.
- Hands-on experience with the FA Mass Additions process, specifically troubleshooting the technical interface between AP/Projects and the FA module.
- 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).
- Experience designing and building Auto-Lockbox transmission formats and "Auto-Match" rule sets for high-accuracy receipt application.
- 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.

Required Qualifications:
- Oracle EBS - Finance
- Oracle SaaS Accounting Hub (AHCS)
- General Ledger (GL) & Financial Architecture Hierarchies & COA: Hands-on experience designing and maintaining Value Sets, Flexfield structures (KFF/DFF), and Tree Hierarchies.
- Ledger Engineering: Expertise in configuring Primary/Secondary Ledgers, Reporting Currencies, and Ledger Sets. Must be able to manage the impact of hierarchy changes on reporting cubes (Essbase). 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.
- 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.