Oracle App Cloud and Incorta

OTBI is great. But when people are migrating from Oracle EBS to Oracle Cloud App, they would like to view the data from both EBS and Oracle Cloud, Incorta becomes a cost saving and a quick implementation solution without implementing a data warehouse.

Incorta is not a data warehouse although it does has the data storage, which is optimized for extraction, optimized for internal process reading and transformation, and optimized for analytical queries.

The scalability is accomplished by a distributed architecture, and thus no issue with resource contention.

The support of Tableau and PowerBI provides an alternatives for those companies that already standardized their BI front-end.

Very interested to see how Incorta can help upsell Oracle Cloud App, not the other way around.

HR Reporting

HR is an important business function in any company.  It supports business growth.  It also satisfies the compliance requirements.  Reports are required for supporting the HR functions.

Typical HR Reporting Requirements

HR reports are surrounding the HR function:  Human Resource Planning, Recruitment and Selection, Orientation and Training, Performance Appraisal, Compensation and Benefit.

They serves many different roles and thus having different ways to slice and dice the data.

• Personal Information: Demographics, Education, Job, Location, Manager, Shift, Salaries, Payroll, Skills, Benefit
• Personal Information Changes – Before and After for audit and review
• New Hire – Who are they?  Where we are in the hiring status?  When they will start?  Temporary or Employment?  Full Time or Part Time, New Hire or Rehire? Have they attended the orientation?   Are they getting sign-on Bonus?  Are they getting stock options?
• Allowance – Who got the allowance?  How much?  How it was calculated?
• Transfer – internal transfers, what is the releasing org? which org the person is moving to?
• Assignment – Global, special assignments, start date, end date, purpose, etc.
• Training – Who take training?  What training? Compliance Status
• Termination – Who have left?  Who is leaving?  When?  Last Payroll date?

Challenges

I found that HR reporting is somewhat challenging:

Typical Business Intelligence Applications

This arcticles examines the major business drivers of business intelligence and the typical business intelligence applications. Some BI applications are common for all types of enterprise, others are specific to some industries.

• Marketing Intelligence
• Sales Intelligence
• Customer Intelligence
• Service Intelligence
• Financial Intelligence
• Project Intelligence
• Procurement Intelligence
• Human Resource Intelligence