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.