Oracle ERP Functional/Technical Analyst

Concerotech; St. Louis, Northern (MO, KY); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Concerotech is seeking an Oracle ERP Functional/Technical Analyst to support Oracle E-Business Suite R12 across Finance, Manufacturing, SCM, Purchasing, Inventory, and Supply Chain operations in a multi-site environment.

The role blends functional and technical work, requiring SQL/data analysis, process understanding, and hands-on support to resolve issues, test fixes, and document changes for reliable daily operations and continuous improvement.

Qualifications

• Experience with Oracle E-Business Suite R12 in manufacturing, supply chain, warehouse, or finance.
• Strong functional and technical knowledge of Oracle modules for manufacturing, finance, purchasing, inventory, WIP, BOM, order management, shipping, quality, warehouse/MSCA, and system administration.
• SQL capability with Oracle tables, forms, stored procedures, reports, and data troubleshooting techniques.
• Ability to troubleshoot Oracle workflows, interfaces, concurrent requests, reports, forms, customizations, transaction issues, and user-reported problems.
• Ability to work with plant users, finance teams, business SMEs, IT resources, vendors, and technical support partners in a clear, calm, and service-oriented way.
• Cross-functional business process knowledge across Finance, Manufacturing, Supply Chain, Purchasing, Customer Service, and plant operations.

Responsibilities

• Support Oracle EBS R12 environments across Finance, Manufacturing, Supply Chain, Purchasing, Inventory, and Plant Operations.
• Troubleshoot workflows, interfaces, concurrent requests, custom forms, reports, and data issues.
• Collaborate with Oracle technical resources, business users, plant teams, and IT peers to resolve issues, test fixes, document changes, and support production operations.
• Support manufacturing, inventory, and supply chain processes including BOM, WIP, and shop-floor reporting.
• Assist in cost and financial processes, including accounting transfers, period close, and reconciliations.
• Document report logic, troubleshooting steps, and maintain knowledge continuity.

Skills

Oracle EBS R12

SQL & data analysis

Troubleshooting

Cross-functional knowledge

User support

Manufacturing domain

Education

Bachelor’s degree in IT/CS or related

Tools

PL/SQL

APEX reports

BI reports

Oracle Forms

Job description

This role is critical to supporting Oracle E-Business Suite environment across daily manufacturing, supply chain, warehouse, customer service, and finance operations. The position helps keep plant operations, inventory transactions, production reporting, financial processing, and business controls working reliably while also supporting enhancements, troubleshooting, knowledge transfer, and continuous improvement.

Role Summary

The Oracle ERP Functional/Technical Analyst supports, maintains, troubleshoots, and improves Oracle E-Business Suite R12 across Finance, Manufacturing, Supply Chain, Purchasing, Inventory, Customer Service, Warehouse, and plant operations. This position requires a practical blend of Oracle functional knowledge, technical troubleshooting, SQL/data analysis, business process understanding, and direct user support. This is not a pure developer role and not a pure functional analyst role. The successful candidate will operate between business users and technical resources to resolve application issues, maintain process controls, support daily operations, and improve the reliability and usefulness of Oracle EBS in a multi-site manufacturing environment.

What You Will Do

Oracle ERP Functional and Technical Support

• Support Oracle E-Business Suite R12, including Oracle Applications 12.1.3 and Oracle Database 12.1.0.2 environments.
• Support core Oracle modules across the full business cycle, including General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Inventory, Cost Management, Work in Process, Bills of Material, Order Management, Shipping Execution, Quality, Warehouse Manager/MSCA, and System Administration.
• Troubleshoot Oracle workflows, interfaces, concurrent requests, custom forms, custom reports, Forms personalizations, custom procedures, and related application issues.
• Analyze application behavior, transaction issues, data issues, setup/configuration questions, and user-reported problems to identify root cause and practical resolution paths.
• Partner with Oracle technical resources, contractors, vendors, business users, plant teams, and IT peers to resolve issues, test fixes, document changes, and support production operations.

Manufacturing, Inventory, and Supply Chain Operations

• Support Oracle manufacturing and supply chain processes, including discrete jobs, routings, bills of material, backflushing, FIFO material issue, lot control, MSCA scan-gun functionality, and shop-floor production reporting.
• Support Inventory, Purchasing, Work in Process, Bills of Material, Order Management, Shipping Execution, Quality, Warehouse Manager/MSCA, and related plant / warehouse processes.
• Assist plant and operations users with manufacturing transaction issues, inventory movements, warehouse activities, production reporting, shipping execution, and process questions.
• Help maintain operational continuity by troubleshooting transaction failures, workflow exceptions, reporting issues, and process gaps that affect plant, warehouse, customer service, or supply chain execution.

Costing and Financial Process Support

• Support Oracle costing concepts and processes, including Average Costing, actual transaction costing, cost elements, labor and overhead rates, Cost Manager processing, and variance analysis.
• Support multi-ledger and multi-region Oracle financial environments, including daily accounting, subledger transfer, posting to GL, period close, and reconciliation processes.
• Support procure-to-pay processes, including purchase orders, approval workflows, 3-way matching, invoice holds, supplier setup controls, AP invoice processing, and payment processing.
• Support order-to-cash processes, including sales order entry, order scheduling, ship confirmation, repricing at fulfillment, inventory interface, cost of sales generation, AutoInvoice, AR accounting, and GL transfer.
• Work with Finance teams to understand downstream impacts of Oracle transactions, configuration, data issues, costing activity, and close-related support needs.

Reporting, Data, and Oracle Extensions

• Use SQL, Oracle tables, forms, stored procedures, and related data analysis methods to investigate issues and support reporting or troubleshooting needs.
• Support custom Oracle extensions, including Product Line Accounting reallocations, custom document formats, production-entry forms, custom labels, and reporting used for labor, machine-hour, and cost variance analysis.
• Support and troubleshoot custom reports, APEX reports, BI reports, APIs, interfaces, forms, and data extracts used by Finance, Manufacturing, Supply Chain, Customer Service, and plant operations.
• Document report logic, troubleshooting steps, customizations, process assumptions, and business approvals to strengthen support coverage and knowledge continuity.

Projects, Enhancements, and Continuous Improvement

• Participate in Oracle patches, upgrades, integrations, enhancements, testing, user acceptance testing, issue remediation, and process-improvement initiatives.
• Translate business requests into clear functional and technical requirements that can be evaluated, prioritized, tested, and supported.
• Support process controls by understanding the relationship between configuration, customizations, user access, data quality, and downstream operational or financial impact.
• Create and maintain work instructions, configuration notes, support procedures, testing evidence, issue-resolution documentation, and transition materials.

What We Are Looking For

Required Day-One Skills

• Practical Oracle E-Business Suite R12 support experience in a manufacturing, supply chain, warehouse, or finance-enabled operating environment.
• Strong functional and technical knowledge of Oracle modules that support manufacturing, finance, purchasing, inventory, WIP, BOM, order management, shipping, quality, warehouse/MSCA, and system administration processes.
• Hands-on SQL capability with working knowledge of Oracle tables, forms, stored procedures, custom reports, and data troubleshooting techniques.
• Ability to troubleshoot Oracle workflows, interfaces, concurrent requests, reports, forms, customizations, transaction issues, and user-reported problems.
• Ability to work directly with plant users, finance teams, business SMEs, IT resources, vendors, and technical support partners in a clear, calm, and service-oriented way.
• Strong cross-functional business process knowledge across Finance, Manufacturing, Supply Chain, Purchasing, Customer Service, and plant operations.

Preferred Experience

• Experience with Oracle Applications 12.1.3 and Oracle Database 12.1.0.2 environments.
• Experience with PL/SQL, APIs, stored procedures, Oracle Workflow, custom forms, custom procedures, and deeper Oracle technical troubleshooting.
• Experience with APEX reporting, Oracle BI reporting, custom reports, labels, data extracts, and custom document formats.
• Experience supporting Oracle financial processes such as GL, AP, AR, subledger transfer, period close, reconciliations, and accounting-related transaction flows.
• Experience supporting ERP patches, upgrades, integrations, testing, user acceptance testing, process standardization, and enhancement delivery.
• Bachelor’s degree in Information Technology, Computer Science, Business, Accounting, Supply Chain, or a related field, or equivalent practical experience.