HR Training Data Missing From PS_TRAINING Table
(Doc ID 2577753.1)
Last updated on AUGUST 20, 2019
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.
When comparing TEST, which was cloned from production on July 2nd, and PROD, it was noticed that there are missing entries in PS_TRAINING for some of the courses.
However, the HR staff cannot delete courses so the number should match or be greater in Production.
The issue can be reproduced at will with the following steps:
1. Run the following Query in Test and Prod
select * FROM PS_TRAINING A where A.COURSE = 'XXXXX' AND A.SESSION_NBR in ('YYYYY','ZZZZZ');
2. Note there is missing data in Prod
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