My Oracle Support Banner

Fast Formula Used To Fetch UDT Returns Null Value (Doc ID 2392045.1)

Last updated on APRIL 27, 2018

Applies to:

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

Symptoms

Fast Formula is used to fetch UDT (User-Defined Table) value.

There is no issue or error when Fast formula is compiled.

While trying to figure out the issue found that GET_TABLE_VALUE does not work as expected. GET_TABLE_VALUE('table_name','column_name','row_value [,default_value]','0')
It always return the default value '0'.

Changes

 

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!


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