Let's Discuss how to run SQL query in oracle fusion HCM Step by step.
Step 1 : Go to the oracle login page and fill the user id and password then sign in.
Step 2: From the Home page, access Tools tab and go to the Reports and Analytics.
Step 3: Click On Browse catalog and click on.
Step 4: Click on the Drop-down button Create and select Data Model.
Step 5: On the Diagram tab, click on (+) and select SQL Query.
Step 6: In the New Data Set window:
Name: Enter a name for the query
Data Source: ApplicationDB_HCM
Type of SQL: Standard SQL
Step 7: Write a query into the SQL Query box, one simple query could be
Select * from per_all_people_f
Step 8: Click on OK Button, to exit the New Data Set window.
Step 9: Select the Data tab.
Step 10: Drop-down on Rows to increase the number of results returned.
Step 11: Select the View button.
Step 12: The results will default to Tree View for the XML; select Table View to see the results in table format.
Happy reading and exploring . . .