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
Program - Inherit Segment Value Attributes runs in 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.
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
New setup in place using table-based valueset relying on a custom editionable view under custom schema.
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