Multi-source OBIA Loadplan (PSFT On-prem & Fusion Cloud HCM) Doing Unneeded TRUNC For Processed Time
Last updated on DECEMBER 22, 2016
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.1 and later
Information in this document applies to any platform.
On : 188.8.131.52.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?
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