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.
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.
Top 10 Popular Posts from our Knowledgebase
- DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
- Core HR Entity Relationship Diagram (ERD) for HCM Cloud
- Most Frequently used Document IDs from Oracle Support
- FREE Oracle Training & Accreditation with Oracle Learning Explorer
- How HDL Transformation Formula works with ElementEntry Sample
- FREE Oracle Fusion Demo Instance (VISION) Access
- Top 10 FREE useful tools for Fusion Consultants
- Learning Fusion HCM Technical Skillset
- Sample HCM Data Loader (HDL) files for all Business Objects
- Most frequently used Tables list in Fusion HCM