This content has been marked as final. Show 3 replies
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