My Oracle Support Banner

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

Last updated on FEBRUARY 15, 2019

Applies to:

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


On : 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?


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.