Job Posting to Career Site is Not Working when HTML Email Approval is Used for Approving Job Opening (Doc ID 2051872.1)

Last updated on JUNE 20, 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.

Symptoms

Job posting to career site is not working when HTML email approval is used for approving job opening

STEPS TO REPLICATE

Step 1: Created a job opening and it is pending for approval.(time-stamp : 19-MAY-15 02.19.00 AM)
now all the underlying tables will have data with created time stamp.
the view HRS_JO_BASE_VW which is used job posting SES will also have data with time-stamp 19-MAY-15 02.19.00 AM

Step 2: Incremental SES process (HC_HRS_JOB_POSTING) runs (this process will not pick our data even-though it falls within the time-stamp since status is pending for approval).
once this process is complete our data will never be considered by our incremental process unless there is change in time-stamp.

Step 3: Approver gives approval over mail around 19-MAY-15 2.35 AM

Step 4: HTML Email approval process(EOAWEMC) runs around 19-May-15 2.40 AM and updates the table with status approved but time-stamps are updated only in few tables.
Especially time stamp is not updated in the table (PS_HRS_JPST_TBL) , the view HRS_JO_BASE_VW used for SES feed is using this table PS_HRS_JPST_TBL.
Hence the status has been updated but time stamp was not updated.

So incremental SES process will never pick this transaction.

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