Implementing HR Analytics Oracle EBS Adaptors

Implementing HR Analytics using E-Business Suite Adaptors

Implementing HR
Analytics using
E-Business Suite
Adaptors
- A technical documentation of various aspects of the product as applies to
Oracle Business Intelligence Applications – HR E-Business Suite Adaptors

Oracle Corporation |

1

Implementing HR Analytics using E-Business Suite Adaptors
1.

ORACLE BI APPLICATIONS E-BUSINESS SUITE ADAPTOR (7.9.6 +) .......................... 4

2.

GENERAL BACKGROUND OF ORACLE E-BUSINESS SUITES ADAPTORS .................... 4

3.

KEY ETL PROCESSES AND INCREMENTAL REFRESH STRATEGIES ............................. 5

3.1.

Persistent Staging Tables ...................................................................................................................... 5

3.2.

Incremental refresh of DW based on Event Queues .............................................................................. 6

3.2.1.
3.2.2.

An incremental refresh use case..................................................................................... 6
A worked out example of Event Queue table ................................................................. 7

4.

GENERAL IMPLEMENTATION CONSIDERATIONS ............................................................ 8

5.

IMPACT OF INCORRECT CONFIGURATIONS OF DOMAIN VALUES .............................. 9

6.

DETAILED UNDERSTANDING OF THE KEY HR ETL PROCESSES ................................ 11

6.1.

Core Workforce Fact Process .............................................................................................................. 11

6.1.1.
6.1.2.
6.1.3.
6.1.4.
6.1.5.
6.1.6.
6.1.7.
6.1.8.
6.1.9.
6.1.10.
6.1.11.
6.1.12.
6.1.13.
6.1.14.
6.1.15.
6.1.16.
6.1.17.
6.1.18.
6.1.19.
6.1.20.
6.1.21.
6.1.22.
6.1.23.
6.1.24.
6.1.25.
6.1.26.

ETL Flow ........................................................................................................................ 11
Key Steps and Table Descriptions