GLNSVI: ORA-01407: Cannot Update - PERF0005: Oracle Error Detected In Glnupd() (Doc ID 2653443.1)

Last updated on FEBRUARY 21, 2024

Applies to:

Symptoms

Running the program Inherit segment values results in error.

The following error is seen via the log file:
GLNSVI: Program - Inherit Segment Value Attributes

>> glnupd() 02-MAR-2020 17:58:40
PERF0005: Oracle error detected in glnupd() - ORA-01407: cannot update ("GL"."GL_SEGVAL_INHERIT_INT_6452"."DETAIL_PO

GSVI0004: The Segment Value Inheritance program terminated with fatal errors.

The following items were reviewed to determine the cause of this error:

1) Note: GLNSVI: PERF0005: Oracle Error Detected In Glnupd() - ORA-01407: Cannot Update (Doc ID 2620061.1)
This note speaks to:
Cause - Incorrect setup. View and select from Dual table used incorrectly in this setup.

2) Note: Program - Inherit Segment Value Attributes Errors: ORA-14700: Object(s) owned by SYS cannot be locked by non-SYS user (Doc ID 2613357.1)
This note speaks to:
Cause - Usage of 'DUAL' in the view. The owner of DUAL is SYS.

3) Note: ORA-1407 When Running The Inherit Segment Value Attributes Program - Scripts to troubleshoot (Doc ID 248842.1)
This note speaks to:
Cause - 
a) Verify that the segment values used in an account combination exists in a value set.
b) Verify that every segment value has a valid value for the detail posting allowed and detail budgeting allowed qualifiers.
c) Verify that every segment value in an independent value set does not have a parent segment value.
d) Verify that the columns PARENT_FLEX_VALUE_LOW and PARENT_FLEX_VALUE_HIGH are populated in FND_FLEX_VALUES table only in Independent/Dependent segment values relation, not in parent/child relationship.

4) Additional scripts that can be used to identify the the issue:
a) Run the program in debug and it will show the valueset at issue, to determine what values have the incorrect or missing attributes by running the following query:

 c) Verify missing values using uploaded queries provided in attached file - Segment Value Inheritance check script

Cause

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