This discussion is archived
1 Reply Latest reply: Sep 14, 2012 12:32 PM by Hussein Sawwan-Oracle RSS

upgrade 11.5.10.2 to 12..1.1

user1354 Newbie
Currently Being Moderated
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 Employee ACE
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points