My Oracle Support Banner

When a Recruiter Selects "Add Application" and Saves the Entry No Row is Created in HRS_RCMNT table (Doc ID 1574720.1)

Last updated on SEPTEMBER 26, 2019

Applies to:

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


When a Recruiter Selects "Add Application" and Saves the Entry No Row is Created in HRS_RCMNT table

When recruiter selects "Add Application" and saves a row it should be saved in HRS_RCMNT.

The issue can be reproduced at will with the following steps:
1. Navigate to Recruiting > Add New Applicant and create a new Applicant.
If we run the above SQL statement for the new applicant, there is one row created for both the tables, with profile seq = 1, and hrs_job_opening_id = 0
select * from PS_HRS_APP_PROFILE where HRS_PERSON_ID = xxxxx;
select * from PS_HRS_RCMNT where HRS_PERSON_ID = xxxxx;
This is working as expected.

2. Navigate to Recruiting > Find Applicants and enter the applicant id and in the Add Applicant Page, select the link "Manage Applicant Activity", and there you can see the recruitment entry.

3.Now click on Add Application hyperlink.
we will be redirected to the page "Application Details" - on that page, fill some of the fields, such as resume text, preferences... But DO NOT select a job opening and then select "Save and submit"

4. The new profile created is visible in the application grid.

5. If we run the same 2 SQL statements as in step 1
HRS_APP_PROFILE contains one new row with profile sequence = 2
But HRS_RCMNT has no new row created (The system should follow the same logic as for the "Add Applicant", and therefore a row should be created also in HRS_RCMNT with job opening id =0. If the user did not selects any job opening ID when creating the application details).




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.