Invalid Object "APPS.OE_HOLDS_PUB"

(Doc ID 2411066.1)

Last updated on JUNE 18, 2018

Applies to:

Oracle Order Management - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Problem Statement
During upgrade instance from version 11.5.10.2 to R12.2.6, by referring Oracle E-Business Suite Upgrade Guide Release 11i to 12.2 Part Number E87011-01
https://docs.oracle.com/cd/E26401_01/doc.122/e87011/T660854T660862.htm#T660989
After performed step:"9.Apply AD 12.2 upgrade driver (required)", PACKAGE BODY "APPS.OE_HOLDS_PUB" becomes Invalid.
When compile the package manually, the following error appears:

Error

-------------------
3903/8 PL/SQL: Statement ignored
3903/37 PLS-00306: wrong number or types of arguments in call to '='

Steps to Reproduce

  1. Compile the Invalid object manually

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