Thursday, January 30, 2020

FORMULA_RESULT_FLAG column in the PAY_RUN_RESULT_VALUES table


FORMULA_RESULT_FLAG column in the PAY_RUN_RESULT_VALUES table:-

D means Run result calculated by the Fast Formula.

N means Run result created by a call to the API (Ex: PAY_RUN_RESULT_PKG).

NULL means Run result created as an indirect result or the input value directly entered by the user.

No comments:

Post a Comment

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...