My Oracle Support Banner

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

Last updated on DECEMBER 19, 2019

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Generic (Platform Independent)
GLNSVI: Program - Inherit Segment Value Attributes

Symptoms

GLNSVI: Program - Inherit Segment Value Attributes errors,



ERROR:

SHRD0181: glnupd() - sqlstmtbuf(len) = 8488
PERF0005: Oracle error detected in glnupd() - ORA-01407: cannot update ("GL"."GL_SEGVAL_INHERIT_INT_87284"."DETAIL_P
GSVI0004: The Segment Value Inheritance program terminated with fatal errors.

...

glnini() - Retrieve last run date
glnini() - Check validation table
SHRD0181: glnini() - sqlstmtbuf =
SELECT 'bad_date'
FROM dual
WHERE EXISTS
(SELECT last_update_date
FROM XXPA.XXPA_PA_SEGMENT
WHERE last_update_date IS NULL)





STEPS:
The issue can be reproduced at will with the following steps:
1. GL Responsibilty:Run GLNSVI: Program - Inherit Segment Value Attributes
2. Observe error in the logfile

Changes

 New setup.

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.