ERPstuff - Oracle EBS Community

Assalamu-ali-kum,

We have a scenario as the following.
Element: Miscellenous Services
Element : Miscellenous Service Recovery
Balance : Misc_Serv_Bal

Forexample if an employee takes loan as Miscellenous Services so i have to deduct from him through Miscellenous service recovery.
in the above it will be like this.
for Air Ticket January:
Miscellenous Service : 5000
Micellenous Service Recovery : 1000

for Hous January :
Miscellenous Service : 4000
Micellenous Service Recovery : 1000

Now we have one Balance ofcourse , So what i want here is when the employee pays back for Hous he should be deducted 1000 after that but in our case it is deducting 2000 , i want to stop one element how can i do this.

Thanks
Jamal

Pl check Fast Formula and see what is code there? tks

Thanks alot admin....i have checked the formula, the formula is ending all the elements but i want to end one of the entry...thanks.
any other way

Hi Jamal,

As I understand from your scenario, one element is used in two loans so if you stop one loan you will stop the whole element (both)... I guess you need to define two indirect elements ans stop each one according to the loan specified.

Regards,

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'


___________________________
Software Testing Training