My Oracle Support Banner

After Updating Personal and Shift Information in Application Details, the Date-Time Fields On HRS_APPPRF_SHFT Are Blank. (Doc ID 2037656.1)

Last updated on MARCH 09, 2017

Applies to:

PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


After updating Personal and Shift information in Application Details, the date, time and operator fields on the table HRS_APPPRF_SHIFT are changed to blanks.
The date, time and operator fields should be updated with current date and time and the operator ID for the person who made the change.

If only Personal Information is changed, there is no impact on HRS_APPPRF_SHFT table.


Preliminary Step:  Identify a test applicant who already has date and time and operator information in HRS_APPPRF_SHFT. 
1. Navigate to Search Applicants and search via Home > Recruiting > Search Applicants.
2. Search for the selected test applicant; Manage Applicants page is displayed.
3. Click on the Application icon; then from Other Actions column select Recruiting Actions > Edit Application Details.
4. Edit any applicant personal information.
5. Edit Desired Shift field and save.
6. Query HRS_APPPRF_SHFT and note that fields HRS_ROW_ADD_OPRID, HRS_ROW_ADD_DTTM, HRS_ROW_UPD_DTTM, HRS_ROW_UPD_OPRID which previously existed for that application are blank.

Due to this issue, there is no way to determine who changed shift information for an applicant.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.