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.

Monday, January 27, 2020

Move Order Status in Oracle Apps

select *
  from fnd_lookup_values
where lookup_type = 'MTL_TXN_REQUEST_STATUS'
and language = USERENV('LANG')
order by lookup_code


Query to get the list of contexts for each formula type in Oracle Fusion HCM

select t.base_formula_type_name ,      ttl.formula_type_name ,      ttl.description ,      c.base_context_name from   ff_formula_types_b t ,...