1 Reply Latest reply: Jan 17, 2013 10:37 AM by Hussein Sawwan-Oracle RSS

    Error encountered while applying 12.1.1 patch. ORA-01422: exact fetch retur

    960341
      While applying 6678700 patch, one of the worker failed with the below error.

      FNDLOAD APPS/***** 0 Y UPLOAD @ALR:patch/115/import/alr.lct @ALR:patch/115/import/US/ad_alert.ldt - Failed


      Uploading from the data file /u01/app/oracle/R12/apps/apps_st/appl/alr/12.0.0/patch/115/import/US/ad_alert.ldt
      Altering database NLS_LANGUAGE environment to AMERICAN
      Dumping from LCT/LDT files (/u01/app/oracle/R12/apps/apps_st/appl/alr/12.0.0/patch/115/import/alr.lct, /u01/app/oracle/R12/apps/apps_st/appl/alr/12.0.0/patch/115/import/US/ad_alert.ldt) to staging

      tables
      Dumping LCT file /u01/app/oracle/R12/apps/apps_st/appl/alr/12.0.0/patch/115/import/alr.lct into FND_SEED_STAGE_CONFIG
      Dumping LDT file /u01/app/oracle/R12/apps/apps_st/appl/alr/12.0.0/patch/115/import/US/ad_alert.ldt into FND_SEED_STAGE_ENTITY
      Dumped the batch (ALR_ALERTS AD Indexes near maximum extents , ALR_ALERT_INSTALLATIONS APPS ) into FND_SEED_STAGE_ENTITY
      Uploading from staging tables
      Error loading seed data for ALR_ACTION_SET_MEMBERS: APPLICATION_SHORT_NAME = AD, ALERT_NAME = Tables near maximum extents, NAME = Messages to DBA,
      ORA-01422: exact fetch returns more than requested number of rows

      - Any idea how I can workaround the above error.

      regards,
        • 1. Re: Error encountered while applying 12.1.1 patch. ORA-01422: exact fetch retur
          Hussein Sawwan-Oracle
          957338 wrote:
          While applying 6678700 patch, one of the worker failed with the below error.

          FNDLOAD APPS/***** 0 Y UPLOAD @ALR:patch/115/import/alr.lct @ALR:patch/115/import/US/ad_alert.ldt - Failed


          Uploading from the data file /u01/app/oracle/R12/apps/apps_st/appl/alr/12.0.0/patch/115/import/US/ad_alert.ldt
          Altering database NLS_LANGUAGE environment to AMERICAN
          Dumping from LCT/LDT files (/u01/app/oracle/R12/apps/apps_st/appl/alr/12.0.0/patch/115/import/alr.lct, /u01/app/oracle/R12/apps/apps_st/appl/alr/12.0.0/patch/115/import/US/ad_alert.ldt) to staging

          tables
          Dumping LCT file /u01/app/oracle/R12/apps/apps_st/appl/alr/12.0.0/patch/115/import/alr.lct into FND_SEED_STAGE_CONFIG
          Dumping LDT file /u01/app/oracle/R12/apps/apps_st/appl/alr/12.0.0/patch/115/import/US/ad_alert.ldt into FND_SEED_STAGE_ENTITY
          Dumped the batch (ALR_ALERTS AD Indexes near maximum extents , ALR_ALERT_INSTALLATIONS APPS ) into FND_SEED_STAGE_ENTITY
          Uploading from staging tables
          Error loading seed data for ALR_ACTION_SET_MEMBERS: APPLICATION_SHORT_NAME = AD, ALERT_NAME = Tables near maximum extents, NAME = Messages to DBA,
          ORA-01422: exact fetch returns more than requested number of rows

          - Any idea how I can workaround the above error.

          regards,
          Please see if any of the solutions in these docs help.

          jtfumxusr.ldt Failed While Applying Patch 3480000 [ID 549956.1]
          Error Loading Seed Data For Xnp_callback_events: Msg_code = Xdp_fulfill_start, [ID 956771.1]

          If not, please log a SR.

          Thanks,
          Hussein