Package Body WMS_ATF_RUNTIME_PUB_APIS Is INVALID After Upgrading EBS From 12.1.3 To 12.2.4 (Doc ID 1983354.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Warehouse Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Install


After completing upgrade from R12.1.3+ to R12.2.4 using document "Oracle E-Business Suite Upgrade Guide Release 12.0 and 12.1 to 12.2 Part No. E48839-09" and
applying all Recommended Patches from OAM Patch Wizard, the following objects are showing as invalid.
 
Object Type: package body
Object name: WMS_ATF_RUNTIME_PUB_APIS
Status: INVALID

When attempting to manually recompile the package , the following error occurs

ERROR
-----------------------
SQL> @WMSATFRB.pls

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY WMS_ATF_RUNTIME_PUB_APIS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2006/19 PL/SQL: Statement ignored
2006/43 PLS-00302: component 'INSERT_DISPATCHED_TASKS_NAUTO' must be  declared
2144/17 PL/SQL: Statement ignored
2144/41 PLS-00302: component 'INSERT_DISPATCHED_TASKS_NAUTO' must be  declared


How to resolve this Invalid ?

File Versions
============

$Header: WMSATFRS.pls 120.2.12020000.1 2012/06/26 08:24:30 appldev ship $*/
$Header: WMSATFRB.pls 120.22.12020000.2 2012/09/22 12:20:32 ssrikaku ship $*/


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade upgrade from R12.1.3+ to R12.2.4
2. Find the package WMS_ATF_RUNTIME_PUB_APIS is invalid


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot recompile the invalid.

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