My Oracle Support Banner

Fusion Global Payroll: Two Issues with a User Defined Table (UDT) Created for Human Resources (HR) (Doc ID 2018747.1)

Last updated on JUNE 09, 2015

Applies to:

Oracle Fusion Global Payroll - Version and later
Oracle Fusion Global Payroll Cloud Service - Version and later
Information in this document applies to any platform.


Created a User Defined Table (UDT) for Human Resources (HR) to store a list of global codes updated nightly. The interface lists a global code id, a global code, a description and then a couple of other fields that relate to the id and code. Every employee must have a code assigned to them. A fast formula was written to show all of the available codes on Assignment so that one can be selected from a search box.
There are two issues;
1. UDT tables for HR are not planned in the Oracle Roadmap. Therefore, will not be able to report from them in Fusion.
2. The UDT is Legislative Data Group (LDG) specific.  Storing global values here that would apply to every LDG.

For item 1, a possible solution offered was using Trees. The problem is that the data loaded to these tables has no hierarchy. It is just a 50k list of ids, codes, descriptions and other associated data fields.  Is there any other solution to the issue as there is a need to store this data and be able to report off of the data for HR purposes. These are not associated to Payroll at all.

For item 2, a possible solution offered was creating a UDT for each LDG. The values that are received daily are global values. An employee in Canada, Mexico and the United States can have the exact same org code. These are not broken down by country. Due to the size of the table now, it is preferable to not have to create an identical table for each LDG that is brought into the application. This would also require maintenance to each table exactly the same as there is a nightly feed and ad hoc manual entry done.

The issue is two-fold. Even if the only solution to the UDT/LDG problem is to create multiple tables, there is still a problem reporting off them. Is there is a solution that will fix both issues?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.