Multi-source OBIA Loadplan (PSFT On-prem & Fusion Cloud HCM) Doing Unneeded TRUNC For Processed Time (Doc ID 2213781.1)

Last updated on DECEMBER 22, 2016

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.9.1 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.9.1 version, DataWarehouse

We are implementing BI Applications HR Analytics in a multi-source situation (Peoplesoft 9.1 on-premise and Fusion Cloud HCM via the BI Cloud Connector).

When we generate a loadplan (all phases, SDE/SIL/PLP) which includes BOTH sources, we are seeing a situation where the generated loadplan steps for the Time & Labor --> Processed Time fact group include an extra TRUNC command at the session level for the Fusion version of the SDE interface. This is causing all the data that was just loaded by the PSFT SDE for processed time to be removed before it can be processed further during the SILO phase.

Screenshots are attached illustrating the multi-source loadplan, the correct common TRUNC during fact group initialization, and then the individual source SDE session steps illustrating the problem.

This does not appear to be happening for other shared fact groups (Workforce Events, Accruals, etc). Possibly a bug for Fusion's Process Time interfaces or loadplan configuration?

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms