My Oracle Support Banner

Fusion Global Paryoll: Are there Any Limitations on Number of Rows a User Defined Table (UDT) Can Hold and Load? (Doc ID 2354819.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.20.07.0 and later
Oracle Fusion Global Payroll - Version 11.12.1.0.0 and later
Information in this document applies to any platform.
This note was created for Release 11.12.1.0.0. The note has been reviewed and is current for release 11.13.20.07.0.

Goal

What Is the User Defined Tables (UDT) Capacity?

Attempting to design a workforce compensation plan where the user would need to bring in a large volume of data into a workforce compensation worksheet via fast formulas.

Twenty-five non-complex fast formulas will be used to deliver 25 different data points stored on a UDT, and the table would need to have 26 columns and approximately 108,000 rows.

Is there a known threshold where performance will suffer when a single user-defined table has more than a certain number of rows?

If so, what is the recommended maximum number of rows that a single user-defined table should have?

Scenario:
The goal is to have a master UDT that will drive a lot of compensation calculations like 1) Plan Eligibility 2) Budget Tier 3) Award Guidelines.
The rows are related to various Grade, Salary Plan, and Market range combinations required for this specific scenario.

The estimated number of rows is 108k. Are there any limitations on the number of rows a UDT can hold and load?

The data will be loaded through HCM Data Loader (HDL).

Solution

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

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


In this Document
Goal
Solution
References


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