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  and later
Information in this document applies to any platform.
- OBI Apps: 7.9.6.x
- Source: PeopleSoft (8.9 onwards)
- Load: Incremental
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