compile invalid objects

[Roshan]

Hello Erman,

I have compiled invalid objects using adadmin. When I am querying:
select * from dba_objects
where status='INVALID'
and object_name like 'INL%';

output.xls
I am getting the above invalid object. I am recompiling manually
alter package <owner>.<name of the package> compile;
alter package <owner>.<name of the package> compile body;

Completing with errors.

[ErmanArslansOracleBlog]

Read this Document for throubleshooting;

Troubleshooting Guide - invalid objects in the E-Business Suite Environment 11i and 12 (Doc ID 1325394.1)

For java classes you should use;

SQL> ALTER JAVA SOURCE <OWNER>.<Java Source> COMPILE;

SQL> ALTER JAVA CLASS <OWNER>.<Java Class> RESOLVE;

Read the document as suggested...

2016-05-25 12:35 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>:

Hello Erman,

I have compiled invalid objects using adadmin. When I am querying:
select * from dba_objects
where status='INVALID'
and object_name like 'INL%';

output.htm

I am getting the above invalid object. I am recompiling manually
alter package <owner>.<name of the package> compile;
alter package <owner>.<name of the package> compile body;

Completing with errors.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/compile-invalid-objects-tp1018.html

To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--

[Roshan]

Thanks :)