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 SEPTEMBER 28, 2020

Applies to:

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

Symptoms

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:

 

Cause

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
Symptoms
Cause
Solution

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