About Validating Your Data
As a functional administrator, you can validate a library of metrics between your Oracle Fusion Data Intelligence instance and the Oracle Transactional Business Intelligence instance. The library of metrics is part of Oracle Fusion Data Intelligence.
To validate data between the source and warehouse, the Oracle Fusion Data Intelligence functional administrator and Oracle Fusion Cloud Applications user must have the same privileges. For example, if you're an administrator in Oracle Fusion Data Intelligence and Oracle Fusion Cloud Applications, then you can use those user IDs to perform data validation.
You can set and apply common parameters across multiple metrics within a validation set while maintaining the flexibility to adjust individual metrics as needed. This reduces redundancy and saves time in the process of creating and editing the validation set.
Prerequisites for Data Validation
Here's a list of prerequisites for validating your data as an administrator:
- Ensure that you can access the Oracle Transactional Business Intelligence instance and run queries.
- Ensure that you have the same data security privileges in Oracle Fusion Data Intelligence instance and the Oracle Transactional Business Intelligence instance.
- Ensure that you’re assigned the Integration Specialist Group in Oracle Fusion Data Intelligence to access the Common folder in Oracle Analytics Cloud and to view the output of the data validation project.
- Create a user, such as
MyFAWValidationUser, to validate the extracted data. See Create a User to Validate the Extracted Data. - If Location Based Access Control (LBAC) is enabled in the Oracle Fusion Cloud Applications instance, then you must ensure that the roles needed for the users who extract and validate the extracted data are public.
- Ensure that the user who validates the data in Oracle Fusion Data Intelligence also exists in the Oracle Fusion Cloud Applications identity domain if the identity domain used by Oracle Fusion Data Intelligence is different from the one used by Oracle Fusion Cloud Applications.
- Create a custom BI Abstract role and associate it with an applicable user, such as
MyFAWValidationUser, whose credentials you want to provide for data validation. - In Oracle Fusion Data Intelligence, on the Source Credentials tab of the Data Validation page, provide the
credentials of the applicable user, such as
MyFAWValidationUser.Note
If the password has expired, then set the new password using the Source Credentials tab. Ensure that the password for this user doesn't contain any special characters or space.To navigate to the Source Credentials tab, open the Navigator menu, click Console, and then click Data Validation under Application Administration. You see the Scheduled Validation, Detailed Validation, and Source Credentials tabs.