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?
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.