Why is there a difference between the table SYSADM.PS_PROJECT and the corresponding table in the OWS? (Doc ID 1588753.1)

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.

Symptoms

 

Why is there a difference between the table SYSADM.PS_PROJECT and the corresponding table in the OWS?
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).

Changes

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

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