My Oracle Support Banner

Fusion HCM Extract: GET_TABLE_VALUE and HR_GET_TABLE_VALUE Return No Values in Fast Formula (Doc ID 2471153.1)

Last updated on MARCH 18, 2024

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.


In an HMC extract accessing a UDT in a fast formula to find an email address. Defined extract columns to contain the table, column and row names and pass these to the fast formula. The formula uses these in a call to HR_GET_TABLE_VALUE, but the default value is always returned. Tried changing contexts in the fast formula to the LDG of the UDT and calling GET_TABLE_VALUE instead, but the results are the same.

Formula is below:



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

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