User-Defined Table in Oracle Cloud HCM

User-Defined Table is a feature provided by Oracle that enables users to create their own table structure to store values or one can say it can be used to create a Master table like structure. It can be widely used for mapping data of a third party systems with Fusion application.

As we all know that new tables can’t be created in Fusion SaaS applications and hence UDT is the only way to create such kinds of custom tables.

Recently one of our customers had shared a requirement where the department used in the third party system is different as of the departments existing in Fusion application. They raised the request with us for storing the mapping data of third party system. So we have created the UDT for defining the one to one mapping of departments and transformed the output using BIP Report.

Basically there are two types of row values: Range or Match. One can set it as Match, if a specific value needs to be matched for each row and column; or it can be set as Range, if we want the row value to be a number and the column instance values need to be changed based on the range of that number.

Basic steps for creating UDT:

Step 01: Navigate to Setup and Maintenance >User-Defined Tables Task

Navigate to setup and maintenance

Step 02: Creating UDT

Creating udt

Step 03: Defining UDT properties

Defining UDT properties

Step 04:  Creating UDT Columns

Creating UDT columns

Step 05:  Creating UDT Rows

Creating UDT rows

Step 06: Creating column instances for UDT

Column instance for UDT

Enter the column Instance value and then click on Save.

If you would like to get more details don’t hesitate to reach out to us here.

Leave a Reply

Your email address will not be published. Required fields are marked *