9th Year Anniversary Celebration

9th Year Anniversary 4i Apps – Anniversary celebration forms an integral part of our company, a day to celebrate and remember the past achievements and look forward to the journey ahead!


It is an occasion of celebration, felicitation, feast and festivity when employees present not only their wonderful performances but also receive honors for their curricular and extra-curricular achievements.

Anniversary was celebrated on 1st June 2017. Gateway Hotel, Sholinganallur, Chennai was chosen as the venue for this year’s event to set the stage.

The day started with a speech by the MD – Mr. Saravanan addressing on the journey so far and how the organization has evolved by diversifying its offerings & geographical reach along-with the use of innovation & cutting-edge technology. The function was presided over by our honorable Founders. Founders extended a warm welcome to all the employees present.

This was followed by Employee Rewards & Recognition. The Annual 5-years award Prize Distribution function was a moment of pride and honor for all the winners and achievers of the company.


This was followed by an array of cultural events where employees across the organization gave impeccable performances through multiple dance performances, songs, skit & Fashion show. In fashion show, employees dressed at their best to portray movie actors as the theme was Movies. Founders was all praise for the show, they congratulated employees for taking such an effort to make the show success.

The function also included prize distribution to the meritorious and the best contributors in cardio 2016, CARDIO is a contest to encourage innovativeness and nurture ideas among employees. The function ended with a sumptuous dinner.

Share this post

4i accelerated the Customer engagement to one of the Real estate giant in Middle East by implementing Oracle Marketing Cloud & Social Relationship Management

Marketing is transmuted into a new form in the ever expanding digital age after the immense use of social media channels among the customers irrespective of the industry. Companies across the globe become customer centric and forced to demand a Unified Social media platform and Best-in-Breed Email campaign management tool to engage with customers seamlessly. Sensing the need of the hour numerous Marketing & Enterprise vendors are queuing up to develop and claim their solution as the best, but in reality, those point solutions are neither integrated nor have the functionality to enrich the customer’s Social Media & Content Marketing journey.

In the Middle East, one of our client who is a multinational Construction & Real estate developer understood the criticality of an effective Social Media and Email Campaign management tool to replace their existing third party tool. Understanding their need and strong experience in Oracle marketing tools, 4i Apps has successfully implemented Oracle Eloqua Marketing Cloud & Social Relationship Management (SRM) to optimize their social presence and email campaignoracle-cx-cloud-forrester

With the strategy of socially enabling the enterprise, Oracle is standing tall in Customer Experience (CX) in the market share and service offerings according to the Forrester Wave: Enterprise Marketing Software Suites, Q2 2016

Oracle SRM is the industry’s first unified & centrally manageable social media platform which assisted the client to publish and monitor across their multiple social platforms like Facebook, Twitter, Instagram, LinkedIn & etc., in a single click. It offers the Interactive Dashboard & Analytics with the option to listen and respond Social media conversations. Social media management became a cake walk for the client with Oracle SRM. Social media reputation of the client has dramatically improved after the deployment of Oracle SRM.oracle-srm

Oracle Eloqua Marketing Cloud is another fine tool from the Oracle CX Cloud envisaged for the Email campaign. The client is now harvesting more leads than ever through Oracle Eloqua Marketing Cloud based multilevel email campaigns. It further helps the client to drop a follow-up email for the potential leads to prospect through free landing page development in Oracle marketing cloud. After the effective implementation & Integration of Oracle Eloqua and SRM by 4i with the ERP, Client witnessed 30% spike in Lead Generation & Social media engagement with customers. With strong analytics in Oracle CX cloud, client is able to monitor the Return on investment (ROI) from their digital marketing investments


Companies passive about the Social Marketing & Email Campaign may lead to miss a crucial piece of customer puzzle. In order to outmatch the competitors, All the businesses require effective integrated social Marketing tools like Oracle Eloqua & SRM more than just going for simple marketing.

About Author:  Muralitharan Sengodan is the Presales consultant of 4i Apps Solutions, an Oracle Platinum Partner company helping customers in Enterprise application implementation and maintenance services. He is a technology enthusiast and always delighted to explore Oracle technologies to deliver the best in class solution to the customer.

Share this post

Oracle PSRM implemented by 4i helps county to process 900+ transactions worth 10million KSH revenue every month  

In the Public sector, Revenue department always plays the vital role in the ever-changing tax and revenue system to derive revenue generation and administration transparency. Our Client who is one of the leading county in the African region was also a victim of typical Public Sector Revenue Management problems like lack of efficiency, transparency, accuracy and tax revenue leakage with disparate systems.

County’s Revenue department team adjudicated to replace the existing system with the efficient and flexible PSRM solution to ease all their pain points.  As the PSRM market is always flooded with befuddling solutions, Client chooses 4i Apps to commend and implement the suitable Public Sector Revenue Management System solution.

4i won the County Administrators trust to implement Oracle Public Sector Revenue Management after showcasing its capabilities and functionalities to address their pain points and expectations.

The Oracle Public Sector Revenue Management formerly known as Oracle Tax Applications provides out­-of-­the ­box processing and business rules across key business process areas, including Registration, Forms, Accounting, Payments, Billing, and Collections. This functionality is provided in a modern N­Tier Java application with a browser based user interface, and a Service Oriented Architecture (SOA) framework

With the certified Oracle consultants, 4i has successfully implemented Oracle PSRM within the assured time frame. After successful implementation of Oracle PSRM, client earned the high level of stakeholders satisfaction from all the sections and delighted with following benefits of solution

  • Oracle PSRM addressed all the Average Number of Transactionsbusiness requirements of County
  • Elevation in Taxpayers registrations and tax compliance
  • Deep Surge in the Revenue collection Since Oracle PSRM becomes the watchdog for Administrators
  • Oracle PSRM minimized Cost of the revenue collection for county
  • Due to Oracle PSRM’s flexible, upgradable and Integrative functionality, Client was able to integrate all their ever changing services effectively

As quoted by philosophers, Average volume of RevenueNumbers speaks the truth louder than the honey coated words. And we always go by facts, the benefits reaped by the client is illustrated aside with a statistical report. We are proud to announce that Oracle PSRM implemented by 4i helps the county to process 900+ transactions worth 10million KSH revenue every month.

**Article compiled and written by Muralitharan – Oracle Presales Consultant with inputs from Arunachalam – Project Manager – Oracle PSRM

Share this post

Zero Downtime Database Upgrade Using Oracle GoldenGate

This topic is to bring about what and how to attain a Zero Downtime Database Upgrade with the technology — Oracle GoldenGate
Introduction to Oracle GoldenGate:

GoldenGate Software was founded in 1995 and was acquired by Oracle in 2009. It was one of the hot topics at the Oracle Open world 2010.

What is Oracle GoldenGate?
It’s a software used for heterogeneous replication, even as a DR solution and most importantly for the Zero Downtime Upgradation/Migration.

Till date, Oracle GoldenGate is probably the best replication software which comes in easy to configure and deploy in the large scale environment.

Heterogeneous replication technology, the term heterogeneous sounds about that it could be the database technology with different versions of database or Operating Systems.
How does Oracle GoldenGate Works:
GoldenGate replication works by capturing the log information (could be redolog or archive log) and mining that information which will then transformed into INSERT, DELETE, UPDATE, etc and will be applied to the target database.

Features of Oracle GoldenGate:
•Disaster Recovery – Oracle GoldenGate can be used to setup a standby database for DR purpose
•High Availability – Active to Active, Active to passive, synchronizing different two or more systems with the live data and can be used any other right away when one is down.
•Zero Downtime Upgradation/Migration – Moving the database to a different platform or moving to a higher version of the database.
•Other features – Partial table replication, replication of database from higher version to lower or vice versa.

Oracle GoldenGate Supported Topologies:
•Unidirectional — (Standalone Database/E-business Suite to achieve reporting instance)
•Bi-Directional — (Standalone Database/EBS Integration with On-Premise Fusion)
•Broadcast — Data Distribution (Standalone Database/E-business Suite)
•Consolidation — Data Warehousing (Standalone Database/E-business Suite)
•Peer to Peer — Load balancing (Standalone Database)
•Cascading — Scalability, Database Tiering (Standalone Database)

Components of Oracle GoldenGate:
Various components available for Oracle GoldenGate, some of the mandatory components are,
•Manager – Controller, allocate port numbers and performs file maintenance.
•Extract (Capture) – it reads data from the data source and writes to a GoldenGate trail file.
•Replicat (Delivery) – it reads trail file data and writes it to the target database.

Zero Downtime Database Upgrade using Oracle GoldenGate:
There are few tasks which have been a very significant challenge in the IT organization, one of is Upgrading/Migrating a database with zero downtime.

Why Zero Downtime
It’s a known fact, the applications should be available in continuous or nearby-continuous to users who increasingly expect uninterrupted availability of accessing those applications.
At the same time database needs to upgrade, for the following reasons and more.
•To move from the major bugs
•To move from the panic – end of Oracle support period
•To improve the database performance
•To acquire new features.

But here the challenge is, the customer cannot afford to interrupt the business operations. To face this challenge the Oracle has come up with a best practice called “Zero Downtime Database upgrade/migrate using GoldenGate”

Steps to do achieve zero downtime upgrade:
Here let’s assume we have a database 10g (in the source) needs to be upgraded to 12c (in target).
1.Install and configure GoldenGate in Source


•Start the capture mechanism of whole database schemas in the source database, i.e. start the first EXTRACT
•This capture mechanism — EXTRACT will capture all the live transactions

2.Setting Local Trail files for the capture mechanism

•The captured transactions will store in the form of trail files (local trail files).
•The local trail files need to move to the target location so PUMP EXTRACT will help the need.

3.Buildup the target database using expdp/impdp or RMAN

•To bring the database copy at the target use the Export (expdp) of the whole database with flashback_scn or using SCN based RMAN backup. (choose the backup/restore methods depends on the DB size)
•Once restore, start the DB upgrade in the target. i.e., as per assumption here from 10g to 12c
4.Before the Apply mechanism — Pump Extract

•Before the Apply mechanism – start the Pump EXTRACT in source
•The pump EXTRACT will take the local trail files, then pumps to target which will create the remote trail files.

5.Start the Apply mechanism — Replicate

•Apply Mechanism (Replicat) will read the remote trail files and applies the transactions to the target database 12c.
•Now after the zero lag, each live transaction will be applied to the target upgrade database(12c) as in source the EXRACT captured all during the database backup and restore.

6.Switch the user to Target Server and Stop capture mechanism


•Now the users can be switched to target 12c database which does have all the recent transactions.

7.Stop Apply Mechanism


•Once the users are shifted to the new database, Stop the first Extract, once the extract is stopped, wait for the pump to catch up before stopping it. Once the pump is stopped, wait for the replicated to catch up before stopping it.

•After the final step the whole system can be reconfigured for bidirectional replication or can be upgraded to newer version of database following the same steps in reverse, which can be active-active or active to passive.
•If Bi-directional is needed it has to be configured before the user switching activity.
1.Zero Downtime Database Upgrade Using Oracle GoldenGate

2.Oracle GoldenGate zero downtime migration quick start

3.Zero Downtime Migration to Oracle Exadata using Oracle GoldenGate http://www.oracle.com/us/products/middleware/data-integration/migrate-to-exadata-using-goldengate-1424485.pdf

4.Eliminate Database Downtime with Oracle GoldenGate http://www.oracle.com/us/industries/public-sector/eliminate-downtime-goldengate-ds-329464.pdf

Posted on behalf of Hadley Apps DBA Consultant | 4iApps India

Share this post

Oracle Open World 2016 – One place to look for the latest in Oracle World


Oracle Open World OOW 2016
Oracle Open World OOW 2016

Its this time of the year when the biggest and most prominent updates in the Oracle World are made public. Yes its the Oracle Open World 2016 (OOW-16).

Follow the links below to know the New features, New Products, Road Map, Strategy for the products that you are either using or following.

Get to know how Organizations have applied Oracle’s technology to improve efficiency.


Link to Presentations


Link to Open World Keynote



Link to Open World 2016 site



Share this post

Server Pool

The server pool is a new feature in Oracle Clusterware 11gR2. A server pool is the logical division of the cluster into pools of servers for effective resource utilization. Server pools are used to create Policy Managed Databases.

A Policy-Managed database is dynamic with instances managed automatically based on resource requirement for expected workload where as Admin-Managed databases result in instances tied to specific servers.

Policy-Managed database facilitates easy allocation of resources to specific workload and simplifies the consolidation of Databases and Applications on Clusters.

Need for Policy Managed Databases (Server Pool):

 As the number of nodes becomes huge, DBA’s tasks became very complicated.
 It was not possible to add more instances dynamically to newly added servers.
 It was not possible for additional instances of database to start automatically if any servers in the cluster became idle.
 It was not possible for a service to be available on newly added nodes dynamically.

Default Server Pools:

There are 2 default pools after a Grid Infrastructure Installation:
 Free – any unassigned nodes
 Generic – for administrator-managed databases

Attributes Used for Server Pool:

Each pool will be assigned with some attributes are as follows:

IMPORTANCE (priority): The importance specifies the relative importance between the server pools. Default value is 0 to 1000.

MAX_SIZE: The maximum number of servers that can run in a server pool. Default value is 0 or -1 which indicates that all the servers in the cluster can be a part of this pool.

MIN_SIZE: The minimum number of servers that should run in a server pool. If the number of servers contained in a server pool is below the minimum size specified in this attribute, then Oracle Clusterware automatically moves servers from other pools into this one until that minimum number of server is met. The default value is 0.

Allocation of servers:

server pool

If a server leaves the cluster for any reason, a server reallocation takes place. If there are servers in the Free Pool and another server pool falls below its maximum value, a free server is allocated to the affected server pool. If there are no free servers, then server reallocation takes place only if a server pool falls below its minimum level. If that occurs, a server will be sourced from one of the following locations in the following order:
 The server pool with the lowest importance that has more than its minimum number of servers
 The server pool with the lowest importance that has at least one server and has lower importance than the affected server pool
Using these mechanisms, server pools can maintain an optimal level of resources based on current number of servers that are available.

Advantages of Server Pool:

 Distribute a uniform workload over several servers in the cluster.
 In server pool, the host of the cluster are added and removed from the pools more easily; it has taken off the burden from the DBA’s for the allocation of host in the cluster.
 With few attributes which takes care of the whole cluster became much easier for the administration, especially when the number of nodes go beyond two digits.

Posted on behalf of Manjusree | 4iapps.com

Share this post

Oracle EBS 12.2.6 Now Available

Oracle continues to enhance its flagship product Oracle E-Business Suite with the release of the 12.2.6 version. Many Supply Chain modules gets a facelift and there are some new features in store for HCM as well.

Release 12.2.6 is cumulative which means not just new updates are provided , but lso includes updates that were originally made available as one-off patches for earlier 12.2 releases

Some of the key enhancements include

HCM Area : New simplified Retro Pay management. In OTL Admin can credit overtime hours to absence acruals , have a calendar view of time card entries.

SCM Area:

Oracle Order Management extends support for flexible ordering of products, services, subscriptions and warranties with new recurring billing options. Oracle Quoting integrates with electronic signature providers to streamline customer approval of ordering documents.

Oracle Field Service and Oracle TeleService support the capture of multiple products located at the same site on a single service request. Service users can update task statuses tailored to the service tasks they are performing. Oracle Depot Repair offers a user-friendly web portal that lets authorized service partners submit approval requests and claims for outsourced repair work.

Oracle Service Parts Planning provides policy-based automation of parts replenishment, allowing service organizations to optimize service parts inventories.

Projects Area

Mapping of effort coefficients from activity resource requirements (ARR) to a schedule of values (SOV) improves project control and visibility. Project costing options reduce time and effort associated with expenditures and accounting adjustments. Project invoice consolidation simplifies billing for customers with many projects.




Share this post

4i Apps joins the ranks of niche players offering Oracle Public Sector Revenue Management solution

4i Apps starts implementation of Oracle PSRM – Public Sector Revenue Management for a county in Africa.  With Oracle Certified consultants in PSRM, 4i joins the league of niche players offering PSRM solution.



Oracle PSRM is the perfect solution for managing counties, provinces ,municipalites etc..   Oracle PSRM combined with Oracle E-Business Suite provides a comprehensive solution for Public Authorities/Counties. OUAF framework available within PSRM helps customize and extend the PSRM to develop public authorities unique requirements.  Using Oracle SOA , PSRM can be integrated tightly with E-Business Suite for an Integrated experience.

Previously known as Oracle Tax Applications, Oracle Public Sector Revenue Management is specifically designed to support the challenges of tax and revenue administrations worldwide. It is a secure, tax-specific, commercial off-the-shelf (COTS) software solution that enables tax and revenue administrations to optimize all aspects of the revenue collection process and quickly respond to tax law and regulatory changes.



Share this post

Career Progression

More often than not we chance upon a job than choice upon one. It could be close to our academic pursuits, our interest or ambitions and sometimes way off the mark. Either which ways having accepted or landed in a job we will need to look to continue, build, grow and settle. This feature of continuing, building growing, settling in a job can be broadly defined as career progression.
Three important dimensions form part of career progression. One is the core skill which is ability in performing the respective job or task. The second being the soft skills encompassing communication, people skills, body language, and presentation. And a third more generic but key attribute will mean good Attitude.
One of the popular HR sayings is that ‘’Hire for Attitude and Train for skills’’. So a good attitude will always mean a direct weightage, recognition and ready acceptance by Superiors, Peers and Subordinates alike.
Practice makes perfection. The core skill development remains in proportion to the ability and interest to learn. In an extremely dynamic technology driven environment, learning and continuously in that is key to inching ahead from the base of the pyramid to its tapering heights. So always seek to be a part of a system that provides an environment to continuously learn and allows you to remain abreast and in pace with the advancements. Bottom line make learning your journey and never your destination.
Yet another and a third dimension to a successful career will mean the broad spectrum of soft skills. This will include oratorical skills, people skills, presentation to an audience, body language, dressing. The better these skills the faster and lasting impact you can leave or create among a diverse or wide spectrum of audience or groups. These skills help leave an aura about you and easily gains you acceptance and may be even a following.
So the threesome combo of good Attitude, learning, well-groomed personality will mean a perfect recipe to a successful career. Oh yes, these attributes assured compensation and benefits will become incidental!!! So never fret on that count.
The above mere inferences from learnings thru experience. Best Wishes people!!! !!!

Posted on behalf of Ravi KT (Head HR) | 4iApps India

Share this post