PaymentCollection Requests for Authorization for Cancelled Orders

Resolving The Problem

CR 10417 has been created for this issue.

The following solution is to be used only if required (as a last resort):

Run the following query to get a list of order_header_keys. Copy the list of the order_header_keys that you get from the query.
Select ''''||order_header_key||''',' from yfs_order_line_status
where status <> '9000' group by order_header_key having sum(status_quantity) =0

Run the next query to update yfs_charge_transaction. Paste the order_header_keys in the (.....) line in the second query. Remove the last comma (at the end of last order_header_key that you have pasted) and run this query.

Update yfs_charge_transaction A
set book_amount=(-1)*(select B.book_amount from yfs_charge_transaction B
where B.charge_type='CREATE_ORDER' and B.order_header_key=A.order_header_key)
where A.charge_type='CANCEL' and A.order_header_key in (.......)

CR 10417 has been fixed in Release 2.0-SP3-HF6. The user has to be on SP3-HF5 in order to update to this version of hotfix.