My Oracle Support Banner

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.

Symptoms

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

Changes

 

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.