I have encountered a requirement to stop an element being processed more than once in a payroll. This could have been achieved in case the correct configuration was done at element creation time. But the check box to process the element once was not checked.
So to resolve this issue we decided to write a skip rule, so that the second result which gets processed will be skipped. So the next hurdle was how do I check if a result is already processed for the element.
To resolve this I found out that a table value set can be created and would be parameterized and would be called from the fast formula to return a value(in this case Y or N depending if the element got processed at least once). The value set can be called using the function get_value_set in the fast formula.
Sample:
---------
Source:
http://www.oracleport.com
So to resolve this issue we decided to write a skip rule, so that the second result which gets processed will be skipped. So the next hurdle was how do I check if a result is already processed for the element.
To resolve this I found out that a table value set can be created and would be parameterized and would be called from the fast formula to return a value(in this case Y or N depending if the element got processed at least once). The value set can be called using the function get_value_set in the fast formula.
Sample:
---------
http://www.oracleport.com
No comments:
Post a Comment