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 126.96.36.199.0 and later
Information in this document applies to any platform.
On : 188.8.131.52.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.
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