Oracle Fusion SCM Functional Consultant

Position: Oracle Fusion SCM Functional Consultant

Location: Austin, TX

Duration: Full-Time

Oracle Fusion Production Support Service Engineer - Cost Management, Inventory, and Payables/Receivable

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+ experience of 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 table s 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

Thanks,

Nitesh