Multiple Objects got invalid Due unknown reason some package body got invalid.
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