FAST FORMULA RETURNS AFDICT_APP_PREFIX-PAY NO DATA RETURNED. (3=GET_TABLE_VALUE)
Last updated on JANUARY 16, 2018
Applies to:Oracle Fusion Global Payroll - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.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 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)
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.
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