HCM 9.2: Fluid Position Management Allowing New Position Reporting to Denied Position and Error in Prompt: "Variable contains a reference to a rowset object that has been deleted. NUI_PROMPT.Prompt.OnExecute" (Doc ID 3016730.1)

Last updated on APRIL 16, 2024

Applies to:

Symptoms

Scenario 1:

Fluid Position Management allows a new position to be created that reports to a position that was previously denied.

When this happens, the new position gets created, but it does not write to the position_data table as it encounters a Component Interface issue due to the invalid reports to position.

When trying to use this new position, it cannot be used in job data because it only exists on position_data_e, but not on position_data Record.

Steps to replicate the issue:
Prerequisite for testing: Set Up HCM > Install > Product Specific > Position Data Installation > Position Management Installation : Ensure approvals are enabled for position management.
1. Navigate to Workforce Administration > Position Management > Manage Position: Create a new Position A
2. Login as the Approver: Manager Self Service Fluid Homepage > Approvals Tile: Deny Position A
3. Navigate to Workforce Administration > Position Management > Manage Position: Create a new Position B and add Position A at Report To

Scenario 2:

A peoplecode hard error is being encountered in Fluid Position Data when performing more than 2 levels prompt searching:

Steps to replicate the issue:

1. Open any position
Navigation: Workforce Administrator Fluid home page > Position Management >Manage Position
2. Add a new row
3. Click Reports To prompt
4. Click Reports To Position Number prompt
5. Click Department prompt
6. Click Clear
7. Click Cancel
8. Click Clear
9. Click Cancel
10. Click Clear
11. Above error is displayed

Cause

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