R12.2 Apps DBA. Powered by Blogger.

Adop Prepare Fails With Error 'ORA-06512: at "APPS.FND_PRINTER_TL+", line 1' When Running afadmprf.sh During Autoconfig (Doc ID 2002605.1)

No comments :
SYMPTOMS
On : 12.2.4 version, the adop phase=prepare failed when executing adconfig.sh. The error message is as below
  [STATEMENT] Sourcing the Run Edition environment: /u02/oracleEBS/xxx/fs1/EBSapps/appl/APPSxxx_r12vision.env
  [PROCEDURE] [END   2015/03/17 19:24:44] Preparing seed data tables
  [EVENT]     [START 2015/03/17 19:24:44] Running AutoConfig
  [UNEXPECTED]Error occurred while executing "sh /u02/oracleEBS/xxx/fs1/EBSapps/appl/ad/12.0.0/bin/adconfig.sh contextfile=/u02/oracleEBS/xxx/fs2/inst/apps/xxx_r12vision/appl/admin/xxx_r12vision.xml promptmsg=hide log=/u02/oracleEBS/xxx/fs_ne/EBSapps/log/adop/5/prepare_20150317_191450/xxx_r12vision/adconfig.log"
  [UNEXPECTED]Error while runPendingClone sub-routine is called
 In adonfig log file, there are below errors when executing the script afadmprf.sh
SQL*Plus: Release 10.1.0.5.0 - Production on Tue Mar 17 19:26:56 2015
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Enter value for 1: Enter value for 2: Enter value for 3: Connected.
define printer for reports ...
declare
*
ERROR at line 1:
ORA-20002: Seed Data Table has not been prepared for patching
ORA-06512: at "APPS.FND_PRINTER_TL+", line 1
ORA-04088: error during execution of trigger 'APPS.FND_PRINTER_TL+'
ORA-06512: at line 33
CAUSE
 Bug 20111545 - ADOP PHASE=PREPARE FAILS WITH ORA-20002: SEED DATA TABLE HAS NOT
SOLUTION
Please execute the following from PATCH file system.
connect as APPS/*** from PATCH File system
SQL> exec ad_zd_seed.prepare('FND_PRINTER_TL');
SQL> commit;
and now run adop prepare phase.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.