apps-infra

    Forum Stats

  • 3,873,695 Users
  • 2,266,628 Discussions
  • 7,911,601 Comments

Discussions

Invalid EUL objects

Lalitha Subramanian
Lalitha Subramanian Member Posts: 66 Silver Badge
edited Apr 1, 2019 12:02PM in Discoverer

Hello,

We used Discoverer 10 years ago, and not longer using it after oracle de-supported.  We are still seeing some EUL4 objects in Invalid list after dropping the EUL schemas.. 

Any Ideas..

Thanks

Lalitha

Lalitha Subramanian

Best Answer

Answers

  • sbeck-Oracle
    sbeck-Oracle Member Posts: 116 Employee
    edited Mar 29, 2019 7:41AM

    Hi Lalitha,

    The most likely reason is these objects are from Scheduled Workbooks.  When a workbook is scheduled the following database objects are created:
      A view (e.g. EUL5_B011206161506Q1V1)
      A table (e.g. EUL5_B011206161506Q1R1)
      A package (e.g. EUL5_BATCH_PACKAGE011206161506 )
      A job (e.g. EUL5_BATCH_PACKAGE011206161506.RUN)

    If you are no longer using Discoverer, these objects can be removed/dropped.

    Regards,
    Sharon

    Lalitha SubramanianLalitha Subramanian
  • Lalitha Subramanian
    Lalitha Subramanian Member Posts: 66 Silver Badge
    edited Mar 29, 2019 8:15AM

    Thanks Sharon,

    Yes, Looks like there is a scheduled job that runs every month..  We also dropped the job, You mean we just need to drop these objects and will not see anymore of EUL objects? 

    EUL4_B050118165224Q1V1

    EUL4_B050118165302Q1V1

    EUL4_B050118165340Q1V1

    EUL4_B050627135621Q1V1

    EUL4_GET_ITEM_NAME

    EUL4_GET_OBJECT_NAME

    EUL4_NAMED_ELEMS

    EUL4_B050415174205Q1V1

    EUL4_B070724144604Q1V1

    EUL4_B070801152018Q1V1

    Will try that.  Thanks for your response..

    Lalitha

  • sbeck-Oracle
    sbeck-Oracle Member Posts: 116 Employee
    edited Apr 1, 2019 7:05AM Answer ✓

    Especially if they are invalid, there is zero impact.  Also, if you are not using Discoverer there is zero impact.  Yes, just drop them.

    Regards,

    Sharon

    Lalitha Subramanian
apps-infra