1 Reply Latest reply on Oct 3, 2019 4:29 PM by mdtaylor

    FAILED: file jtfdiagresp.ldt while applying RPC5 patches

    user8977605

      while applying RPC5 patches on EBS R12.1.3, failed with below Error. please let us know how can we fix this.

       

      adpatch log :

      =========

      Worker  Code      Context            Filename                    Status

      ------  --------  -----------------  --------------------------  --------------

           1  Run       AutoPatch R120     jtfdiagresp.ldt             FAILED

       

      ATTENTION: All workers either have failed or are waiting:

                 FAILED: file jtfdiagresp.ldt on worker  1.

       

      adwork001.log :

      =================

      Loading data using  FNDLOAD function.

      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: /u01/oracle/apps/apps_st/appl/admin/FINUPG/log/US_jtfdiagresp_ldt.log

      Error calling FNDLOAD function.

       

      US_jtfdiagresp_ldt.log

      ==========================

      Uploading from the data file /user4/oracle/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 (/user4/oracle/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afscursp.lct(120.4.12010000.12), /user4/oracle/apps/apps_st/appl/jtf/12.0.0/patc

      h/115/import/US/jtfdiagresp.ldt) to staging tables

      Dumping LCT file /user4/oracle/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afscursp.lct(120.4.12010000.12) into FND_SEED_STAGE_CONFIG

      Dumping LDT file /user4/oracle/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 foun

      d for this record.

      Value DIAG_TOOL_MENU for column MENU_NAME does not exist in table FND_MENUS_VL.