On-premise ERP Processes


Type

Module

Process Name

Description

Run Schedule 

Oracle E-Business Suite

Admin

Synchronize Oracle EBS Responsibilities

This process end dates responsibilities, user responsibilities in SplashBI if they are end dated in Oracle EBS. It also adds any responsibilities in SplashBI if they 
are added in Oracle EBS.

Every Night

Oracle E-Business Suite

Admin

Add DFF Columns to Views Process

This process adds DFF columns to the SplashBI EBS views that include seeded and custom reports. 

Whenever a DFF is changed.

Oracle E-Business Suite

Admin

Add KFF Segments to Views Process

This process adds KFF columns to the SplashBI EBS views that include seeded and custom reports.

Whenever a KFF is changed.

Oracle E-Business Suite

Admin

Remove DFF Columns From Views Process

This process removes DFF columns from the SplashBI EBS views and reports. 

Whenever a DFF is to be removed from the SplashBI Views.

Oracle E-Business Suite

Admin

Remove KFF Segments From Views Process

This process removes KFF columns from the SplashBI EBS views and reports.

Whenever a KFF is to be removed from the SplashBI Views.

Oracle E-Business Suite

Admin

Dashboard Data Loader

This report/process loads the data 
in to the Dashboard fact tables and this report populates the dashboard datamarts.

Recommended to run this as a night job or when data loading is needed.

Oracle E-Business Suite

Admin

Dashboard Data Deletion

This report/process purges the data from all the dashboard fact tables for given date range.

Recommended to run this process when purging is needed.

Oracle E-Business Suite

Payroll

Generate Balances Date Range

This report/process populates the balances in EiS payroll datamart for given check date range. These balances are used for reporting purpose in Payroll module.

Every night if SplashBI Payroll Triggers are disabled. i.e., when Enable Triggers parameter is set to ‘N’ for this process.

Oracle E-Business Suite

Payroll – CA

Generate Balances Date Range

This report/process populates the balances in EiS payroll datamart 
for given check date range. These balances are used for reporting purpose in Payroll – CA module.

Every night if SplashBI Payroll Triggers are disabled. i.e., when Enable Triggers parameter is set to ‘N’ for this process.

Oracle E-Business Suite

Payroll – GB

GB Populate Payroll Datamart

This report/process populates the balances in EiS payroll datamart for given check date range. These balances are used for reporting purpose in Payroll – GB module.

Every night if SplashBI Payroll Triggers are disabled. i.e., when Enable Triggers parameter is set to ‘N’ for this process.

Oracle E-Business Suite

Payroll – INTL

INTL Populate Payroll Datamart

This report/process populates the balances in EiS payroll datamart for given check date range. These balances are used for reporting purpose in Payroll – INTL module

Every night if SplashBI Payroll Triggers are disabled. i.e., when Enable Triggers parameter is set to ‘N’ for this process.

Oracle E-Business Suite

Payroll

Purge Payroll Datamart

This process purges the payroll data for the given date range.

Recommended to run this process when purging is needed. Run this process during downtime.


Oracle E-Business Suite

Payroll – CA

Purge Payroll Datamart

This process purges the payroll data for the given date range.

Recommended to run this process when purging is needed. Run this process during downtime.

Oracle E-Business Suite

Payroll – GB

GB Purge Payroll Datamart

This process purges the payroll data for the given date range.

Recommended to run this process when purging is needed. Run this process during downtime.

Oracle E-Business Suite

Payroll – INTL

INTL Purge Payroll Datamart

This process purges the payroll data for the given date range.

Recommended to run this process when purging is needed. Run this process during downtime.

Oracle E-Business Suite

Payroll

Create Costing Reports

The process creates the costing reports (Costing Details, Costing Summary) based on the Business Group for which this report has been submitted.

On Demand

Oracle E-Business Suite

Human Resources

Create SIT Reports

This process creates SIT reports for given SIT Name(s).

On Demand

Oracle E-Business Suite

Human Resources

Create Person EIT Reports

This process creates Person Extra Information Types reports for given EIT Name(s).

On Demand

Oracle E-Business Suite

Human Resources

Create Assignment EIT Reports

This process creates Assignment Extra Information Types reports for given EIT Name(s).

On Demand

Oracle E-Business Suite

Projects

EiS Projects Initialize Process

This report/process populates Projects Measures on projects and Task levels in EiS Project datamart from Project inception date till Datamart start Date.

Execute this process only once during projects datamart initialization. It is not needed to schedule it further.

Oracle E-Business Suite

Projects

EiS Projects Datamart Submit

This report/process populates Projects Measures for all valid Projects/Tasks on PA Period and GL period levels in EiS Project datamart for given date range.

Nightly Run

Oracle E-Business Suite

Projects

EiS Projects New Project Submit

This report/process populates Projects Measures for all valid Projects/Tasks on PA Period and GL period levels in EiS Project datamart for given List of Projects and date range.

On Demand

Oracle E-Business Suite

Projects

EiS Projects Datamart Measure Submit

This report/process populates Projects Measures for all valid Projects/Tasks on PA Period and GL period levels in EiS Project datamart for given List of Measures and date of Range.

On Demand