Oracle ERP Functional Consultant

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.