LOV Schedules

[Former Member]

We have several LOV's that are automatically refreshed. These were set up before I started to maintain the BO environment. I need to find out what the schedules are for each of the LOVs. Does anyone know a way to do this? Is there a query that will return this information?

Thanks

[hitomi_takano · Accepted solution]

Hi Dale,

To find out the information about LOV schedule properties, try the following query from query builder(the link located in Administration Launchpad).

SELECT * FROM CI_APPOBJECTS WHERE SI_KIND = 'MetaData.MetaDataRepositoryInfo' and SI_INSTANCE_OBJECT = 1.

This will return the scheduled instances(recurring) of LOVs.

From the query result, check the properties such as SI_SCHEDULE_INTERVAL_MONTHS, SI_SCHEDULE_INTERVAL_NDAYS, or SI_SCHEDULE_INTERVAL_HOURS.

Hitomi

[Former Member · Accepted solution]

Thanks, that worked great!

I thought that BO would have included a tool that would allow you to view schedules for LOV's once they have been set up.

Thanks