1 Reply Latest reply: Dec 5, 2012 2:45 PM by Hussein Sawwan-Oracle RSS

    Error while applying the  R12.PJ_PF.B.DELTA.5

    Sivamani
      Hi,

      The patch session failed when it was running pablu.ldt

      FAILED: file pablu.ldt on worker 1 for product pa username APPS.
      FAILED: file b9281321lu.ldt on worker 2 for product pn username APPS


      And the log /ebs/DEV/app/apps/apps_st/appl/admin/DEV/log/US_pablu_ldt.log says:-

      Uploading from the data file /ebs/DEV/app/apps/apps_st/appl/pa/12.0.0/patch/115/import/US/pablu.ldt
      Altering database NLS_LANGUAGE environment to AMERICAN
      Dumping from LCT/LDT files (/ebs/DEV/app/apps/apps_st/appl/fnd/12.0.0/patch/115/import/aflvmlu.lct(120.0.12010000.1), /ebs/DEV/app/apps/apps_st/appl/pa/12.0.0/patch/115/import/US/pablu.ldt) to staging tables
      Dumping LCT file /ebs/DEV/app/apps/apps_st/appl/fnd/12.0.0/patch/115/import/aflvmlu.lct(120.0.12010000.1) into FND_SEED_STAGE_CONFIG
      Dumping LDT file /ebs/DEV/app/apps/apps_st/appl/pa/12.0.0/patch/115/import/US/pablu.ldt into FND_SEED_STAGE_ENTITY
      The value cannot be uploaded without a prepare statement
      The value cannot be uploaded without a prepare statement
      Dumped the batch (FND_LOOKUP_TYPE PA FC_RESULT_CODE , FND_LOOKUP_VALUE PA_AA_FAIL ) into FND_SEED_STAGE_ENTITY
      Uploading from staging tables
      A database error occurred:
      ORA-06550: line 1, column 27:
      PLS-00201: identifier 'AD_ZD_SEED.MODE_FNDLOAD' must be declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored

      ---------------------------------------------------------------------------------------------------------------------------------------------------------------
      EBS - 12.1.3
      db version- 11.2.0.2

      Can any one help me

      Thanks

      Edited by: Sivamani on Dec 5, 2012 12:32 PM