Wipro - Oracle Financial Consultant

Oracle Financial Consultant - SCM

:

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