Troubleshooting
Problem
Payment Status Not Being Moved from 'AWAIT_AUTH' to 'AUTHORIZED'
Symptom
Problem Desc: Payment Status is not moving orders from AWAIT_AUTH to AUTHORIZED
status. This happens only when the number of records in yfs_charge_transaction
is more than 500 with charge_type='CHARGE' and status='OPEN'
PART: Agents
2.0 SP2 Platform
COMPONENT: YFSPaymentCollection
OS: Windows NT - 4.0
SP 3
DATABASE: Oracle - 7.3.2
WEB SERVER: IIS - 3.0
WEB BROWSER:
Internet Explorer - 5.0
Cause
Resolving The Problem
A subcase has been generated to investigate this defect. The following query
can be run to update the orders from "AWAIT_AUTH" to "AUTHORIZED" status.
NOTE: This query should be run only in the case of an absolute
emergency.
update yfs_order_header set
payment_status='AUTHORIZED',
DISCOUNT_REFERENCE='SQLUPDATE',
modifyts=sysdate
where payment_status='AWAIT_AUTH' and order_header_key not
in (
select order_header_key from yfs_charge_transaction
group by
order_header_key having (sum(OPEN_AUTHORIZED_AMOUNT) - sum(BOOK_AMOUNT)) < 0 )
Historical Number
PRI47819
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21548074