My Oracle Support Banner

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

Last updated on JUNE 01, 2020

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
GLNSVI

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

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
Cause
Solution
References


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