Search This Blog

Showing posts with label Cannot end date or delete the element in Oracle Payroll. Show all posts
Showing posts with label Cannot end date or delete the element in Oracle Payroll. Show all posts

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'