Oracle Record to Report (R2R) Consultant

Oracle Record To Report (R2R) Consultant Client Location – New York, NY - 3 Days Onsite Long Term Contract RoleJob Description - 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. Other Skills: 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. 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.