3 Replies Latest reply on May 24, 2019 4:10 AM by Kanda-Oracle

    How To Find History of Package Modification

    Ramaraju

      Hi All,

      Is there any way to find the package modification history? Not only latest modified, required previous modifications.

      Like who was changed and which time?

       

      Thanks,

      Ramaraju

        • 1. Re: How To Find History of Package Modification
          John_K

          Not from the database - you should have that information in your source code control system.

          • 2. Re: How To Find History of Package Modification
            hal9000akilroy

            depend on your need of history : ad_files, ad_file_version, all_objects

             

            exemple:

            select f.FILE_ID,

                   f.APP_SHORT_NAME "TOP",

                   f.SUBDIR,

                   f.FILENAME,

                   v.file_version_id,

                   v.VERSION,

                   v.creation_date,

                   v.last_update_date,

                   fu.USER_NAME "Updated By"

              from ad_files f, ad_file_versions v, fnd_user fu

            where f.FILE_ID = v.FILE_ID

            and f.FILENAME like 'AppsLocalLogin.jsp'

               and fu.user_id = v.LAST_UPDATED_BY

            order by v.last_update_date desc ;

             

            select o.OWNER, o.OWNER, o.CREATED,o.LAST_DDL_TIME,o.TIMESTAMP, o.status, v.TEXT_LENGTH, v.text

            from all_views v, all_objects o

            where v.view_NAME in ('PA_PROJ_REQ_DISTRIBUTIONS','PA_PROJ_REQ_DISTRIBUTIONS_V','PA_PROJ_REQ_DISTRIBUTIONS_V1')

            and o.OWNER = v.OWNER

            and o.OBJECT_NAME = v.VIEW_NAME;

            1 person found this helpful
            • 3. Re: How To Find History of Package Modification
              Kanda-Oracle

              Hi Ramaraju

               

              You may also check the column LAST_DDL_TIME in the table dba_objects.

               

              LAST_DDL_TIME Not Changing (Doc ID 1448241.1)

              Why LAST_DDL_TIME is not updated after running "CREATE OR REPLACE VIEW"? (Doc ID 862422.1)

               

              Thanks!

               

              N Kandasamy

              1 person found this helpful