Job Posting to Career Site is Not Working when HTML Email Approval is Used for Approving Job Opening
Last updated on FEBRUARY 14, 2018
Applies to:PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms