Error ORA-04063 on CLE_F126_IPV_PROTOCOL_PKG while Updating an Invoice in the Workbench (Doc ID 2115358.1)

Last updated on MARCH 11, 2016

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
The User complained that they can not update AP Invoices.

Symptoms

Cannot update invoices in AP system due to the following error.

  APP-SQLAP-10000: ORA-04063: package body "APPS.CLE_F126_IPV_PROTOCOL_PKG" has errors
  ORA-06508: PL/SQL: could not find program unit being called: "APPS.CLE_F126_IPV_PROTOCOL_PKG"
  ORA-06512: at "APPS.CLE_F126_AP_INVOICES_AIUR1", line 2
  ORA-04088: error during execution of trigger 'APPS.CLE_F126_AP_INVOICES_AIUR1' occurred in
  AP_AI_TABLE_HANDLER_PKG.UPDATE_ROW<-AP_INVOICES_PKG.UPDATE_ROW<-APXINWKB
  with parameters (p_Rowid = AAAUymABMAAPsGvAAI, p_invoice_id = 5398678)
  while performing the following operation:Update ap_invoices

Attempting to recompile the CLE_F126_IPV_PROTOCOL_PKG object shows the following error:

  PL/SQL: ORA-00942: table or view does not exist

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms