Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

June 20, 2018

The marriage of Agile and Waterfall in a Telco World

 

We often hear of organizations undergoing the aches and pains associated with the transition from a traditional waterfall to a fast paced agile model. During the course of this transformation, the waterfall model is looked down upon as slow or rigid that hinders the responsiveness to business needs. However, that does not mean Agile is most appropriate in all cases.  What probably works is something that lies within the spectrum.

Continue reading " The marriage of Agile and Waterfall in a Telco World " »

May 31, 2018

Development of eText templates based BIP report'

Objective:

The objective of this material is to provide a beginner's guide( similar to Hello world codes in Java world) to BIP eText report developers. Using this material, any report developer with basic knowledge on BIP can start working on eText Templates.

Introduction

An eText template is an RTF-based template used in generating text output intended for electronic communication. For the same reason, the eText templates must follow very specific format instructions for exact placement of data. At runtime, BI Publisher applies this template to an input XML data file to create an output text file that can be transmitted to a bank or other customer.

eText templates are categorized as Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI).

An EFT(Fixed Position) is an electronic transmission of financial data and payments to banks in a specific fixed-position format flat file (text).

EDI(Delimiter Based) is similar to EFT except it is not only limited to the transmission of payment information to banks. It is often used as a method of exchanging business documents, such as purchase orders and invoices, between companies. EDI data is delimiter-based, and also transmitted as a flat file (text).

In this series, I am developing BIP reports with Delimiter based and Fixed position templates.

Delimiter Based eText Report:

For creating Delimiter based eText Report, please follow the trailing steps.

1. Use trailing sample data and create a Datamodel.

<DATA_DS>
  <G_1>
   <Bank>600</Bank>
   <Obligor>600664421</Obligor>
   <Customer_Name>XYz Indus Valley bank</Customer_Name>
  </G_1>
  <G_1>
   <Bank>601</Bank>
   <Obligor>600664421</Obligor>
   <Customer_Name>O'Commerce bank</Customer_Name>
  </G_1>
  <G_1>
   <Bank>602</Bank>
   <Obligor>600664421</Obligor>
   <Customer_Name>ABC bank</Customer_Name>
  </G_1>
</DATA_DS>

2. Create a RTF template file. To begin with, Copy trailing content and save it as Delimetr_eText.rtf.


XDO file name:    Mapping of Payment Format:                                                                                                          Date: 4/15/2018


Delimetr_eText.rtf                                                                              US NACHA Payments EDI Format


Delimiter Format Setup:

Hint: Define formatting options...



<TEMPLATE TYPE>

DELIMITER_BASED

<OUTPUT CHARACTER SET>

iso-8859-1

<CASE CONVERSION>

UPPER

<NEW RECORD CHARACTER>

Carriage Return


Hint: Format Data Records Table for DELIMITER_BASED

 



<LEVEL>

DATA_DS

<MAXIMUMLENGTH>

<FORMAT>

<DATA>

<COMMENTS>

<NEW RECORD>

TableHeader

20

Alpha

'Bank'

 

1

Alpha

'|'

 

20

Alpha

'Obligor'

 

1

Alpha

'|'

 

20

Alpha

'Customer_Name'

 

1

Alpha

'|'

 




<LEVEL>

G_1

<MAXIMUMLENGTH>

<FORMAT>

<DATA>

<COMMENTS>

<NEW RECORD>

CLRDAta

20

Alpha

Bank

 

1

Alpha

'|'

 

20

Alpha

Obligor

 

1

Alpha

'|'

 

20

Alpha

Customer_Name

 

1

 

'|'

 

<END LEVEL>

G_1


<END LEVEL>

DATA_DS


3. Create a BIP report with the above Data model (ref point 1) , upload Delimetr_eText.rtf  file with template type as eText.

4. Execute the Report. You might expect outcome as below:

5. For detailed steps, kindly go thro the Oracle link https://docs.oracle.com/cd/E10091_01/doc/bip.1013/b40017/T421739T481436.htm.

Fixed Position Based Report:

For creating Fixed Position Based Report, please follow the trailing steps.

1. Use trailing sample data and create a Datamodel.

<DATA_DS>
  <G_1>
   <Bank>600</Bank>
   <Obligor>600664421</Obligor>
   <Customer_Name>XYz Indus Valley bank</Customer_Name>
  </G_1>
  <G_1>
   <Bank>601</Bank>
   <Obligor>600664421</Obligor>
   <Customer_Name>O'Commerce bank</Customer_Name>
  </G_1>
  <G_1>
   <Bank>602</Bank>
   <Obligor>600664421</Obligor>
   <Customer_Name>ABC bank</Customer_Name>
  </G_1>
</DATA_DS>


2. Create a RTF template file. To begin with, Copy the trailing content in a word document and save it as FixedPositionr_eText.rtf                .

XDO file name:    Mapping of Payment Format:                                                                                                          Date: 4/15/2018

FixedPositionr_eText.rtf                                                                    US NACHA Payments EDI Format

FIXED POSITION Format Setup:

Hint: Define formatting options...


<TEMPLATE TYPE>

FIXED_POSITION_BASED

<OUTPUT CHARACTER SET>

iso-8859-1

<CASE CONVERSION>

UPPER

<NEW RECORD CHARACTER>

Carriage Return


Hint: Format Data Records Table for FIXED_POSITION_BASED


<LEVEL>

DATA_DS

<POSITION>

<LENGTH>

<FORMAT>

<PAD>

<DATA>

<COMMENTS>

<NEW RECORD>

TABLE_HEADER

1

15

Alpha

R, ' '

'Bank'

 

16

3

Alpha

R, ' '

'|'

 

19

15

Alpha

R, ' '

'Obligor'

 

35

3

Alpha

R, ' '

'|'

 

39

50

Alpha

R, ' '

'Customer_Name'

 

90

3

Alpha

R, ' '

'|'

 

 

<NEW RECORD>

ENTRY_DETAIL_A

 

2

90

Alpha

R, ' '

'________________________________________________________________________________________________________'

 

<LEVEL>

G_1

<POSITION>

<LENGTH>

<FORMAT>

<PAD>

<DATA>

<COMMENTS>

<NEW RECORD>

TABLE_HEADER

1

15

Alpha

R, ' '

Bank

 

16

3

Alpha

R, ' '

'|'

 

19

15

Alpha

R, ' '

Obligor

 

35

3

Alpha

R, ' '

'|'

 

39

50

Alpha

R, ' '

Customer_Name

 

90

3

Alpha

R, ' '

'|'

 

<NEW RECORD>

NewLine

 

2

90

Alpha

R, ' '

'________________________________________________________________________________________________________'

 

<END LEVEL>

G_1

<END LEVEL>

DATA_DS


 

3. Create a BIP report with the above Data model (ref point 1), upload FixedPositionr_eText.rtf     with template type as eText.

4. Execute the Report. You might expect outcome as below:

5. For detailed steps, kindly go thro the Oracle link https://docs.oracle.com/cd/E10091_01/doc/bip.1013/b40017/T421739T481436.htm.

Continue reading " Development of eText templates based BIP report' " »

April 28, 2018

Platformization at Telcos


Telecom service providers operate in a highly competitive environment. There has been continuous erosion of profitability around their core services related to connectivity and content. Platformization is a means for the Telcos to capitalize on new revenue generation opportunities by leveraging their networks, infrastructure, IT systems and customer data.

Continue reading " Platformization at Telcos " »

April 23, 2018

Sentiment Analysis with Twitter data using Oracle Analytics Cloud

Oh! human sentiments can be analyzed is it ?!!(my first thought when I heard about this couple of months back J)

So started digging and thought of sharing an end to end view on how it can be achieved.

First of all, analysis is all about data. To do Sentiment Analysis, we need data about our ideas, emotions, feelings, likes, dislikes ...etc. So primary source for this data would be social network like Facebook, Twitter ...etc.

Outcomes of a Sentiment Analysis can be categorized under Polarity and Subjectivity.

Polarity is about - Negative, Neutral or Positive

Subjectivity is about - Objective or Subjective

Below I am going to explain the steps to do Sentiment Analysis for Polarity derivation using Twitter feed, Python program and OAC (Oracle Analytics Cloud).

Step#1: Get feed from Twitter using Python

       Login to twitter link with your credentials https://developer.twitter.com/ and create an application

       Save the customerkey, customer secret, accesstoken, accesssecret keys available. Need this tokens to extract the feed.

       Install python 3 (or any suitable version) and Install pip and tweepy though command prompt

       Download get-pip.py file github.com  and  follow the steps)

       Run the command "python get-pip.py" through command prompt.

       "Python.exe -m pip"(to get list of commands)

       "Python.exe -m pip install tweepy" (command to install tweepy)

       A bit of coding now in Python J (Find a simple template code to get data from twitter)

       Run the script through command prompt as <<python file name>>. Then CSV twitter file will get downloaded to your desktop. Use that file in OAC to perform sentimental analysis.

Step#2: Sentiment Analysis using OAC

As part of OAC, DVCS has inbuilt capabilities to perform sentiment Analysis on textual data. To invoke sentimental functionality, add the twitter data set and create a data flow using the data set

In Oracle DV, sentiment analysis is implemented using Python. To invoke it add Analyze Sentiment node to the dataflow.

  §  Click on create Data set and select the twitter csv file and click on add

  §  Click on create data flow

  §  select the data set which you added (twitter excel) and click on Add

  §  For e.g. I took the twitter feed of product XXXXX and performed sentimental analysis on column "Tweet Text"

SentImage1.jpg










SentImage2.jpg












       Click on + sign and select "Analyze Sentiment"

SentImage3.jpg

















       In the Analyze Sentiment pane, Output section, give a column name to capture the emotion value. Rename the default column 'emotion' as needed.


SentImage4.jpg
















       In the Parameters section, choose the column with text content to analyze

       Click on select column and add the column from available data for e.g. Tweet Text

       After adding the analyze sentiment column we can see column with name as emotion and it indicates the "Positive"," Negative" or "Neutral"

       To add the column, click on Add step (+) and select the Add Columns

       Rename the column as required

       Give the Expression and click on Validate and select apply

       Now we can see the Count column added to the available data, click on save


SentImage5.jpg










SentImage6.jpg





















       Go to Home page and click on create and select the Project as shown

       Select the Dataflow which you created above and click on Add to project

       Select the attribute emotion and select the count measure and click on pick visualization (or you can drag drop the columns on right side pane accordingly)

SentImage7.jpg











SentImage8.jpg









SentImage9.jpg












       Below is the pie chart which is showing the positive, negative or neutral tweets as per the data available in the data set.

SentImage10.jpg

 

 









Python Code:

Using the below code snippet you could write a simple code to extract feed from twitter 
TwittercodeImg1.JPG




TwittercodeImg2.JPG

April 17, 2018

Enabling CA Signed Certificate in Oracle JCS and On-Premise Weblogic

Enabling CA Signed Certificate in Oracle JCS and On-Premises WebLogic (How To Series)

Tools: KeyTool, Openssl (Optional)

Introduction

By default Oracle JCS server has self-signed certificate based SSL/TLS. For enhanced security and trust, we have to use CA signed certificates.  This document can be used for both On-premises WebLogic servers and Oracle JCS based Weblogic servers. Implementing CA signed certificate can prevent hacking attack like man-in-the-middle. Using CA signed certificates internal and external communications between services can be secured. Also environment access can be secured.

Key Features covered in Document

1) Brief about CA signed certificates and how chain of certificates are maintained.

2) How to implement chain of CA sign certificate on WebLogic admin and managed server.

Continue reading " Enabling CA Signed Certificate in Oracle JCS and On-Premise Weblogic " »

March 31, 2018

Blockchain & Finance - An Introduction for the CFO

Have you heard about blockchain? Even if you have not heard about blockchain, you would surely have heard about bitcoin.  Bitcoins are not blockchain but Bitcoins use the blockchain technology.

Why should a CFO concern about blockchain technology?

The blockchain technology is a big game changer.  It can be used to solve many business problems. While some industries are hugely impacted, others might have minor impact. Also, since the technology is evolving and maturing new impacts are getting discovered every day. Ignoring the technology could mean loss of competitive advantage, inefficient process impacting shareholder value. As the guardian of the shareholder value, it is of great importance to the CFO to understand the technology in general and impact on finance function in particular.

Before, we discuss how the blockchain impacts the finance function, let us understand what blockchain is, what its unique features are, what are its benefits.

What's the name?

The blockchain technology is also sometime referred to as DLT i.e. Distributed Ledger technology. While there are minor differences between the two, to keep things simple, we can assume both are the same.

What is blockchain / DLT (Distributed Ledger Technology)?

As the name indicates the technology uses blocks, chains, is distributed (i.e. decentralized) and ledgers (list of data). Basically DLT uses blocks to store data, the data is linked / chained to each other most likely using cryptology.  Apart from data storage / linkage, in DLT the complete data will be replicated (distributed). The data in the block chain is stored based on a 'consensus' rule and blockchain might also have smart contracts, which gets executed based on certain criteria.

Blockchain / DLT (Distributed Ledger Technology) - How does it help?

Because of the above characteristics, a blockchain can help businesses

  • Speed up business processes - transactions taking days can be done in seconds.

  • Reduce costs - as it will enable direct peer-to-peer interaction without the need for intermediaries.

  • Reduces risks - as the transactions are immutable and cannot be changed ones created

  • Enforces and builds trust - all data is transparent and additions are through a consensus mechanism.

Maybe the above discussions are very technical, let me describe a finance use case for better understanding of the technology and the benefits. 

Trade Finance - Use Case - Using Oracle Cloud, Oracle Blockchain Cloud Service

Trade finance is one of the areas where the blockchain technology is already in use. Let us imagine a typical bill discounting scenario.  The scenario will have the following participants - buyer (say 'ABC Electronics'), seller (say 'LG Electronics'), and financing bank (say HSBC).  Assume we are the buyers, using Oracle Cloud applications.

ABC Electronics buys the goods from the LG, on receipt of the goods and the invoice from the LG, the details are sent (physical copies of invoice) to the HSBC bank. HSBC bank verifies the data and then releases funds to the LG based on the due date.

Note the above process

  • Might take 3-5 days, probably more

  • The participants to the process, do not have a visibility of the status - Are the goods received by the ABC Electronics, is the invoice received by the ABC Electronics, has HSBC bank got the document, has HSBC bank verified the documents.

  • The invoices might get damaged, lost, tampered with - as they move between the different parties.

How can Oracle Blockchain Cloud Service help here-

With blockchain we can now build a solution whereby

  • The business process of sending goods, receiving goods, receiving invoices, sending invoices to the buyer, verification of receipts and invoices by the buyer, sending the invoice to the bank can be captured / shared  on the blockchain

  • The transactions on consensus gets added to the block chain and cannot be tampered with (immutable)

  • Additions to the blockchain can be done by automatic process / manual process. Oracle Blockchain Cloud Service offers REST API's to automatically integrate the Oracle cloud applications with Oracle Blockchain Cloud Service.

  • New data can be added based on an agreed consensus mechanism, which can be built using Oracle Blockchain Cloud Service.

  • Oracle Blockchain Cloud Service also offers a front end application, which help the participants to view the status of the transactions (data transparency)

  • The physical invoices need not be sent to the bank, the bank can directly connect via RESTAPI offered by Oracle Blockchain Cloud Service, to verify the invoices captured by the buyer. ( eases and speeds up the process)

  • With Oracle Blockchain Cloud Service, a smart contracts can be built to automatic transfer amounts to the seller, on due verification of the invoices (process automation)

Below is the pictorial representation of how data (block) gets added to each node after each business event based on consensus between all participants and the same view is available to all participants.

With the above solution

  • The data is visible to all participants and is consistent across all participants.

  • Physical invoices need not be sent to the bank.

  • The correct invoice details are confirmed by all parties and cannot be tampered with (immutable). The ability is only possible due to the use of blockchain technology.

  • Smart contracts executed automatically to initiate supplier payments.

  • The time to process the payment to the seller can be done in few minutes instead of days

Are there other Use cases - Impacts on finance function?

While there is a big impact on financial services industry, crypto-currencies, the focus of this note is to discuss the impact on the finance function perspective, at a more micro level.

There are many other use cases. As the technology matures, the way it is implemented is also evolving and new use cases are getting discovered.

Oracle (in Oracle Open World 2017) while releasing the Blockchain Cloud Service solution, have listed a good set of questions which will help you determine the possible use cases for blockchain. Businesses need to check on below to discover potential use cases

  • Is my business process pre-dominantly cross departmental / cross organizational? ( think of intercompany reconciliation, interparty reconciliations)

  • Is there a trust issue among transacting parties? ( think of trade finance scenarios)

  • Does it involve intermediaries, possibly corruptible?

  • Does it require period reconciliations? ( think of intercompany reconciliation, interparty reconciliations)

  • Is there a need to improve traceability or audit trails? (think of bank confirmation letters, third party balance confirmation letters needed by auditors)

  • Do we need real time visibility of the current state of transactions? (think of publishing reports to various stakeholders)

  • Can I improve the business process by automating certain steps in it? (think of automatic payment, based on inspections by a third party).

From above, we can see numerous opportunities for improving the finance functions. Let me try to list possible use cases by critical functions of finance.

S Num

Function

Sub-Function

Possible impacts

1

Financial Management

 

Ø  Strategic Planning

Ø  Annual Planning

Ø  Rolling Forecasting (Quarterly / Monthly)

Ø  Working Capital management

Ø  Forex management

An internal, permissioned blockchain can be built to get consensus on the plan, which is transparent to all participants and immutable.

 

A permissioned blockchain can be setup to speed up the funds disbursement process for trade finance

2

Financial Reporting and Analysis

 

Ø  Statutory and External Reporting (GAAP / IFRS / VAT etc.)

Ø  Management Reporting (Scorecard, Dashboard)

Ø  Strategic Finance (Scenario Planning. M&A)

Ø  Customer and Product Profitability Analysis

Ø  Balance Sheet, P&L ,Cashflows

A permissioned blockchain can be setup for secured communication of reports which is secured, tamperproof, quick to publish.

 

3

Governance, Risk and Compliance

 

Ø  Financial Policies & Procedures (Business Rules Management)

Ø  Tax Strategies and Compliance

Ø  Tax  Accounting

Ø  Audit, Controls and SOX Compliance

Ø  Enterprise and Operational Risk Management

Ø  System Security and Controls

Secured communication of reports to government authorities.

 

A permissioned blockchain can be built to get consensus on the account balances for audit purposes.

4

Finance Transactions and Operations

 

Ø  General Accounting

Ø  Managerial Accounting

Ø  Accounts Payable

Ø  Credit and Collections

A permissioned blockchain can be built which is transparent, immutable and consensus based to capture customer promises for cash collections.

5

Financial Consolidation

 

Ø  Period end Book closure (monthly, quarterly, yearly)

Ø  Currency translation and trial balances

Ø  INTRA and INTER company transaction accounting

Ø  System of records close ( COA,  GL, Sub-ledgers)

A permissioned blockchain can be built to share and agree on intercompany balances.

 

Any pitfalls? What should you check?

There are many potential uses of this technology. As the technology matures and more Proof of concept projects get executed, new use cases are getting discovered and old use cases are also getting dropped.  As per Gartner Hype cycle, blockchain technology has passed the 'Peak of Inflated expectation' phase and is likely to enter in the 'Trough of Disillusionment' phase as POC's start failing before entering the 'Slope of entitlement' phase.

Considering the hype, there is a risk of trying to force-fit blockchain in scenarios, where simpler, cheaper, faster options might work better. While blockchain are immutable, highly secure, there are few exceptions and special attention is needed to ensure the exceptions are understood and managed. The government regulation to manage blockchain contracts also need to be evolve. There are also concerns with data transparency, which might not always be a good thing.

Conclusion

Blockchain is a big game changer.  Its impact on the finance function is inevitable. As the technology matures, the technology will help the CFO automate, speedup processes, build internal controls even with third parties outside the organization.  The CFO organization should start discussion on discovering use cases. It is likely that new ways of doing processes might be developed, in a way never imagined before.

The intention of the article is to give an introduction to blockchain, the impact on finance function and how Oracle Blockchain Cloud Service can help with build a block chain quickly.

Continue reading " Blockchain & Finance - An Introduction for the CFO " »

March 28, 2018

Resource demand analysis with High Level Resource Planning

Resource feature getting used in Primavera is limited to the projects that are in hand/currently running and resource assignment is done appropriately for the same.

But for EPC Organizations having turnover more than $500M-$1Billion or more they always have a need to know the resource shortage/excess they have on board for the next 2 years or atleast for next 6 months or 1 year at a high level.

Organizations are using different methods to get this high level resource plan for company to company mainly to know the manual worker count required example for welders/fitters/riggers etc. in the next coming year or so where this requirement and usage are at peak level every year and having a difficulty to get at the right time such resources on board.

However this can be mitigated using a feature 'High Level Resource Planning' in Primavera Web module itself but the Primavera capability is used only for a narrow level of Project Planning, Scheduling, Resource Assignments capabilities by most of the EPC Organizations however the potential to tap it's usage is already inherent to plan even for an Organizational level Project staffing requirements and mainly for EPC sectors yet not dived into that functionality.

At any given point in time Primavera already provides the Resource analysis graph for the current running projects assignments cumulatively with high level resource planning being done now we are able to get the picture to depict on Manpower planning in future.

Resource planning flow of Organizations when High Level Resource Planning is in use:

 

Capture_Ara.png

Continue reading " Resource demand analysis with High Level Resource Planning " »

March 26, 2018

Driving Business Intelligence with Automation

Business Intelligence applications are around for a very long time and have been widely used to represent facts using reports, graphs and visualizations. They have changed the way many companies use tools in a broader spectrum and in a more collaborative way. However, users these days are choosing these tools to be operated autonomously yet connected to a vast network that can be accessed anywhere. As BI applications analyze huge sets of data in its raw format, it makes one way or another a bit difficult to conclude intuitions and insights. Automation can help users achieve this in extending the use of Business Intelligence beyond its current capabilities just by pondering a few points in cognizance.


Intuition Detection
Automate the intuition.

Business Intelligence should be able to shoot out right questions in a click of a second and must be able to provide insights without any manual interference. Artificial Intelligence can do this in a better way using the potential of super computers to help Business Intelligence take a deep dive into the data. This makes it out to try all the available possibilities to make patterns. Leading in the discovery of trends in the business providing the needs of the user.


Intuition Blending
Automate what intuitions are prioritized.

The very idea of detecting insights in Business Intelligence should be automated in a way that it prioritizes the intuitions and ranks the worthy ones higher based on the user needs. Artificial Intelligence then further compares all the possible insights and makes relationships between them helping users to work on multiple insights at once.


Common Dialect
Automate how intuitions are defined.

Business Intelligent tools that are existing so far have done a boundless job in analyzing huge amounts of data through reports, graphs and several other graphical representations. But users must still have to figure out the insights on the best possibilities based on the analytics. This human factor leaves room for misconception, delusion and misinterpretation. This is where Artificial Intelligence takes the Business Intelligence next level and provides insights in best understandable language like English. Nevertheless, Graphs and reports can still be used to represent this accurate and widely comprehended solution.


Common Accessibility
Create a just-one-button-away experience.

Finding an insight should be very accessible and must be as simple as a click away. This is surely possible with Artificial Intelligence where BI is automated allowing user to get professional insights instantly just by clicking a button. This makes users to easily access the data without any prior knowledge on the tool or data science to make the intuitions. Available tools like Einstein Analytics from Salesforce has already got this implemented attracting huge set of users all over the globe.


Cut-Off Sway
Trust the data to reduce human fault and anticipation.

Artificial Intelligence generally reduces manual intervention thus avoiding the human errors. This sway could be because of individual views, misinterpretation, influenced conclusions, deep-rooted principles, faulty conventions. Automation by means of Artificial Intelligence gets rid of all these factors and reduces the risk of getting provoked by defaulted information. It purely trusts the data.


Hoard Intuitions
Increase efficiency by integrating insights.

Integrating the insights in the application alongside the factual data using Artificial Intelligence may make the users to stop using the BI tool directly. This hoarding ultimately makes the application an engine for other software increasing the effectiveness of the tool. Users can then spend much time in making wise money-spinning choices rather than putting unwanted efforts in using the tool. This can change the minds of many occupational users that presently do not use any sort of Business Intelligence tool.

Continue reading " Driving Business Intelligence with Automation " »

March 20, 2018

HR Leaders at 'cross roads' again, but third time's the charm !

Most HR leaders and practitioners have witnessed the proverbial 'Change is the only constant' phenomenon in HCM space since last 50 - 60 years. These changes are across the functional areas like HR Administration, HR Service Delivery, Talent Management and Workforce Management. While there has been a sea change in employee centric operational and strategic HR processes over these years from business side, technology has aided or enabled these changes.

A quick analysis of these changes will unveil interesting factors.

  1. The pace of such changes in business and technology layer have been steady and controlled.

  2.  Most of the times, they were decided based on Organizations' operational or strategic requirements.

  3. Change initiatives are driven and executed by the Organization's own team or partners / vendors.

  4. A closer look will reveal that most of these factors are 'internal' not guided by the 'external' factors, baring statutory regulatory compliance.

Today, we witness that the 'external' factors are more forceful as compared to internal factors in guiding these change decisions in an organizations' HR practices. To understand the impact, it is important to note these chronological patterns which forced these change initiatives. Lets go thru these 'decision points' for change, which forced the HR Leaders into 'cross roads' for critical decision making about their HR practices.

Manual Vs. Automation

In the period where mainframe applications were being built or personal desktop revolution post 1985, HR practices in most organizations have been evaluated on a single question 'Manual Vs. Automation' to decide the scope of HR IT work and what comes into the HR Operations part.

Mundane and higher volume transactions like Payroll, Employee Administration or Time & Attendance which were centered around data keeping, rule driven and workflow driven activities were the initial targets to decide what is being automated and what remains a manual process.

Most legacy HR applications were designed and built on this paradigm and still are functional in the same way.

User driven Vs. Self-Service driven

As we progressed, all these multiple HR applications - both in-house and commercially available COTS solutions had to be redesigned with another key question - what processes are driven / enabled by the HR User and what HR processes have to be enabled for Employee or Manager Self-Service. HR leaders were left on another cross-roads at this moment, as the control of the HR process or operations have moved from Users to Employees in certain areas.

HR Leaders and Practitioners had to redesign the current HR processes to determine the operational processes retained by the HR Users and the processes that are delivered to Employee or Mangers on self-service basis. Most in-house HR applications and COTS applications have been redesigned to respond to this trend of 'empowering the employee'.

HR Processes across various business functions centered around approvals like leave or time-sheet approvals, workflow mechanisms, simple data driven queries like pay slips or leave balance checks etc..

Human Interface Vs. Digital AND Standardized Vs. Personalized

While it is tedious to be at 'cross roads' again, HR leaders are finding themselves in cross roads again - however the third time is definitely looking very exciting as compared to last two tides of change. Aided by the technology advancements which are changing the face of the world and the imperative to cater to diversified employee needs, the upcoming changes in HR business processes and associated HR IT applications is phenomenal. Digital and Employee Experience are going to drive these changes - an exciting opportunity for all HR leaders.

This time the questions are juxtaposed asking for multiple decisions:

Decision #1: What HR processes to be retained with 'Human / Human Interface' layer and what HR processes form the 'Digital Experience' layer...

Decision #2: What HR processes are to be delivered as Industry 'Standardized' processes and what HR processes need to be 'Personalized' to improve the Employee Experience.

Moreover, these decisions impact the entire HR functional areas and not limited to only certain areas where there are data-entry or operational or approval needs.

So, the task for HR leaders now is to determine how to break-up or slice & dice the HR processes and map them into the right areas in this two-dimensional model along with the benefits or value-adds depicted above.

As part of our HCM Advisory / Strategy offerings, the 'HCM process maturity model' assessment framework is re-engineered to suit the upcoming paradigm shifts in HCM space, starting with assessment and evaluation of the each L0 - L3 process to be mapped as per these two dimensions.  

Stay tuned to our 'HCM World' showcase and sessions, to get updates about this renewed 'process maturity model' framework.

 

March 18, 2018

ODI 12C Miscellaneous concepts:

In this blog I want to share the concepts related on the below topics

Export/Import:

Export and import in ODI normally export only specific component and child components. Components under the selected mappings like temporary interfaces, reusable mappings and scenarios etc.

The exported components saved in the XML file format. Usually this process is preferred when there is a very minor change in the particular object and all environments are in sync.

odi1.JPG

Smart process:

Usual best practice of export and import is smart import/export process.Just drag the components to the wizard to be exported , it will automatically pick all the designer ,topology and dependencies used by  information related to corresponding component. Import action is similar vice versa process . Response file will track the log of import process.

odi2.JPG

 

Solutions in ODI:

Solutions are used to group the scenarios which were created for mappings, packages, procedures etc. and then we can synchronize the changes to the particular group and easily export and import to the respective environments. This would be helpful if a project contains more number of scenarios its difficult to find the changes and manually doing the migration process. So solutions are useful in grouping the required objects in the migration process. Mainly it was used in production support

odi3.JPG

 

Deployment in ODI:

Under every mapping in physical tab we can create new deployment option for the same mapping. Like changing the options in the knowledge modules or changing the type of KM's. Mostly it would be useful to run the full load or incremental load by creating new deployment and opting whichever is needed. This deployment is newly introduced in the 12c which was not present in 11g.

odi4.JPG

Commit and Isolation levels in Procedures:

Commit levels: Procedure is made up of group of tasks which are executed step by step .Each task is an SQL statement which needs to be committed. To manage the commit levels we have options like Auto commit and Transaction 0 to Transaction 9. Auto commit simply commits particular task in procedure. Transactions 0 to 9 are used to group the tasks need to commit at a time sequentially. This way we can manage the commit levels in ODI.

Isolation Levels: These levels are classified into four Committed, Uncommitted (Dirty), Repeatable, Serialazable.

Committed: The Tasks in the procedure will read the only committed data from the source.

Uncommitted (Dirty): The Tasks in the Procedure will read uncommitted data from the source (oracle doesn't support)

Repeatable: The Tasks in the Procedure while reading the huge amount of data it will lock the rows not to update at the point of time to avoid inconsistency.

Serialazable: The Tasks in the Procedure while reading the huge amount of data it will lock the respective table not to update at the point of time to avoid inconsistency.





 

Subscribe to this blog's feed

Follow us on

Blogger Profiles

Infosys on Twitter