casestudy

Department of Works: R12 Implementation

Client Background

DOW is a government organization that basically handles the Finance and IT process of all provinces of Papua New
Guinea.DOW is already working in Oracle Apps for 21 provinces andhad requirement to rollout 2 new provinces Hela and
Jiwaka.

Client Need

Need to rollout two provinces Hela and Jiwaka for the following activities:
Online processing of supplier invoice, payment and bank reconciliation.
Budget and Encumbrance environment to control the organization expenditure.

Solution

The solution was offered to rollout both province in Oracle Apps.
Use General Ledger, Accounts Payable, Accounts Receivable, Purchase Order and Cash Management module to meet their specific requirement.

Business Impact

Automation of bills and payment generated manually.
Faster process of payment processing
Cost reduction of resources required to process invoicing and payments

Department of Works: R12 Implementation


Highlights of the Solution

Implemented GL, AP, AR, PO, INV and Cash Management
moduleclient7
Enabled Budget and Encumbrance environment
Customized SLA to use Cash Basis Accounting in Payables
Design custom forms CFC(Cash Fund Certificate) and FM
(Funding Minute).
Design custom Interface to transfer CFC and FM data to GL
Interface
Implemented Multi Org and MOAC features
Build FSG(Financial Statement Generator) report
Custom reports to match business requirement
Bank Reconciliation process
Linking of custom FM form functionality with AP to control
Invoice Validation and ApprovalAccounting process for both Cash and Accrual

Indorama : Production Support and Module Implementation

Client Background

Indorama is an Exporter of polystern yarn manufacturer and supplier of spandex fiber.Indorama has set up a green field project to produce Spandex Filament Yarns at Baddi, Himachal Pradesh in India.
Indorama has already created a lot of enthusiasm among the clothing fraternity in the Indian subcontinent.

Client Need

Need to maintain their Cash and Bank Account Transfers.
Need to maintain their Assets online.
Required post implemented support for Finance and SCM.
Required custom reports to meet Tax and Bank reconciliation

Solution

The solution was offered to rollout both province in Oracle Apps.
Use General Ledger, Accounts Payable, Accounts Receivable, Purchase Order and Cash Management module to meet their specific requirement

Business Impact

Online maintenance and depreciation of Assets.
Reconciliation of AP Payment and AR Receipts.
Bank Account Transfers process.

Highlights of the Solution

Post Go live support for GL, AP, AR, FA, CM, PO, INV, OM and India Localization module
Implemented FA and CM moduleclient6
Design custom reports to reconcile the Excise, VAT, Service Tax and Bank Account balances
Daily basis support for P2P and O2C cycle
Implement Multi Org and MOAC features
Build FSG(Financial Statement Generator) report
Implemented Bank Reconciliation and Bank Account Transfer process.

Motherson Sumi Systems Ltd- Oracle EBS R12 Implementation

Client Background

MSSL including its subsidiaries and JVs is one of the leading manufacturer of automotive wiring harnesses, mirrors for passenger cars and a leading supplier of plastic components and modules to the automotive industry.
MSSL business portfolio includes wiring harnesses, mirrors for passenger car, injection moulded products, modules including dashboards, door trims, bumpers, blow moulded components, liquid silicone rubber moulded components, injection moulding tools.

Client Need

MSSL uses legacy software for their current Business processes round the globe. There was requirement for implementing Oracle EBS R12 in its plants across the Globe starting with six plants
Implementation of SCM Modules
Implementation of ASCP cycle.
Customization of Reports, Forms , Interfaces and Workflows
Migration of Data from Legacy system to Oracle EBS.

Solution

Customizations of Business Processes and new Forms developed in Oracle.
The solution was integrated with their current system for other Units.
The solution includes personalization on Standard Forms, new reports, interfaces , workflow modifications.
Reports developed in different tools to achieve business requirement

Business Impact

Automated process and manual intervention exempted
Approval system for the mandatory processes.
Fast and best processes implemented in Organization.
Auto Alerts based on business processed to Employees in hierarchy
Plan for production of material based on the Demand.

MOTHERSON SUMI SYSTEMS LTD : EBS R12.1.3 Implementation

Highlights of the Solution

More than 600 CEMLIs developed for EBS R12 Implementation.
Worked along with Oracle and MIND Teamclent3
Migration of Bulk data from the legacy system
Interfaces for sending data to and fro from Oracle and Legacy Systems
Business processes redesigned as per Oracle
Report generation for Business users in BI publisher, Discoverer and Hyperion System
Advance Supply Chain Planning System custom form development as per Business needs.

Safexpress : Implementation, Rollout and Support

Client Background

Safexpress is logistics company which provide logistics services to B2B and B2C Customers. Safexpress had requirement for automating the process of billing to their customers to whom they send the bills manually or over email.

Client Need

Safexpress was already on 11i instance but need to re-implement the system due to data inconsistency.Safexpress needed Balance Sheet through system for which they need to have correct Trial Balance

Solution

The solution was offered to re-implement the system in latest version R12.1.3.
Use General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets, Cash Management, Purchase Order, Inventory and India Localization module to meet their specific requirement.

Business Impact

Transaction data should be correct for all modules.
Trial Balance should be correct so that Balance sheet and Profit/Loss can be finalize on the basis of Trial Balance.

Safexpress : Implementation, Rollout and Support


Highlights of the Solution

Implemented GL, AP, AR, FA, CM, PO, INV and India Localization module
Implemented TDS, Service Tax and VAT processcleant4
Post Implementation Support
Design Interface to map local billing system(Propel) with Oracle
Design custom interface to map Customer master from Oracle to Propel
Implemented Multi Org and MOAC features
Month End and Year end closing process
Bank Account Transfers and Reconciliation process
P2P and AP to FA cycle support
Rollout of Green Truck business in Oracle as separate entity.
Implemented custom check process and simplified Payment process by using Pay Group and Laser Printer installation
Well trained the users with proper training manual
Design custom reports to meet business requirement for Finance and SCM modules.