Friday, September 14, 2012

How To Resolve RLM Invalids R12.1.3 upgrade



          How To Resolve RLM Invalids

On 12.1.3 need to resolve the following invalid objects:
RLM_EXTINTERFACE_SV
RLM_RD_SV
RLM_MANAGE_DEMAND_SV

Fix

Please run the following for the 3 RLM invalid objects:
SQL>
RLM_MANAGE_DEMAND_SV PACKAGE
RLM_RD_SV PACKAG BODY
RLM_EXTINTERFACE_SV PACKAGE BODY

select object_name,object_type from from dba_objects
where object_name ='RLM_MANAGE_DEMAND_SV';

alter package RLM_MANAGE_DEMAND_SV compile;

select object_name,object_type from from dba_objects
where object_name ='RLM_RD_SV PACKAG';

alter package RLM_RD_SV;

select object_name,object_type from from dba_objects
where object_name ='RLM_EXTINTERFACE_SV PACKAGE';

alter package RLM_EXTINTERFACE_SV PACKAGE compile;


No comments:

Post a Comment