ORA-22806: not an object or REF

[Gustavo]

I get this error whenever I try to Explain Plan for a DML within a trigger, when the statement references NEW or OLD values. Can this be optimized?

Select rt.organization_id, -- 02
       rit.invoice_type_id, -- 03
       nvl(rfea.vendor_site_id, rfea.ra_address_id) vendor_site_id, -- 04
       ooh.header_id, -- 06
       ool.line_id, -- 07
       ool.unit_selling_price, -- 08
       rt.transaction_date, -- 10
       ri.invoice_num
From   oe_order_lines_all      ool,
       oe_order_headers_all    ooh,
       rec_fiscal_entities_all rfea,
       rec_invoice_types       rit,
       rec_invoices            ri,
       rcv_shipment_headers    rsh,
       rcv_shipment_lines      rsl,
       rcv_transactions        rt
Where  ool.line_id(+) = rt.oe_order_line_id
And    ooh.header_id(+) = rt.oe_order_header_id
And    rit.invoice_type_id = ri.invoice_type_id
And    rit.attribute4 = 'SIM'
And    rfea.entity_id = ri.entity_id
And    rfea.entity_type_lookup_code In ('VENDOR_SITE', 'CUSTOMER_SITE')
And    ri.organization_id = :New.organization_id
And    ri.operation_id = apps.nxt_fnd_invalid_number(rsh.receipt_num)
And    rsh.shipment_header_id = rsl.shipment_header_id
And    rsl.shipment_line_id = rt.shipment_line_id
And    rt.transaction_id = :New.rcv_transaction_id

Regards,
Gustavo

 

[Marco Kalter]

Good point. We should replace the :new.column and ld.column expressions by :new_column and ld_column. I have added this to the list of enhancement requests.

At the moment you need to do this manually in the Explain Plan Window.

 

[Gustavo]

Thx, this replacement will help a lot!