Posting Duration Is Populated In DB As 0 (HRS_JO_PST_LENGTH)

(Doc ID 2259820.1)

Last updated on APRIL 27, 2017

Applies to:

PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Manage Job Openings

ACTUAL BEHAVIOR
---------------
Posting Duration is populated in DB as 0 (HRS_JO_PST_LENGTH)

In the Manage job opening page, under job posting there is an issue with posting duration population in database.

Table - PS_HRS_JO_PS_DST, Field - HRS_JO_PST_LENGTH

When Post Date and Remove Date are entered, automatically Posting duration is shown on page but after saving component, this value is not populated (populated as 0) in database.
 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Case 1
Navigate to Manage Job Opening

Select Posting under Job Postings sub tab

Here in the below screenshot you can see that there 262 value under posting duration –

This value is getting populated as 0 in database.

Case 2
if you blank out Remove date, then posting duration gets enabled

Enter duration date, then you will see Remove date automatically populated- this case posting duration is getting saved.

Case 3
Now remove posting duration then Remove date will be enabled

Then change the Remove date then Posting duration gets automatically but after saving the component posting duration will be 0.

Cases when enter Post date and Remove date Posting duration being calculated but its not updated in database with duration value.

SELECT * FROM PS_HRS_JO_PST_DST WHERE HRS_JOB_OPENING_ID='XXXXXX'

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use properly the application.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms