Why is there a difference between the table SYSADM.PS_PROJECT and the corresponding table in the OWS?
Last updated on NOVEMBER 28, 2016
Applies to:PeopleSoft Enterprise EPM Financials Warehouse - Version 9.1 and later
Information in this document applies to any platform.
There are columns that exist in one but not the other. While some of these are obviously columns related to EPM (i.e. BATCH_SID, DATA_ORIGIN, etc) others seem to be operational
columns that exist in PS and not in the warehouse (i.e. PC_HEALTH, PC_HEALTH_CALC, PC_HEALTH_DTTM).
documentation clearly states:
'The structure of the OWS target tables match the structure of the source transaction tables with the addition of a source system identification column (SRC_SYS_ID), which enables you to track the origin of your data'. - PeopleSoft 9.1: EPM Fundamentals, June 2013, pg. 35
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