Thursday, March 11, 2010

Upgrading to R12.1.2, Tip #1

While applying patch 7303033 on top of a 12.1.0 R12 installation, I got the following error in one of my workers:

FNDLOAD APPS/***** 0 Y UPLOAD @FND:patch/115/import/afscursp.lct @JTF:patch/115/import/US/jtfdiagresp.ldt -

Connecting to APPS......Connected successfully.

Calling FNDLOAD function.

Returned from FNDLOAD function.

Log file: /r12u/apps/apps_st/appl/admin/UPG/log/US_jtfdiagresp_ldt.log
Error calling FNDLOAD function.

Time when worker failed: Thu Mar 11 2010 13:45:18

The log from my worker showed:

Current system time is Thu Mar 11 13:45:16 2010


Uploading from the data file /r12u/apps/apps_st/appl/jtf/12.0.0/patch/115/import/US/jtfdiagresp.ldt
Altering database NLS_LANGUAGE environment to AMERICAN
Dumping from LCT/LDT files (/r12u/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afscursp.lct(120.4.12010000.2), /r12u/apps/apps_st/appl/jtf/12.0.0/patch/115/import/US/jtfdiagresp.ldt) to staging tables
Dumping LCT file /r12u/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afscursp.lct(120.4.12010000.2) into FND_SEED_STAGE_CONFIG
Dumping LDT file /r12u/apps/apps_st/appl/jtf/12.0.0/patch/115/import/US/jtfdiagresp.ldt into FND_SEED_STAGE_ENTITY
Dumped the batch (FND_APPLICATION JTF , FND_RESPONSIBILITY JTF DIAG_TOOL_RESP ) into FND_SEED_STAGE_ENTITY
Uploading from staging tables
  Error loading seed data for FND_RESPONSIBILITY:  APPLICATION_SHORT_NAME = JTF, RESP_KEY = DIAG_TOOL_RESP,  ORA-20001: APP-FND-01572: Invalid foreign key data was found for this record.
Value DIAG_TOOL_MENU for column MENU_NAME does not exist in table FND_MENUS_VL.

Concurrent request completed
Current system time is Thu Mar 11 13:45:18 2010

I searched Metalink and didn't find an answer, so I created a TAR.  Oracle Support came back and said this was covered in unpublished note 1066653.1 which suggests you can safely skip this script.

If you are unfamiliar with skipping a step from a failed worker, you can go into adctrl and choose 8 (although there are only 7 menu choices).  That will ask you which worker you want to skip and restart.

No comments: