2 Replies Latest reply on Jul 28, 2016 9:23 AM by ramya3250

    what made the database objects recompiled?

    ramya3250

      Our audit team questions on some database objects compile time. these objects showing time stamp every sunday around 2PM.

       

      I wanted to know what job or something else caused this compile.

      seen no patches applied during this time.

       

      CURRENT ENV EBS R12.1.3 with Database 12.1.0.2

       

      how do i know why it was compiled ? like any concurrent job compile

       

      some objects in our audit question are

                                                                            

      OWNER

      OBJECTNAME

      OBJECTTYPE

      HR

      PER_ALL_PEOPLE_F

      TABLE

      HR

      PER_ALL_ASSIGNMENTS_F

      TABLE

      HR

      HR_ALL_ORGANIZATION_UNITS_TL

      TABLE

      GL

      GL_JE_SOURCES_TL

      TABLE

      GL

      GL_INTERFACE

      TABLE

      APPLSYS

      WF_RESOURCES

      TABLE

      APPS

      PSP_TEMPLATE_SELECTION

      PACKAGE BODY

      APPS

      POA_DBI_REQ_F_C

      PACKAGE BODY

      APPS

      PJI_LAUNCH_UPP_MAIN

      PACKAGE BODY

      APPS

      XLA_UPGRADE_PUB

      PACKAGE BODY

      PUBLIC

      FND_STATS

      SYNONYM

                                         

      APPLSYS

      WF_CONTROL

      QUEUE

      APPLSYS

      FND_CP_GSM_OPP_AQ

      QUEUE

      APPLSYS

      FND_CP_GSM_OPP_AQ$4843

      RULE SET

      APPLSYS

      FND_CP_GSM_OPP_AQ$4843

      RULE

      APPLSYS

      FND_CP_GSM_OPP_AQ_R

      RULE SET

      APPLSYS

      FND_CP_GSM_IPC_AQ

      QUEUE

       

                

      WF_CONTROL

      FND_CP_GSM_OPP_AQ_R

      FND_CP_GSM_OPP_AQ$4943

      FND_CP_GSM_OPP_AQ$4943

      FND_CP_GSM_OPP_AQ

      FND_CP_GSM_IPC_AQ