Oracle Fusion Production Support Service Engineer

Position Overview:

We are seeking an experienced Service Engineer to provide comprehensive production support for Oracle Fusion Cost Management, Oracle Fusion Inventory, and integrations with Oracle Payables/Receivables (Intercompany) modules. The ideal candidate will possess both functional understanding of costing methodologies and technical troubleshooting capabilities to ensure operational excellence.

Key Responsibilities:

Cost Management Support:

• Support various costing methods including Standard Costing, Average Costing, FIFO, LIFO, and other methodologies.
• Maintain subledger accounting (SLA) integrations with financial systems.
• Provide expertise for Inventory Valuation and troubleshoot how transactions impact cost layers.
• Support Work in Process (WIP) and Bills of Material (BOM) costing operations.
• Analyze and troubleshoot cost variances during daily operations.
• Develop and optimize SQL & PL/SQL queries to extract cost-related data from Oracle tables.
• Debug PL/SQL procedures, packages, and functions used in cost calculations.
• Receive, analyze, and prioritize related support tickets.
• Provide timely solutions to users.
• Document resolution steps and knowledge base articles.
• Support system upgrades and patches.
• Monitor system performances and recommend improvements.

Technical Troubleshooting:

• Analyze cost distributions and transaction accounting issues.
• Debug and resolve costing discrepancies and period close errors.
• Utilize FND Diagnostics, trace files, and debug logs to investigate costing issues.
• Support the period close process in Oracle Cost Management.
• Reconcile Inventory Valuation Reports with General Ledger.
• Identify and resolve cost variances during month-end close.
• Apply deep knowledge of costing tables (e.g., CST_COST_HISTORY, CST_COST_TYPE, MTL_TRANSACTION_ACCOUNTS).

Integration Support:

• Maintain and troubleshoot integration points between Oracle Inventory, Purchasing, Order Management, and General Ledger (GL).
• Support Payables/Receivables Intercompany transactions and reconciliation processes.
• Ensure seamless data flow between integrated modules.

Operational Governance:

• Participate in Change Management activities including maintaining SOPs, process documentation, and impact assessments for updates.
• Support Quarterly Cloud Updates readiness assessments, perform regression testing, and ensure business continuity.
• Ensure financial data accuracy, SOX compliance, and internal control adherence.

Required Qualifications:

• 5+ years experience with Oracle Fusion Cost Management, Inventory, and integrations with Payables/Receivables and Supply Chain Orchestration modules.
• Knowledge of costing methods (Standard Costing, Average Costing, FIFO, LIFO).
• Experience with subledger accounting (SLA) and its integration with financials.
• Proficiency in Inventory Valuation and understanding of cost layers.
• Familiarity with Work in Process (WIP) and Bills of Material (BOM) costing.
• Experience with Oracle SQL & PL/SQL, including writing and optimizing queries.
• Understanding of Oracle costing tables structure and relationships.
• Proven ability to debug PL/SQL procedures and troubleshoot complex costing issues.
• Experience with period close processes and reconciliation activities.
• Knowledge of SOX compliance requirements related to financial systems.

This position requires a blend of functional expertise in Oracle Cost Management methodologies and technical proficiency to support critical business operations and ensure financial accuracy.