Patch 25322478:R12.PO.D Install Fails With Error ORA-20001: Finish_transaction(DESC_FLEX) Raised Ex (Doc ID 2291480.1)

Last updated on AUGUST 04, 2017

Applies to:

Oracle Applications DBA - Version 12.2.4 and later
Information 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
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms