Patch 21900901 Fails On FNDLOAD Workers (Doc ID 2194375.1)

Last updated on DECEMBER 03, 2019

Applies to:

Symptoms

On : 12.2.6 version, Patch Application Issues

When attempting to apply patch 21900901 'ORACLE E-BUSINESS SUITE 12.2.6 RELEASE UPDATE PACK',
the following error occurs.


1.

-- Log File --

FileName
------------

adworker.log

FileComment
-----------------

Loading data using FNDLOAD function.
**** Reseting package states in the current session ****

FNDLOAD APPS/***** 0 Y UPLOAD @FND:patch/115/import/afcpprog.lct @ASG:patch/115/import/US/asgprg.ldt -

Calling FNDLOAD function.

Returned from FNDLOAD function.

Log file: /<install_location>fs_ne/EBSapps/log/adop/6/apply_20161011_100344//21900901/log/US_asgprg_ldt.log
Error calling FNDLOAD function.

2.

-- Log File --

FileName
------------

ldt log diles:

FileComment
-----------------

ERROR
-----------------------
Uploading from the data file <install_location> /EBSapps/appl/ap/12.0.0/patch/115/import/US/ap12avs.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/u01/app/apptpand/product/fs2/EBSapps/appl/fnd/12.0.0/patch/115/import/afffload.lct(120.19.12020000.6), <install_location> /EBSapps/appl/ap/12.0.0/patch/115/import/US/ap12avs.ldt) to staging tables
Dumping LCT file <install_location> /EBSapps/appl/fnd/12.0.0/patch/115/import/afffload.lct(120.19.12020000.6) into FND_SEED_STAGE_CONFIG
Dumping LDT file <install_location> /EBSapps/appl/ap/12.0.0/patch/115/import/US/ap12avs.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (VALUE_SET AP_SRS_JOURNAL_BATCH_ID , VALUE_SET AP_SRS_BANK_ACCT_NUM_ID ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
Error loading seed data for VSET_VALUE: FLEX_VALUE_SET_NAME = APXAPRST_SORT_BY, PARENT_FLEX_VALUE_LOW = , FLEX_VALUE = Approver, 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.

----- Error Message Stack -----
ORA-20001: LDR.up_value_set()(BEGIN, AP_SRS_BATCH_NAME) raised exception.
ORA-20001: start_transaction(VALUE_SET) raised exception.
ORA-06512: at "APPS.FND_FLEX_LOADER_APIS", line 475
ORA-06512: at "APPS.FND_FLEX_LOADER_APIS", line 601
ORA-06512: at "APPS.FND_FLEX_LOADER_APIS", line 800
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.

3.

When trying to run the following as per Doc ID 2146645.1 ;

exec AD_ZD_SEED.UPGRADE('FND_FLEX_VALUE_NORM_HIERARCHY');
exec AD_ZD_SEED.UPGRADE('FND_COMPILED_DESCRIPTIVE_FLEXS');
commit;

the following error occurred:

ORA-20001: Cannot upgrade existing table from Patch Edition:

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. attempt to apply patch 21900901 'ORACLE E-BUSINESS SUITE 12.2.6 RELEASE UPDATE PACK'.

Cause

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