Multi-source OBIA Loadplan (PSFT On-prem & Fusion Cloud HCM) Doing Unneeded TRUNC For Processed Time
(Doc ID 2213781.1)
Last updated on FEBRUARY 03, 2019
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.1 and later
Information in this document applies to any platform.
On : 18.104.22.168.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?
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