My Oracle Support Banner

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 FEBRUARY 07, 2019

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

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
Symptoms
Changes
Cause
Solution
References


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