FAST FORMULA RETURNS AFDICT_APP_PREFIX-PAY NO DATA RETURNED. (3=GET_TABLE_VALUE)

(Doc ID 2310793.1)

Last updated on JANUARY 16, 2018

Applies to:

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

Symptoms

 On : 11.12.1.0.0 version, Global Payroll

Element using UDT Values

I am trying to create a test element deduction using UDT as a range. Ive setup the UDT Structure and Value and edited the voluntary deduction formula to reference the table but I still get an error. Can you advise if theres an issue with my formula. Ive attached the config I have built so far

ERROR
-----------------------
Error was encountered when processing payroll relationship BA_TEST001
An error occurred when processing element (ELEM_NAME. (ETNAME=Test Unison)
An error occurred when processing formula TEST UNISON_VOL_DEDN.
An error occurred during formula execution (ORACLE_ERROR_TEXT=)(FORMULA_ERROR_TEXT=Formula TEST UNISON_VOL_DEDN, line 42, no data returned. (3=GET_TABLE_VALUE))
Formula TEST UNISON_VOL_DEDN, line 42, no data returned (3=GET_TABLE_VALUE)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create the table structure, row and enter a value.
2. Ensure that a fast formula exists which has the call to get_table_value
3. Process quickpay and review log file generated.

Cause

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 hundreds of Community platforms