Senior Oracle Financials EBS R12 Support Engineer

Job Title: Senior Oracle Financials EBS R12 Support Engineer

Job Location: Montreal, QC

Job Type: Contract

Pay Range: $60.00hr - $65.00hr

Job Overview:

We are seeking an experienced Senior Oracle Financials EBS R12 Support Engineer to maintain, optimize, and support the organization s Oracle Financials EBS R12 environment. In this role, the candidate will manage Oracle EBS Modules PO, AP, FA, GL and custom modules, subledger accounting rules, GL posting workflows, and production systems to ensure seamless financial operations, accurate accounting movements, and complete audit trails. The successful candidate is expected to have experience in i-Expense, i-Procurement, workflow development, and EOY and Month-end processes. The successful candidate possesses strong expertise in Oracle Financials EBS R12, advanced Linux shell scripting, BI Publisher, and Oracle PL/SQL. Because this platform serves as the central hub for institutional financial accounting and reporting, a solid foundational understanding of financial data flows, subledger accounting architecture, and accounting movements is essential, with specialized knowledge of core accounting structures like General Ledgers, Subledger Accounting (SLA), Charts of Accounts, and multi-ledger environments being highly advantageous.

Oracle Financials EBS R12 Expertise (Mandatory):

• General Ledger (GL) Advanced proficiency in GL posting, journal entry creation, account reconciliation, and GL inquiry tools.
• Accounts Payable (AP) Strong understanding of invoice processing, payment workflows, and AP subledger accounting.
• Fixed Assets (FA) Knowledge of asset acquisition, depreciation, and FA subledger accounting.
• Subledger Accounting Expert-level understanding of subledger journal entry creation, accounting definitions, accounting methods, and posting engines.
• Multi-ledger and multi-organization architecture (MOAC) configuration and management.
• Chart of Accounts (COA) design, flexfield structures, and account derivation rules.
• Ledger setup, accounting calendars, and currency management.
• Subledger to GL posting workflows and reconciliation processes.
• Balance sheet and non-balancing account entry handling.
• Accounting Flexfield (CCID) derivation and validation.
• Custom GL posting rules and accounting logic implementation.
• Subledger Accounting rule configuration using Accounting Methods Builder (AMB).
• Application Accounting Definitions (AAD) and journal line type customization.
• Transaction object definitions and source value mapping.
• Integration with Oracle Financials Accounting Hub.

Scripting Capabilities (Mandatory):

• Expert-level Linux shell scripting for automated data pipeline management and file handling.
• Concurrent program scheduling and batch operations.
• GL posting automation and subledger journal entry creation.
• Error handling, logging, and monitoring frameworks.
• Data validation and reconciliation scripts.

Database Skills (Mandatory):

• Advanced Oracle PL/SQL proficiency, including complex queries, packages, stored procedures, and triggers.
• Subledger Accounting table structures (GL tables, AP/FA subledger tables).
• Journal entry creation and GL posting logic.
• Debugging and performance optimization within the EBS environment.
• Custom function and procedure development for GL and subledger operations.
• Data migration and reconciliation scripts.
• Foundational to intermediate Pro*C skills for troubleshooting and updating embedded SQL C-programs.
• Supporting legacy batch code and concurrent programs.
• Custom utility development for GL and subledger processing.

Financial Data Flows & Accounting Movements (Mandatory):

• Strong understanding of financial data files (flat files, XML, CSV, EDI) containing high-volume accounting movements (debits and credits).
• Inter-company transactions and eliminations.
• Multi-currency transactions and revaluation.
• Subledger transaction flows to GL posting.

Core Accounting Concepts (Preferred Plus):

• Solid functional understanding of General Ledger (GL) systems, trial balances, and period close processes.
• Subledger Accounting (SLA) architecture, accounting events, and journal entry generation.
• Balance Sheet accounts, non-balancing account entries, and reconciliation.
• Chart of Accounts (COA) framework, segment values, and account hierarchies.
• Multi-ledger environments with primary and secondary ledgers.
• Accounting methods and accounting conventions for different legal entities.
• Month-end and year-end close procedures, accruals, and reconciliation.
• Practical experience with development skills required for BI Publisher.
• GL posting workflows and subledger journal entry creation.
• Subledger reconciliation and GL account balancing.
• Integration between Oracle EBS modules and GL.
• Accounting Hub and Financials Accounting Hub configurations.
• Drill-down capabilities from GL to subledger transactions.

Oracle EBS Technical Architecture (Mandatory):

• Online Patching (EBR) Understanding of Edition-Based Redefinition and online patching procedures.
• Customization Standards Compliance with Release 12.2 development standards for PL/SQL, Forms, Reports, and Java.
• Database Objects Knowledge of EBS database object development standards and schema migration.
• Concurrent Programs Design, development, and troubleshooting of concurrent programs.
• Oracle Forms & Reports Experience with custom Forms and Reports development or modification.
• Web ADI (Web-based Application Desktop Integrator) Configuration and troubleshooting for GL and subledger data loads.

SDLC & Process Tools (Mandatory):

• Standard Software Development Life Cycle (SDLC) methodologies.
• Change control procedures and Oracle EBS change management.
• Oracle EBS patching, upgrades, and online patching enablement.
• Jira and version control systems (Git, SVN).
• Testing protocols (unit, integration, UAT).
• Documentation standards and best practices.

Responsibilities:

• Application Support & Customization Management: Provide specialized support for Oracle Financials EBS R12. Maintain, update, and validate custom PL/SQL modules, Forms, Reports, and Concurrent Programs. Manage custom GL posting rules, subledger accounting definitions, and accounting logic.
• Subledger Accounting & GL Operations: Configure and maintain subledger accounting rules, accounting methods, and journal entry definitions. Troubleshoot subledger to GL posting workflows, reconciliation issues, and non-balancing account entries. Ensure accurate GL posting and complete audit trails.
• Financial Data Validation & Troubleshooting: Investigate, diagnose, and resolve technical issues related to inbound and outbound financial files containing accounting movements. Identify and isolate anomalies in GL balancing, subledger reconciliation, and account reconciliation. Validate data integrity across multi-ledger environments.
• Pipeline Automation: Design, optimize, and maintain robust Linux shell scripts to manage background file processing, concurrent program scheduling, GL posting automation, subledger journal entry creation, and error handling within the EBS environment.
• Database & Pro*C Maintenance: Optimize and debug backend processing components using Oracle PL/SQL. Manage database objects (tables, indexes, sequences, views). Maintain legacy batch code written in Pro*C. Perform query optimization and concurrent program tuning.
• Analysis & Enhancements: Perform impact analysis for GL mapping updates, subledger accounting rule changes, module customizations, or platform migrations. Map transaction flows accurately to standard GL lines and COA guidelines. Provide clear effort estimates for development, unit testing, and UAT cycles.
• Testing & Release Coordination: Execute unit and integration testing protocols for custom modules, subledger accounting rules, and interface configurations. Create, submit, and track change requests (CR) following corporate SDLC compliance guidelines and EBS change management procedures.
• Performance Tuning & Optimization: Monitor and optimize Oracle EBS Financials performance, including GL posting performance, concurrent program tuning, subledger journal entry creation efficiency, and database maintenance activities.
• Multi-Ledger & Multi-Organization Support: Manage multi-ledger configurations, MOAC setups, and inter-company accounting. Support consolidation processes and reporting across multiple legal entities and ledgers.
• Process & Compliance: Maintain real-time task tracking in Jira. Provide daily progress updates to management. Adhere strictly to institutional data policies, SOX compliance requirements, and security compliance standards. Maintain audit trails and documentation for all GL and subledger transactions.

Preferred Qualifications:

• 5+ years of direct experience with Oracle EBS R12 (or R12.2.x versions).
• Experience with Oracle EBS Financials implementations or major upgrades.
• Knowledge of Oracle Application Framework (OAF) or Oracle ADF.
• Familiarity with Oracle Workflow or business process automation.
• Understanding of financial reporting standards and consolidation processes.
• Experience with Oracle Web ADI and data integration tools.
• Knowledge of Oracle Approval Management Engine (AME).
• Exposure to Oracle Cloud Infrastructure (OCI) or Oracle EBS on Cloud deployments.

Technical Environment:

• Oracle EBS R12.
• Oracle Database 19c or 12c Release 1.
• Linux Operating System (64-bit).
• Oracle Forms & Reports.
• Oracle Concurrent Programs.
• Jira and Version Control Systems.

====

• Medical, Dental, and Vision Insurance
• 401(k) Retirement Plan
• Health Savings Account (HSA)
• Disability Insurance (Short-Term and Long-Term)
• Life and AD&D Insurance
• Paid Sick Leave (where required by applicable state or local law)
• Supplemental Insurance Plans
• Identity Theft Protection
• Pet Insurance
• Employee Wellness Programs
• Employee Assistance Program (EAP)
• Career Growth and Professional Development Opportunities