1 Reply Latest reply: Sep 14, 2012 2:32 PM by Hussein Sawwan-Oracle RSS

    upgrade 11.5.10.2 to 12..1.1

    user12094010
      Hussein.

      I am applying u6678700.drv on apps tier, some of the objects not found and the workers are waiting for fix

      View Name is AP_PAYMENT_EXTRACT_HEADER_V
      View does not exist in the target database
      Executing create Statement
      Create Statement is
      applying 12.0.0/patch/115/xdf/ap_payment_extract_header_v.xdf

      applying 12.0.0/patch/115/xdf/ap_payment_extract_header_v.xdf
      View Name is AP_PREPAYAPP_EXTRACT_DETAILS_V
      View does not exist in the target database
      Executing create Statement
      Create Statement is

      applying ap_invoice_extract_details_v.xdf
      ================================================================================

      View Name is AP_INVOICE_EXTRACT_DETAILS_V
      View does not exist in the target database
      Executing create Statement
      Create Statement is

      FAILED: file MSDODPCODE.sql

      I could not find objects in the database.

      do you have any idea? Please advice.

      Thanks
      Prince
        • 1. Re: upgrade 11.5.10.2 to 12..1.1
          Hussein Sawwan-Oracle
          Hi Prince,
          View Name is AP_PAYMENT_EXTRACT_HEADER_V
          View does not exist in the target database
          What does this query return?
          SQL>  select owner, object_type, status
           from dba_objects
           where object_name = 'AP_INVOICE_EXTRACT_DETAILS_V';
          do you have any idea? Please advice.
          Yes, if the view is not there you can create it by referring to these docs/links -- Run $AP_TOP/patch/115/xdf/ap_invoice_extract_details_v.xdf

          INVENTORY AP ACCRUAL NOT CLEARED IN REPORTING LEDGER [ID 983192.1]
          Error 95335 Generated by Create Accounting - An Encumbrance Type Is Required [ID 866406.1]
          http://etrm.oracle.com/pls/et1211d9/etrm_pnav.show_object?c_name=AP_INVOICE_EXTRACT_DETAILS_V&c_owner=APPS&c_type=VIEW

          Thanks,
          Hussein