My Oracle Support Banner

Mass Appraisal Creation Program Fails with Error ORA-20001: FLEX-NULL REQUIRED SEGMENT in the Log File (Doc ID 2996876.1)

Last updated on JANUARY 09, 2024

Applies to:

Oracle Performance Management - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms


When attempting to view the appraisals linked to performance management plan, observed that appraisals are not getting created on Appraisals page and score cards are not getting into status "Published" on Scorecard Status tab under Performance Management Plans page, even when the Appraisal Task Start Date is already reached in the system.

On further investigation observed that running Mass Appraisal Creation Program ends in error, with below error captured in the log file:

 

Error Message:
-------------------

"ORA-20001: FLEX-NULL REQUIRED SEGMENT"

 

 

Issue Reproduction Steps:
------------------------------

1. Login using "HR Professional V4.0" Responsibility.

2. Navigate to Function "Performance Management".

3. In the launched page, under the cluster "Administration" click on "Performance Management Plans" link.

4. In the launched page, query for the plan for which, plan task start date has been reached in the system and you want to see the monitor plan details.

5. From the search results returned, click on the monitor plan icon.

6. In the launched page, under the tab "Scorecard Status", query for scorecards based on any criteria and observe that status of score card is being shown as "Not Yet Started With Worker".

7. It was also observed that, under the tab "Appraisal Status", query for Appraisal scorecards based on any criteria and observe that count of appraisal creation is shown as "Zero".

8. On further investigation, observed that concurrent program "Mass Appraisal Program" ended up in error and when opened up the log file above error is captured in it.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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