My Oracle Support Banner

Project Status Not Updated Correctly for the PeopleSoft Adaptor in Project Dimension (Doc ID 1432947.1)

Last updated on SEPTEMBER 04, 2019

Applies to:

Business Intelligence Applications Observer - Version 7.9.6 [1340] and later
Information in this document applies to any platform.


Whenever project status is changed on a project, a record gets inserted into PS_PROJECT_STATUS table, whereas the master project record in PS_PROJECT doesn't get updated. The out of the box ETL logic in SDE mapping SDE_PSFT_ProjectDimension uses PS_PROJECT as the driving table - thus, it is not picking up these records from PSFT whose project statuses have been changed.


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

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