Oracle Fusion Production Support Service Engineer

• Support various costing methods including Standard Costing, Average Costing, FIFO,
  

• Maintain subledger accounting (SLA) integrations with financial systems
• Provide expertise for Inventory Valuation and troubleshoot how transactions impact cost
  

• 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
  

• 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
  

• 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,
  

• Maintain and troubleshoot integration points between Oracle Inventory, Purchasing,
  

• Support Payables/Receivables Intercompany transactions and reconciliation processes
• Ensure seamless data flow between integrated modules
  

• Participate in Change Management activities including maintaining SOPs, process
  

• Support Quarterly Cloud Updates Readiness assessments, perform regression testing,
  

• Ensure financial data accuracy, SOX compliance, and internal control adherence
  

Required Qualifications

• 5+ experience of Oracle Fusion Cost Management, Inventory, and integrations with
  

• 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