OBIA 11g: Soft Delete Not Working In W_EMPLOYEE_D For PeopleSoft Source
(Doc ID 2486396.1)
Last updated on FEBRUARY 13, 2019
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 to 220.127.116.11.1 [Release 11g]
Information in this document applies to any platform.
PeopleSoft 9.2 source
Encountered a problem with the data present in W_EMPLOYEE_D. Soft delete is not working for a PeopleSoft source.
- Soft delete is enabled for W_EMPLOYEE_D.
- Soft delete is working for EBS data source.
- Soft delete is not working for PeopleSoft (PSFT) data source.
- Example: For specific employee hire date was altered from 11-Jun-18 to 31-May-18. PSFT Source table (PS_JOB) has just current active record for the employee with the hire date of 31-May. But W_EMPLOYEE_D table has two records for the employee, 1 showing a hire date 31-May and the other a hire date 11-Jun. The 11 June record is marked as current record rather than being marked as deleted because it does not exist in source anymore. This is resulting in wrong hire date being displayed on the OBIEE HR dashboards.
EBS 12.2 (SCM, Procurement, Finance)
PSFT 9.2 (HR)
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