My Oracle Support Banner

Program - Inherit Segment Value Attributes Errors: ORA-14700: Object(s) owned by SYS cannot be locked by non-SYS user (Doc ID 2613357.1)

Last updated on NOVEMBER 26, 2019

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
GLNSVI: Program - Inherit Segment Value Attributes

Symptoms

Program - Inherit Segment Value Attributes runs in error:

ERROR
>> glnini() 24-JUL-2019 11:04:56
GSVI0006: GLNSVI cannot get an exclusive lock on [name]
PERF0005: Oracle error detected in glnini() - ORA-14700: Object(s) owned by SYS cannot be locked by non-SYS user
GSVI0004: The Segment Value Inheritance program terminated with fatal errors.


STEPS
The issue can be reproduced at will with the following steps:
1. Create an accounting flexfield with a table-based value set; this is under custom schema.
2. Create a synonym for APPS user to this view
2. Run 'Program - Inherit Segment Value Attributes'
3. Get the error

Changes

 New setup in place using table-based valueset relying on a custom editionable view under custom schema.

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
References


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