My Oracle Support Banner

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
Department= DEPTID1
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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.