Search This Blog

Tuesday, June 7, 2011

Cannot end date or delete the element in Oracle Payroll

Cannot end date or delete the element in Oracle Payroll:

Requirement: When I am trying to end date the element as of 01-Jan-2010 it is giving me the following error:

APP-PAY-06213: Formula result rule use this input value
Check you formula result rules for indirect results that feed this input value.
Solution:
Please run this updated query to see if there is any run results attached to the element.
SELECT  ET.ELEMENT_NAME,psp.PROCESSING_RULE, ff.FORMULA_NAME, pfr.RESULT_NAME,
pfr.RESULT_RULE_TYPE, et1.ELEMENT_NAME et_to_end_date,iv.NAME,iv.UOM, et.REPORTING_NAME,RESULT_RULE_TYPE ,
Psp.EFFECTIVE_START_DATE rule_start_date,PSP.EFFECTIVE_END_DATE rule_end_date
FROM
PAY_STATUS_PROCESSING_RULES_F psp,
PAY_FORMULA_RESULT_RULES_F pfr,
ff_formulas_f ff,
PAY_ELEMENT_TYPES_F ET,
PAY_ELEMENT_TYPES_F ET1,
PAY_INPUT_VALUES_F IV
WHERE
psp.FORMULA_ID=ff.FORMULA_ID
AND pfr.STATUS_PROCESSING_RULE_ID=psp.STATUS_PROCESSING_RULE_ID
AND et.ELEMENT_TYPE_ID=psp.ELEMENT_TYPE_ID
AND et1.ELEMENT_TYPE_ID=pfr.ELEMENT_TYPE_ID
AND iv.INPUT_VALUE_ID=pfr.INPUT_VALUE_ID
--AND pfr.RESULT_RULE_TYPE = 'I'
AND ET1.ELEMENT_NAME = --'Pension Adjustment'

No comments:

Post a Comment