Oracle Apps Technical Consultant
Tadmur Holding WLL
Total years of experience :11 years, 1 Months
Worked on the Implementation of Oracle Consigned and Non Consigned Inventory concept
And done basic configurations and Setups needed for that.
•Good Technical Development Experience in Order Creation API, Delivery Creation API, Pick Release API, Cost Manager API, Item Category Creation API.
•Involved in implementation and development of Oracle Custom pages Using Oracle Application Development Framework (ADF).
•Having Good Development Experience in Open Interface tables like Requisitions, Purchase Order, PO Receipts, and Material Transactions.
•Involved in the Implementation of Complex Inbound and Outbound Interface by Integrating with Service Oriented Architecture (SOA) through Business events creation in Oracle.
•Involved in Supporting Month End Activities from Purchasing and Inventory modules and solved the issues proactively for smooth month end closure.
•Technical Development Experience in Oracle Apps modules like Accounts Receivables (AR), Accounts Payables (AP), Fixed Asset (FA), Teleservices (CRM).
•Good Experience in Oracle Custom Workflow development and Customization of Oracle Standard workflows.
•Had an experience in Customization of oracle standard Purchasing Account Generator and Project Accounting Generator Workflows.
•Hands on experience in Creation of Sales order, Purchase Order, AR Receipt, AP Invoices,
AR Debit Memo using Oracle Standard API.
•Good Development experience in Customer, Supplier and External Bank Creation(Conversions) standard Interface using Oracle Custom WebAdi development
•Implemented Oracle Custom Module for one of the Client Using Oracle Custom Forms development which comprises of the basic functionality like Bill of Materials (BOM),
Inventory Transactions and Revenue Recognition Schedule Generation and integrated with Oracle Receivables.
•Having a Good Development Experience in Customization of Oracle Standard Cost Hook Extension in inventory module.
•Developed a HSBC Bank Payment Format using an E-text outbound template in Oracle Account Payable Module.
•Experience in Developing RDF and Oracle XML Reports.
•Developed a Custom Matrix Report using XML Publisher and Custom form using Template.fmb.
•Hands on Experience in solving technical issues arise in Oracle Custom forms.
•Experience in Developing a Custom xml Publisher Report using Data Template in Account Payable module.
•Hands on experience in Form Personalization and Custom.PLL.
•Had a Development experience in Oracle Web-ADI.
•Experience in Developing Procedures, Packages, Functions and Cursors in PL/SQL.
•Technical Work Experience in Oracle Applications Upgrade Project from 11.5.9 to 11.5.10.2.
•Familiar with AOL objects like Concurrent Programs, Request groups, Value set, Request set, Lookup, Profile, Functions, Menu and responsibility.
•Hands on Experience in XML Publisher Report Bursting.
Modules: OM, PO, INV, QP
•Consigned Inventory Implementation: Implemented Oracle Consigned Inventory functionality for our Business to deal with their suppliers transactions. Done ASL Setups and configured the Custom inventory transactions types. Implemented Sourcing Rule and Sourcing Rule Assignment Configurations.
•BRCD Pickwave Reservation: Business user wants to reserve the order in consigned Inventory, non-Consigned Inventory, Buy Back Inventory based on the custom rules we created. If the Item is not available in respective Operating Unit, it will do the Direct Org transfer from another Operating unit and do the reservation. If the item is not available in Supplier owned inventory of one Operating unit, it triggers the Return to vendor transaction from another OU and create a consigned PO and Receipt in the respective OU. Implemented Custom Workflow to achieve this functionality.
•Inventory Receipt Inbound Interface: Developed an Inbound Inventory Receipt Interface through integration with SOA. It is used to receive the material with consignment and non-consignment by creating a Purchase Order and Receipts. It is used to trigger the Sub inventory and Buy Back transactions.
•Outbound Pick Slips Interface: Created a Business Event to trigger this integration with SOA. It is used to fetch the PICKED order line Records so that our business partner will execute the Pick Release from the inventory
•Inbound Delivery Serial Interface: Developed this Inbound Interface to load the Serial Numbers into the corresponding Picked records using Oracle Standard API. Developed an Error handling mechanism to handle the errors effectively.
•Inbound ROP Open Trigger Interface: This Inbound Interface will provide information to Brocade when the Supplier would supply the quantity with committed dates so that Brocade Users will generate Supply demand and Details Reports.
•Involved in Supporting Month End Activities from Purchasing and Inventory modules and solved the issues proactively for smooth month end closure.
3. Ali Bin Ali (R12.2.4
Modules: AP, AR, INV, FA, India Localization, PO
•Implementation of Oracle Custom Module: Had a development experience in Implementation of Oracle Custom Module using Oracle Custom Forms development according to Business requirements in order to run the business smoothly and efficiently. This Custom module comprises of oracle standard functionality like Bill of Materials (BOM), Inventory Transactions, and Revenue Recognition Schedule Generation.
•Customized the PO Account Generator Workflow in order to pick the Segment3 from the Request for Function Segment.
•HSBC Payment Instruction: Business needs the payment instructions to be generated in specific format, which will be provided to HSBC Bank for AP Payments. For this we developed a payment format using an e-text outbound template which is suitable to HSBC Bank payment format.
•Had a Development experience in Customer and Supplier Interface Conversion Programs using Oracle WebAdi.
5. The New Indian Express (R12):
Project Duration: Sep-14 to Jun-15s
Modules: AP, PO, CRM, INV
• Project Accounting Generator Workflow Customization: Whenever User entered a Project related AP Invoices PA Account Generator Workflow will be called and generate an Invoice charge account based on user requirements.
•Purchasing Account Generator Workflow Customization: Whenever User entered an Project related Purchase order, PO Account Generator Workflow will be called and generate an PO Charge, Variance and Budget accounts based on user requirements.
•Done Form Personalization on standard Receiving Transaction form to dynamically attach the LOV on Starting Serial number Column.
•Due Date Message Notification Workflow Development: Developed an Custom Workflow to Notify the assignee and owner of the task in Customer Support Module when the due date of the task is three days prior to Scheduled End Date
•Transaction Cost Hook Extension: Had an Development experience in Customization of Standard Transaction Cost Hook Extension according to business requirements to pick the actual cost entered by the user which is coming from teleservices module.
•Good Development Experience in Customers Interface, Supplier Open interface, Supplier Site Open Interface and External Bank Interface Conversion Programs.
4. Pearson Education (R12
Modules: Scm, Finance
Oracle ERP Upgrade -Migrating from 11.5.9 to 11.5.10.2:
•Retrofitted Database objects like Packages, Tables, Triggers, Indexes, Views and also Oracle Forms and Oracle Reports in order to meet Customer Requirements.
•Developed PL/SQL script to find the impacted Custom objects due to Standard Impacted objects.
•Retrofitted impacted objects like reports, packages, and functions were the major task.
•Tested the Working of Retrofitted objects in 11.5.10.2 instance.
•Provided TE20 for retrofitted objects with test cases and sample output.
•During upgrade, Customized the Oracle standard General Ledger form(GLXJEENT) to meet the Customer requirements which was done in 11.5.9 instance through Custom.pll
Modules: AP, AR, INV, FA, India Localization, GL, INV, OM, PO
•EPML Release Sales Order Daily Program: Implemented this Custom PL/SQL stored Procedure Program to create a Sales order automatically using Create Sales Order standard API from Sales Agreement form.
•EPML Purchase Order Auto Creation: Implemented this Custom PL/SQL Stored Procedure program to store the data from the Requisition form into PO Header and Lines Interface table, and then call the PO Creation API to create a Purchase Order automatically.
•EPML AR Receipt Creation Program: Developed this Concurrent Program to trigger automatically from the Oracle Custom Scheme form to create a AR Receipt using standard create Receipt API Pub.
•EPML AP Invoice Creation for Service PO: Developed this PL/SQL Stored Procedure Concurrent Program to load the data into AP Invoice Header and Lines Interface table and then call the standard “Payable Open Interface Report Program” to create an AP invoice automatically for Service Purchase Order.
•EPML TDS Credit Memo Creation and Apply Program: Implemented this custom Concurrent Program and schedule automatically to create AR Credit Memo and apply to the invoice created using Oracle Standard API.
•EPML TDS Debit Memo Creation Program: Developed this PL/SQL Stored Procedure Concurrent program to create Debit Memo for the created Credit memo using Oracle Standard API and trigger automatically whenever user creates TDS Certificate in TDS Receivable Custom form.
•EPML Sales Executive Target VS Revenue Performance Report: Developed this Custom XML Publisher Matrix with group above Report to find out the sales executive Performance quarterly.
•EPML Fixed Asset Balances Group wise details Report: Implemented this Custom XML Publisher Report to know the Fixed Asset Balances based on Major Category and Minor Category group of Asset Quarterly.
•EPML Mailing List Custom Form: Developed this Custom tabular form using Template.fmb. This form helps the user to enter the TO, CC, BCC Mail-ids corresponding to the Report Column
Modules: Scm, Finance
•Done Form Personalization to restrict the user not able to delete the Temp Receipt and Book Number when the Temp Receipt Date is not null in the Header level of DFF in AR Receipt form.
•Done Code Change in Custom.pll of Sales Order form for restricting the cursor to stay on the current record in Sales Order line level.
•Implemented Sales Order WEBADI Using Oracle Packages: Business Users want to View the bulk record of sales order header and line level data for Update. Designed WEBADI to view the data in Excel sheet for update. Developed Packages for extracting data and uploading data to base tables using API.WEBADI setup has been done to enter the data through spread sheet
Modules: OM, PO, INV, QP, WIP, BOM, AP, AR, GL, FA, CM
•Acquire to Retire Cycle (A2R): Understood the Business Requirement document (BR100), analyzed the gap and provided fitment to integrate Lease Sales orders to Fixed Assets (FA).Involved in Technofuncional implementation of fetching closed Sales orders to Fixed Assets open interface tables and then running the "Mass Additions Program" to create Fixed Assets.
•I-VIEW to Oracle Inbound Interface: Understood the functional Specification and Developed an Oracle Inbound Interface from I-view (Third Party Systems) to Oracle for automating the Sales Order, Validation of sales Order, Check for PO Creation, PO Receipt Creation and also to Create RMA Orders for Return Items coming from I-VIEW Systems.
•Designed a pseudo code for “HRMS Assignment Costing Update” Extension and wrote a MD070 technical document. Prepared TE020 test cases document for this development and provided to the Business Analyst for testing.
•Oracle to WM Outbound Interface: Understood the current business scenario, designed and Integrated Oracle and Warehouse Manhattan (Warehouse Management) system, to fulfill the sales order transactions.
-