Fusion Analytics Warehouse

Products Banner

Reporting on Fusion Setup Manager (Offerings, Feature Opt-ins)

Accepted answer
146
Views
4
Comments

Summary

Synthetic view of what offerings and features are enabled ?

Content

Hi,

I'd like to have a synthetic view of what offerings and features are enabled on my pods. Currently we have to click thru multiple screens to check what's enabled in details.

I see there are delivered reports in /Shared Folders/Functional Setup : among others, Offering Content Guide and Associated Features look promising.
But these reports don't have associated datamodels in any of the pods I checked, including Oracle demo: the datamodel info is completely missing.
Note I've seen those reports documented in old 11g documentation.

Anybody know if FSM details are stored in DB tables ?

Regards,
sebastien

Version

21A

Best Answer

Answers

  • We are now looking for the same details. Were you successful in your search?

  • Hi Meredith,

    I have dropped the subject since, though I would still be interested with news on that topic :-)

    I have once stumbled upon a series of tables that describe business objects and tasks (I have found details on my custom-created tasks for instance), but have not had time to explore more thoroughly, nor have I found any documentation for them.



    ask_business_objects_b

    ask_business_objects_tl


    ask_bo_attributes_b

    ask_bo_attributes_tl

    ask_bo_attribute_values


    ask_bo_tasks


    SELECT TL.TASK_NAME, B.*

    FROM ask_tasks_b B

    INNER JOIN ask_tasks_tl TL

    ON TL.TASK_ID = B.TASK_ID

    WHERE 1 = 1

    AND TL.LANGUAGE = 'US'


    ask_previous_releases

    ask_release_versions

  • Nice !

    not exactly what I was expecting, but with a little tinkering to filter out historical changes from the csv, it allowed me to compare the current state of my different environments.

    Thanks !