Oracle Record Report R R Consultant

Job 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.
• 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)

Required Skills :

Basic Qualification :

Additional Skills :

Background Check : No

Drug Screen : No