Oracle Fusion Production Support Service Engineer

Key Responsibilities

Cost Management Support

• Handle standard, average, FIFO, and LIFO costing models
• Support subledger accounting (SLA) integration with Financials
• Monitor and troubleshoot inventory valuation and WIP/BOM costing
• Debug PL/SQL packages used in cost calculations
• Analyze cost variances, period close issues, and reconcile financial data

Technical Troubleshooting

• Resolve cost discrepancies using FND diagnostics, trace files, and debug logs
• Identify and fix cost variances and close-related errors
• Write and optimize SQL/PLSQL queries for Oracle tables

Integration & Functional Support

• Maintain integrations between Inventory, Purchasing, Order Management, and GL
• Handle intercompany transactions through Oracle Payables/Receivables
• Support seamless cross-module data flows and functional stability

Operational Excellence

• Participate in quarterly patch testing, regression cycles, and documentation
• Ensure financial data accuracy, compliance, and audit-readiness (SOX)
• Maintain SOPs, impact assessments, and provide knowledge base articles

Required Skills & Experience

• 5+ years experience in Oracle Fusion Cost Management & Inventory modules
• Strong working knowledge of SLA, WIP, BOM, and costing methodologies
• Hands-on experience with SQL, PL/SQL, and Oracle diagnostics tools
• Familiarity with Oracle Costing Tables (e.g., CST_COST_HISTORY, CST_COST_TYPE)
• Proven experience in period close processes, reconciliation, and financial controls
• Experience supporting Oracle Payables/Receivables integration is a plus
• Strong communication and problem-solving abilities