This content has been marked as final. Show 3 replies
Hi,1 person found this helpful
Could you please go to Balance screen and check if your balance name is associated with dimension "_ASG_ITD".
Also please check all variables are spelled correctly.
The message occurs because the formula compiler doesn't recognise that as a database item. The DB items you use in any formula are only usable if they have all their required contexts set by the calling process - a QP-type formula does not set all the contexts that a payroll-type formula would. Check out the table FF_FTYPE_CONTEXT_USAGES to see the differences between the two formula types (formula_type_id = 61 for payroll, 101 for QP)
In short, if you want to obtain balances for a QP formula you might need to make use of a pl/sql function within the QP formula.
Edited by: clive_t on 31-Dec-2012 10:57
Edited by: clive_t on 31-Dec-2012 11:03
Oh my, that is unfortunate. Thanks though. Have written a function to retrieve the value in question.