Incorrect offer setup caused Third Party accruals with invalid QP modifier being applied
Incorrect market eligibility setup on an offer caused QP modifier to be created with no qualifier.
This caused issue with other valid offers as well because the invalid modifier had exclusive incompatibility group.
Now the issue is, Third Party accruals are sitting in table apps.ozf_funds_utilized_all_b with invalid plan_id (qp list_header_id)
Questions:
- How to remove such invalid records from tables?
- Now that invalid modifer/offer is corrected for quanlifers, How to re-run the accrual process so that valid offers get accrued correctly?
Please help ASAP as this is an urgent issue to resolve.