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 SEPTEMBER 26, 2019

Applies to:

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


In HCM 9.2

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.


1. Navigate to Search Applicants and search via Home > Recruiting > Search Applicants.
2. Search for the selected test applicant  who already has date and time and operator information in HRS_APPPRF_SHFT> 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.