Information requested on Editionable Objects

[satish]

Hi Erman,

Need your help in understanding what is the new and changed values under status column in below data and when they come into picture

===========================================================================
=     Differences between RUN and PATCH edition (Editionable Objects)
===========================================================================
 
 
 
 
Owner                          Object_Name                         Object_Type          Status  InValid?
------------------------------ ----------------------------------- -------------------- ------- ---------
APPS                           FND_CONCURRENT_WORKER_REQUESTS      VIEW                 CHANGED
APPS                           MTL_PARAMETERS_DFV                  VIEW                 CHANGED
APPS                           MTL_SYSTEM_ITEMS_B_DFV              VIEW                 CHANGED
APPS                           PN_LOCATIONS_ALL_DFV                VIEW                 CHANGED
APPS                           PN_PROPERTIES_ALL_DFV               VIEW                 CHANGED
APPS                           XXTAR_AP_TELEPHONE_INT_PKG          PACKAGE BODY         CHANGED
APPS                           XXTAR_AP_TELEPHONE_INT_PKG          PACKAGE              CHANGED
APPS                           XXTAR_INVITEM_UPDATE_PKG            PACKAGE BODY         CHANGED
APPS                           XXTAR_PN_LOCATIONS_INT_PKG          PACKAGE              CHANGED
APPS                           XXTAR_PN_LOCATION_STG_TBL           SYNONYM              CHANGED
APPS                           ADOP_VALID_NODES+                   TRIGGER              NEW
APPS                           ADOP_VALID_NODES=                   FUNCTION             NEW
APPS                           XLA_GLT_30002                       SYNONYM              NEW
APPS                           XLA_GLT_30003                       SYNONYM              NEW
APPS                           XLA_GLT_31002                       SYNONYM              NEW
APPS                           FND_PROFILE_OPTION_VALUES+          TRIGGER              NEW
APPS                           FND_PROFILE_OPTION_VALUES=          FUNCTION             NEW
APPS                           IBY_BEPINFO+                        TRIGGER              NEW
APPS                           IBY_BEPINFO=                        FUNCTION             NEW
APPS                           MTL_MATERIAL_TRANSACTIONS_DFV       VIEW                 NEW
APPS                           OZF_EARNING_SUMMARY_MV#             VIEW                 NEW
 
Thanks

[ErmanArslansOracleBlog]

Easy to guess.
New is new :) changed is changed.

What you sent to me is actually the output of ADZDCMPED.sql .This script is used to display the differences between the run and patch editions, including new and changed objects.

It gets that info from sys.obj$ and dba_objects_ae

So, the script check to see if the object is in dba_objects_ae already. (at the time of the script execution) If it is not there , it is considered as new, if it is already there it is considered as changed.

[Sri]

Hi erman,

Is this script executed as part of adop or how this script is useful for us,i mean under scenarios

Thank you

[ErmanArslansOracleBlog]

This script is used by adop.
A command like the following will produce it:

adop -status -detail

It basically shows you the changed objects.

Oracle Support :

You can run the adop -status command. This will display information that includes phases completed and the time taken. If you want additional details of operations performed, you can run the adop -status -detail command.