Patch 25322478:R12.PO.D Install Fails With Error ORA-20001: Finish_transaction(DESC_FLEX) Raised Ex
(Doc ID 2291480.1)
Last updated on MAY 29, 2024
Applies to:
Oracle Applications DBA - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
Patch 25322478:R12.PO.D install fails with error ORA-20001: finish_transaction(DESC_FLEX) raised ex
Errors in worker log:
Error loading seed data for VSET_VALUE: FLEX_VALUE_SET_NAME = Document Type, PARENT_FLEX_VALUE_LOW = , FLEX_VALUE = Base Document, ORA-20001: Synonym does not point to a seed data table: FND_FLEX_VALUE_NORM_HIERARCHY
ORA-20000: Flex developer error. Loader should not start a new transaction while it is processing an existing transaction. Entity Name of existing transaction: VALUE_SET
ORA-20001: finish_transaction(DESC_FLEX) raised exception.
ORA-01086: savepoint 'SAVEPOINT_VALUE_SET' never established in this session or is invalid
ORA-20001: finish_transaction(DESC_FLEX) raised exception.
ORA-06512: at "APPS.FND_FLEX_LOADER_APIS", line 379
ORA-06512: at "APPS.FND_FLEX_LOADER_APIS", line 505
ORA-06512: at "APPS.FND_FLEX_LOADER_APIS", line 754
ORA-01086: savepoint 'SAVEPOINT_VALUE_SET' never established in this session or is invalid
Additional Errors recorded in the adzddbcc.lst:
ad.plsql.ad_zd_seed.prepare ERROR Synonym does not point to a seed data table: FND_FLEX_VALUE_NORM_HIERARCHY
ad.plsql.ad_zd_seed.prepare ERROR Synonym does not point to a seed data table: FND_FLEX_VALUE_NORM_HIERARCHY
Upgrade the table "FND_FLEX_VALUE_NORM_HIERARCH" using "EXEC AD_ZD_SEED.UPGRADE" is not allowed since patch edition exists.
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 |