Skip to Main Content

Welcome

Welcome to FusionHCMKB Tools. It's a brainchild of Fusion HCM Knowledgebase which is one of the top blogs in Oracle HCM Cloud space. We will try to simplify things one at a time. We have got some ideas and are working on them. If you have any ideas, pls provide them in feedback section

1. Tables and Columns

Tables and Columns get added/modified with every update/release. And there isn't a single place where we can get this information. We have to navigate to Common Features tables and HCM tables to get this information. And the search page doesn't provide an exhaustive search feature. We tried to simplify the process by providing many advanced search features.

Use the menu Navigation Bar "Tables and Views" to check the features of this application.

1) Tables Dashboard - Overview of Tables

2) Table Search - Search for Tables using Advanced Search

3) Table & Column Search - Search for Tables and Columsn using Advanced Search

4) Table Details - Lists Table Details along with Columns for Input Table Name

5) Column Details - Lists all Table References for the Input Column Name


The tables list has been updated till 21C. Please do your due diligence.

2. Lookup Values

Lookup Types and Values get changed with every update/release. And there isn't a single place where we can get this information. We need to check the Manage Common Lookups task and search for the Lookup Typ. Instead we can use this application to do a reverse search and find out the Lookup Type based on the Lookup Value. We tried to simplify the process by providing many advanced search features.

Use the menu Navigation Bar "Lookup Values" to check the features of this application.

1) Lookup Dashboard - Overview of Lookup Types and Values

2) Lookup Values - Search for Tables using Advanced Search

3) Lookup Search - Search for Tables and Columsn using Advanced Search


The Lookup values has been updated till 21C. We will make every attempt to update this data with the latest info. The actual client instance might have different info if they customize or add the lookup values. Please do your due diligence.

Feedback

Please provide your feedback/suggestions by clicking on the Feedback menu item. Thank you.

Visitor Count

Flag Counter

Social Footer