Mass Settlement approval

Hi All,

We have a custom approval function which derives the approval hierarchy for claims.

Now business is asking if we can develop the similar approval function for the mass settlement.

So we created a new approval rule with the setup type- claim group and approval type - claim.

Then we insert the custom package in the ams_object_rules_b table. But when we create the mass settlement and hit next button system gives below exception error.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27120: SQL error during query execution.  Statement:  SELECT OBJ.object_rule_name  FROM ams_object_rules_vl  WHERE OBJ.object_rule_id = :1