Job Title: Oracle ERP Functional Consultant
Location: Chicago, IL
Fulltime only
Job Description
Must Have Technical/Functional Skills
Technical Skills (Techno Functional)
Oracle EBS 12.2 Technical
- SQL, PL/SQL
- Oracle Forms & Reports
- OAF (Oracle Application Framework)
- Workflow Builder & AME
- XML Publisher / BI Publisher
- Personalization’s & Extensions
- RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows)
- API usage for financial modules
- Unix shell scripting
Mandatory Functional skills
Core Functional Expertise (Finance)
Oracle EBS 12.2 Financial Modules
Accounts Payable (AP)
Accounts Receivable (AR)
General Ledger (GL)
Cash Management (CE)
Fixed Assets (FA)
Subledger Accounting (SLA)
E Tax configuration and troubleshooting
Period close activities and reconciliation across modules
Desirable Functional Skills
Oracle Fusion Cloud Financials
- Fusion GL, AP, AR, FA, CM
- Fusion Tax
- OTBI, BI Publisher, Smart View
Additional Competencies
- Strong understanding of accounting principles (GAAP/IFRS)
- Requirement gathering & solution design
- Fit gap analysis
- UAT support & training
- Production support & issue resolution
- Knowledge of SOX controls & audit compliance
- Agile/Scrum methodology exposure
Desirable Skills-
Oracle Fusion Technical
- OTBI & BI Publisher report development
- FBDI templates & ADFDI
- REST & SOAP Web Services
- Integration Cloud (OIC) – mappings, orchestrations, adapters
- BIP bursting, scheduling, and data models
Reporting & Analytics
- BI Publisher
- OTBI
- FRS (Financial Reporting Studio)
- Smart View
Roles & Responsibilities
The Oracle Techno Functional Financial Consultant will support, enhance, and optimize Oracle E Business Suite (EBS) 12.2 and Oracle Fusion Cloud Financials. This role requires a strong blend of functional finance expertise and hands on technical development skills. The consultant will work closely with business users, finance teams, and IT to deliver solutions across AP, AR, GL, FA, Cash Management, and related financial modules.
Functional Responsibilities
- Lead requirement gathering, fit gap analysis, and solution design for Oracle EBS 12.2 and Fusion Financials.
- Configure and support financial modules including AP, AR, GL, FA, CE, and SLA.
- Support month end and year end close activities, reconciliations, and financial reporting.
- Provide functional expertise for Fusion modules such as GL, AP, AR, FA, CM, and Fusion Tax.
- Develop and maintain financial reports using OTBI, BI Publisher, FRS, and Smart View.
- Collaborate with finance stakeholders to streamline processes and improve system usage.
Technical Responsibilities
- Develop and support RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
- Build and maintain PL/SQL packages, Oracle Forms/Reports, OAF pages, and XML/BI Publisher reports.
- Support EBS 12.2 online patching (ADOP) and custom code remediation.
- Develop Fusion integrations using REST/SOAP APIs, OIC, FBDI, ADFDI, and BIP bursting.
- Troubleshoot technical issues across EBS and Fusion environments.
- Support data migration activities and third party integrations (banking, procurement, etc.).