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 MAY 11, 2023

Applies to:

Symptoms

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

Example:
DEPTID1

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
Regular
Department= DEPTID1
Company=COMPANY1
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:

Changes

Cause

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