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

MOSC Banner

Multiple Objects got invalid Due unknown reason some package body got invalid.

edited Jun 5, 2014 7:43AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓

Hi Team,

Customer having around 66 invalids, After Creating the procedure they encountered that lot of invalid objects are created in apps account.they created the procedure with object named  as "APPS";

Procedure:

" CREATE OR REPLACE procedure apps.pro_legacy_mr_create  (errbuff out varchar2,retcode out varchar2) as

cursor c1 is select * from XXPRAN_CUSTOMER_INT; "

So they completed all these mentioned action plan.

1. Use adadmin. From the Main AD Administration menu, go to the Maintain Applications Database Entities menu. Select the “Validate APPS schema" task.

It produces a report named <APPS schemaname>.lst that lists issues and potential issues

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