Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

APPS.MSC_ATP_PUB package is invalid.

edited Jun 4, 2013 7:30PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered
 HI,

Welcome to Patching community !!!


Issue:

- We have recently applied patch – 14351003 and since then we are noticing few problems related to Sales Order Processing.
- Comparing with another instance there are few invalid MSC objects in the instance and one of the standard object - APPS.MSC_ATP_PUB – Seems to be contributing to this issue.
- Standard Compilation is not working for this object:
- Errors below:

SQL> alter package APPS.MSC_ATP_PUB compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY APPS.MSC_ATP_PUB:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2953/9   PL/SQL: SQL Statement ignored
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center