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
Step 02: Creating UDT
Step 03: Defining UDT properties
Step 04: Creating UDT Columns
Step 05: Creating UDT Rows
Step 06: Creating column instances 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.