My Oracle Support Banner

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

Last updated on FEBRUARY 18, 2019

Applies to:

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


Problem Statement
During upgrade instance from version 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:


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


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

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