My Oracle Support Banner

Invalid Object "APPS.OE_HOLDS_PUB" (Doc ID 2411066.1)

Last updated on JANUARY 19, 2023

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
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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.