In this article, we will look into Fusion HCM KB Tools that our team has developed using Oracle APEX.
These tools are designed to make the life easier for most frequently used objects that we search for.
Currently we have developed two tools:
- Tables and Columns
- Lookup Values
These tools have been designed with end user experience in view to make the search easier.
Here is the link to access the tool: HCM KB Tools on Oracle APEX
Here is the first look of the tool
From the left-hand navigation click on 1. Tables and Cols or 2. Lookup Values to access specific tools.
Table of Contents
Tables and columns Search Tool:
It will show a dashboard with the total number of tables by module and drill down is enabled by module, so when clicked it will take us to the tables list in that module.
We can also search by table name by clicking on the Table Search.
Here we can see the options to filter by Audit table/Translation table/Base table/Date tracked table. In the search results we can click on table name which takes us to the table details and shows the description and columns in it.
Lookup Values Search Tool:
Use this tool to search for Lookup Values. We can also do a reverse search to find the lookup type based upon the lookup value or meaning.
Search by lookup values
Search for Meaning or Description to find out the right lookup type that is needed.
Many other ideas are in works. If you have any ideas, please share with us.
Please share your feedback by clicking on the feedback icon on the application.
If you like the content, please follow us on LinkedIn, Facebook, and Twitter to get updated with the latest content.
