My Oracle Support Banner

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

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.