Troubleshooting
Problem
SQL: Adjust Grand Total for FULLY SHIPPED Order
Symptom
If the incorrect grand total is passed in Create Order XML, the order never
moves to 'paid' status, and after every authorization expiration date, the
Collection Agent creates a new authorization request. (Data integrity
problem)
PART: Platform-Console 2.0 SP3 Platform
COMPONENT:
Exceptions
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
Steps to Resolve Issue:
1. Fix the Create Order XML so that it will pass
the correct grand total.
2. For an order already created with an
incorrect grand total, execute the following SQL update:
Update
yfs_charge_transaction
set modifyts=sysdate,
modifyprogid='SQLPLUS',
book_amount=(-1)*(select sum(book_amount)
from
yfs_charge_transaction where charge_type='SHIPMENT' and
order_header_key='actual_order_header'
group by order_header_key)
where
charge_type='CREATE_ORDER' and order_header_key='actual_order_header'
;
This will take the order to 'paid' status after the authorization
expiration date in yfs_order_header, so no agent will consider this order for
any further processing.
Historical Number
PRI48030
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21549008