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?
Hitomi Takano replied
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.