Fluid Position Management Activity Guide Hangs When Specifying a Department Number Not Returned By the Department Security Search PS_DEPT_SEC_SRCH
(Doc ID 2643672.1)
Last updated on MARCH 10, 2020
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Fluid Position Management is allowing the user to start Step 1 of the Activity Guide by entering a Department that is not returned by the Department Security Search PS_DEPT_SEC_SRCH.
Then when it comes to creating the Position, the code can't complete the process and doesn't insert the row into POSITION_DATA.
The Position Management Activity Guide hangs and nothing proceeds.
No Error message is returned.
The issue can be reproduced at will with the following steps:
1. Confirm dept value that will be used is not returned by the dept_sec_srch
A list of invalid DEPTIDs is returned from by running the following query:
select DEPTID from ps_dept_tbl
where deptid not in (select distinct deptid from ps_dept_sec_srch)
order by DEPTID
2. Login as PeopleSoft Administrator, with Workforce Admin Homepage Role, HR Administrator Role, HCCPHRFL3100 PL assigned to the HR Administrator role
3. Go to Workforce Admin Homepage > Position Management Tile > Manage Position > View Manage/Create > click the + sign > Create Position > Continue >
using defaults except for:
Jobcode = JOBCODE1
Click Next until Submit -- got a prompt 'Submit -- Yes No' > select Yes > page does not advance
The error appearing in the trace at the point of hanging is:
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