SQL to fetch learning catalog profile
Summary:
In which database table(s) can I find the learning catalog profile ID and learning catalog profile number
Content :
Background information: In version 25D Oracle Learning introduced Learning Catalog Profiles to secure access , which is just what we need. To leverage it, we must first create our learning catalog profiles and then we must associate all our learning items (courses, offerings, specializations) to the appropriate learning catalog profile. We have a few thousand learning items, and we will perform this association in bulk, using HDL (CourseV3 business object, attribute LearningCatalogProfileNumber). So far, so good. We will only have 10 learning catalog profiles and I can lookup the LearningCatalogProfileNumber in the UI. But the next step would be to validate our updates, to ensure that all our learning items are associated with the