Error When 'Save And Submitting' A New TAM Job In Draft Status When The Approval Flags Are Set. (Doc ID 2085232.1)

Last updated on DECEMBER 03, 2015

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

Error when 'Save and Submitting' a new TAM job in draft status when the approval flags are set.

User gets an error when submitting a new job in draft status (TAM) when the approval flags are on in the Recruiting Installation table. Researched and reset all the workflow counters and still get the error below. If the approval process is turned off the job can be saved and the job status sets to 'Open' successfully.


During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed.

ERROR
-----------------------
SQL error in Exec. (2,280) EOAW_CORE.NotificationEventHandler.OnExecute Name:updateSummaryDetails PCPC:218791 Statement:2476
Called from:EOAW_CORE.NotificationEventHandler.OnExecute Name:ProcessNotifications Statement:1420
Called from:EOAW_CORE.ENGINE.AppInst.OnExecute Name:Launch Statement:21
Called from:EOAW_CORE.LaunchManager.OnExecute Name:DoSubmit Statement:33
Called from:HRS_AWE.WRAPPERS.LaunchManager.OnExecute Name:DoSubmit Statement:9
Called from:HRS_JOB_OPENING_MANAGER.OBJ_HRS_JOB_O





STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Main Menu > Set Up HCM > Install > Product Specific > Recruiting Installation.
2. Click on Standard Requisition under the Approval Required section and SAVE.
3. Navigate to Main Menu > Recruiting > Create Job Opening.
4. Make sure the new Job Opening Type is Standard Requisition.
5. Here are the job details from the DEMO test data:
Job Opening ID NEW Status 005 Draft
Job Posting Title Sr Payroll Clerk Business Unit GBIBU (Global Business Institute BU)
Job Code 290080 (Clerk-Payroll Sr) Department 13000 (Finance and Administration)
Position Number 19000026 (Sr Payroll Clerk) Job Family KCLERK (Clerical)
Primary Recruiting Location 35 (Delaware Operations)
6.Populate the required fields from your delivered drop down values > Press the Continue button. Finish entering delivered job data on the next pages, for example the Hiring Team and the Job Posting tabs.
7. Press the Save and Submit button, first fatal sql error box comes up,

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot save Job Opening in Draft status.

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