Hi Dimple, Thanks for the reply. We followed the same steps as instructed in the shared link. Unfortunately we are still seeing the factor catalog objects after deleting from CUSTOM_BI_WEBCAT_REPORTING_DUTY. Could you please let me know if we are missing any step here?

hi Rajesh, Thanks for the reply. is there any other group apart from FAW Service Administrator. Because this group has got most of the privileges which we don't to give for users belonging to one Department ( i.e., they need only view access)

Hi Abhilash, Is it possible to share the SQL used to achieve this Scenario?

hi Sorry, My bad it is Fusion Transportation Intelligence.

Thanks for the update. As per the oracle documentation, we don't have any prebuilt data models /subject areas available in SCM. In some of the oracle blogs, it was mentioned that we have to use FTI(Fusion Transactional Intelligence) to build transactional reports in OTM. Hence, trying to understand if we can call the…

Hi Nathan, Yes, OTM - Mean Oracle Transportation Management. Heard that for OTM we has it's own database . Can we build reports using OTBI?