EBS Customizations (MOSC)

MOSC Banner

Finding out custom objects, custom reports and custom alerts

edited Jul 3, 2014 5:00AM in EBS Customizations (MOSC) 6 commentsAnswered

Hello All,

I am working on an upgrade project. Part of a preliminary process involves listing out custom objects, custom reports as well as custom alerts. I have ran the below query.

Select * from all_objects where where object_name like 'XX%'; because we generally name the custom object in such a way that the initial 2 letters are XX.

But what if someone has created a custom table and he/she has not followed the above mentioned naming convention?

So is there any other way to find out which objects from the table all_objects are custom objects?

Thanks

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