Wipro - Oracle Financial Consultant

Oracle Financial Consultant - SCM

Job Description:

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