With the advent of Oracle Project Management we were introduced to the concept of the User Defined Attribute (UDA) as an alternative to the standard Descriptive FlexField (DFF). However, I’ve had many clients that were unaware of the advantages of using UDA’s rather than DFF’s.
In the past the DFF has been the goto item for storing custom data that is entered by a user to support custom processes and reports. While powerful , one of the major disadvantages is that a developer would have to build their code around reaching to different tables or creating a custom view to make the coding more efficient when writing code for extensions, custom processes, and reports. In addition, there are only a limited number of DFF’s available.
The IT Leader's Guide to Multicloud Readiness
This guide provides practical key insights and important factors to consider to make informed decisions in your multicloud journey.
By utilizing the UDA functionality implementers can allow the user community to enter custom information in Oracle Project Management to drive any type of extensions, custom processes or report. Basically the UDA’s can be assigned at a Project or Task level. The UDA can be assigned via a context of Project Classification, Project Type, Task Type, or Project Class Code. A custom page is created automatically during this process with no development required to support data entry. Another key advantage of this functionality is that there is an option to automatically create a custom database view based upon the UDA information. This greatly enhances your abilities to support extended functionality as it potentially reduces the amount of development required by a developer to deliver a solution while providing an unlimited number of UDA’s in which to store data.
In the past we have implemented this functionality to support the following:
- Project Role Based Budgeting
- Composite Rate Budgeting/Forecasting
- Equipment Run Time Hours Reporting
Below is an example of the UDA form that was utilized for Project Role Based Budgeting.
While the DFF is still an option for storing custom data, you can see the UDA functionality offers a solid solution for driving extended functionality within Oracle Projects.