B Frequently Asked Questions

Refer to these Frequently Asked Questions if you have questions about the behavior of Fusion Analytics Warehouse.

Topics

• Can I bring additional data security-related objects from Oracle Fusion Cloud Applications into Fusion Analytics Warehouse to set up custom data security in Fusion Analytics Warehouse?
• Can I report the rollback or reversal processes in the pay period-based reporting?

Can I bring additional data security-related objects from Oracle Fusion Cloud Applications into Fusion Analytics Warehouse to set up custom data security in Fusion Analytics Warehouse?

On the Console, under Applications, in Human Capital Management, when you create a pipeline for the Security Configuration Data functional area in the HCM Security Configurations offering, Fusion Analytics Warehouse gets additional data from Oracle Fusion Cloud Applications (Cloud HCM). You can set up custom data security leveraging this new data.

This pipeline brings data from these Oracle Fusion Cloud Applications (Cloud HCM) objects and populates these tables in Fusion Analytics Warehouse:

Oracle Fusion Cloud Applications Object	Corresponding Fusion Analytics Warehouse Table
Area of Responsibility	DW_ASG_RESPONSIBILITY_D
Department hierarchy row flattened details	DW_DEPARTMENT_RF_DH
Organization hierarchy row flattened details	DW_ORGANIZATION_RF_DH
Tree Version Details (required for Department Hierarchy and Organization Hierarchy based security configurations)	DW_TREE_VERSION_D

1. Sign in to your service.
2. In Fusion Analytics Warehouse, click the Navigator.
3. In the Navigator menu, click Console.
4. On the Console, click Data Configuration under Application Administration.
5. On the Data Configuration page, click Human Capital Management.
6. On the service page, click Create, select HCM Security Configurations in Offering, select Security Configuration Data in Functional Area, and then click Next.
   
   
   
   
7. Review the parameters and click one of the options:
   • Cancel: To cancel the data pipeline for the functional area.
   • Save: To save the data pipeline for the functional area but not activate it.
   • Activate: To schedule when to run the data pipeline for the functional area. See Activate a Data Pipeline for a Functional Area.

Can I report the rollback or reversal processes in the pay period-based reporting?

You can create reports at time dimension level but you can't drill down to the pay period for which the rollback or reversal process was run.