[UFIDA maintenance] Post-patch issues

Cause Description: the following problem occurs: 1. two identical purchase warehouse receiving ticket records are displayed in the purchase details of the procurement module. general ledger system and receivables payable reconciliation, a fraction of the difference, (estimated to be rounding the problem) Before I have played the U8-V861-21-060510120000-U861SP1 appeared above the problem, the implementation of support instructions to play U8-V861-0541-93093 patch, (This patch depends on the KB-U861-0323-060901-U861SP1PackB), coupled with procurement issues need to play three more patches. after the KB-U861-0323-060901-U861SP1PackBKB-U861-0541-061110-93093KB-U861-0349-060907-90511 patch was found, direct sales procurement orders in direct business, unable to copy the sales order (without any filter conditions ).
The same operation can be performed on clients that do not have the following three patches, but can be filtered out. the key query statement is as follows: declare @ P1 intset @ p1 = 180150002 declare @ P2 intset @ P2 = 8 declare @ P3 intset @ P3 = 1 declare @ P4 intset @ P4 = 1 exec sp_cursoropen @ P1 output, N 'select' as selcol, (copysolist. ID) as imainid, (copysolist. csocode) as csocode, (copysolist. ddate) as ddate, (copysolist. ccuscode) as ccuscode, (copysolist. ccusabbname) as ccusabbname, (copysolist. cdepcode) as cdepcode @, (copysolist. cdepname) as cdepname @, (copysolist. cpersoncode) as cpersoncode, (copysolist. cpersonname) as cpersonname, (copysolist. cexch_name) as cexch_name, (copysolist. iexchrate) as nflat, (copysolist. itaxrate) as itaxrate, (copysolist. cmemo) as cmemo, (copysolist. cpaycode) as cpaycode, (copysolist. cpayname) as cpayname, (copysolist. cstcode) as cstcode, (copysolist. cstname) as cstname, (copysolist. cbustype) as cbustype, (copysolist. cdefine1) as cdefine1, (copysolist. cdefine2) as cdefine2, (copysolist. cdefine3) as cdefine3, (copysolist. cdefine4) as cdefine4, (copysolist. cdefine5) as cdefine5, (copysolist. cdefine6) as cdefine6, (copysolist. cdefine7) as cdefine7, (copysolist. cdefine8) as cdefine8, (copysolist. cdefine9) as cdefine9, (copysolist. cdefine10) as cdefine10, (copysolist. cdefine11) as cdefine11, (copysolist. cdefine12) as cdefine12, (copysolist. cdefine13) as cdefine13, (copysolist. cdefine14) as cdefine14, (copysolist. cdefine15) as cdefine15, (copysolist. cdefine16) as cdefine16, (copysolist. isosid) as isosid, (copysolist. cinvcode) as cinvcode, (copysolist. cinvaddcode) as cinvaddcode, (copysolist. cinvname) as cinvname, (copysolist. cinvstd) as cinvstd, (copysolist. cinvm_unit) as cinvm_unit, (isnull (copysolist. iquantity, 0) as iquantity, (copysolist. iinvexchrate) as iinvexchrate, (copysolist. inum) as inum, (isnull (copysolist. fpurquan, 0) as fpurquan, (copysolist. itaxrate) as ipertaxrate, (copysolist. igrouptype) as igrouptype, (copysolist. binventrust) as binventrust, (copysolist. cunitid) as cunitid, (copysolist. cinva_unit) as cinva_unit, (copysolist. cfree1) as cfree1, (copysolist. cfree2) as cfree2, (copysolist. cfree3) as cfree3, (copysolist. cfree4) as cfree4, (copysolist. cfree5) as cfree5, (copysolist. cfree6) as cfree6, (copysolist. cfree7) as cfree7, (copysolist. cfree8) as cfree8, (copysolist. cfree9) as cfree9, (copysolist. cfree10) as cfree10, (copysolist. cdefine22) as cdefine22, (copysolist. cdefine23) as cdefine23, (copysolist. cdefine24) as cdefine24, (copysolist. cdefine25) as cdefine25, (copysolist. cdefine26) as cdefine26, (copysolist. cdefine27) as cdefine27, (copysolist. cdefine28) as cdefine28, (copysolist. cdefine29) as cdefine29, (copysolist. cdefine30) as cdefine30, (copysolist. cdefine31) as cdefine31, (copysolist. cdefine32) as cdefine32, (copysolist. cdefine33) as cdefine33, (copysolist. cdefine34) as cdefine34, (copysolist. cdefine35) as cdefine35, (copysolist. cdefine36) as cdefine36, (copysolist. cdefine37) as cdefine37, (copysolist. citemcode) as citemcode, (copysolist. citemname) as citemname, (copysolist. citem_class) as citem_class, (copysolist. citem_cname) as citem_name, (copysolist. irowno) as irowno, (copysolist. fkyquantity) as fkyquantity, (copysolist. cinvdefine1) as cinvdefine1, (copysolist. cinvdefine2) as cinvdefine2, (copysolist. cinvdefine3) as cinvdefine3, (copysolist. cinvdefine4) as cinvdefine4, (copysolist. cinvdefine5) as cinvdefine5, (copysolist. cinvdefine6) as cinvdefine6, (copysolist. cinvdefine7) as cinvdefine7, (copysolist. cinvdefine8) as cinvdefine8, (copysolist. cinvdefine9) as cinvdefine9, (copysolist. cinvdefine10) as cinvdefine10, (copysolist. cinvdefine11) as cinvdefine11, (copysolist. cinvdefine12) as cinvdefine12, (copysolist. cinvdefine13) as cinvdefine13, (copysolist. cinvdefine14) as cinvdefine14, (copysolist. cinvdefine15) as cinvdefine15, (copysolist. cinvdefine16) as cinvdefine16, (copysolist. ufts) as corufts @ from copysolist where isnull (iquantity, 0)> isnull (fpurquan, 0) and (1> 0) and ddate> = ''2017-11-27 ''and ccuscode = ''000000'' and cdepcode like'' % 001 ''and cbustype = n' direct shipping ''' and isnull (fpurquan, 0) = 0 and bservice = 0 and binvtype = 0 and 1 = 1', @ P2 output, @ P3 output, @ P4 outputselect @ P1, @ P2, @ P3, @ P4 when no patch is used, the following query results are displayed: declare @ P2 intset @ P2 = 8 declare @ P3 intset @ P3 = 1 declare @ P4 intset @ P4 = 1 Exec sp_cursoropen @ P1 output, N 'select' as selcol, (copysolist. ID) as imainid, (copysolist. csocode) as csocode, (copysolist. ddate) as ddate, (copysolist. ccuscode) as ccuscode, (copysolist. ccusabbname) as ccusabbname, (copysolist. cdepcode) as cdepcode @, (copysolist. cdepname) as cdepname @, (copysolist. cpersoncode) as cpersoncode, (copysolist. cpersonname) as cpersonname, (copysolist. cexch_name) as cexch_name, (copysolist. iexchrate) as nflat, (copysolist. itaxrate) as itaxrate, (copysolist. cmemo) as cmemo, (copysolist. cpaycode) as cpaycode, (copysolist. cpayname) as cpayname, (copysolist. cstcode) as cstcode, (copysolist. cstname) as cstname, (copysolist. cbustype) as cbustype, (copysolist. cdefine1) as cdefine1, (copysolist. cdefine2) as cdefine2, (copysolist. cdefine3) as cdefine3, (copysolist. cdefine4) as cdefine4, (copysolist. cdefine5) as cdefine5, (copysolist. cdefine6) as cdefine6, (copysolist. cdefine7) as cdefine7, (copysolist. cdefine8) as cdefine8, (copysolist. cdefine9) as cdefine9, (copysolist. cdefine10) as cdefine10, (copysolist. cdefine11) as cdefine11, (copysolist. cdefine12) as cdefine12, (copysolist. cdefine13) as cdefine13, (copysolist. cdefine14) as cdefine14, (copysolist. cdefine15) as cdefine15, (copysolist. cdefine16) as cdefine16, (copysolist. isosid) as isosid, (copysolist. cinvcode) as cinvcode, (copysolist. cinvaddcode) as cinvaddcode, (copysolist. cinvname) as cinvname, (copysolist. cinvstd) as cinvstd, (copysolist. cinvm_unit) as cinvm_unit, (isnull (copysolist. iquantity, 0) as iquantity, (copysolist. iinvexchrate) as iinvexchrate, (copysolist. inum) as inum, (isnull (copysolist. fpurquan, 0) as fpurquan, (copysolist. itaxrate) as ipertaxrate, (copysolist. igrouptype) as igrouptype, (copysolist. binventrust) as binventrust, (copysolist. cunitid) as cunitid, (copysolist. cinva_unit) as cinva_unit, (copysolist. cfree1) as cfree1, (copysolist. cfree2) as cfree2, (copysolist. cfree3) as cfree3, (copysolist. cfree4) as cfree4, (copysolist. cfree5) as cfree5, (copysolist. cfree6) as cfree6, (copysolist. cfree7) as cfree7, (copysolist. cfree8) as cfree8, (copysolist. cfree9) as cfree9, (copysolist. cfree10) as cfree10, (copysolist. cdefine22) as cdefine22, (copysolist. cdefine23) as cdefine23, (copysolist. cdefine24) as cdefine24, (copysolist. cdefine25) as cdefine25, (copysolist. cdefine26) as cdefine26, (copysolist. cdefine27) as cdefine27, (copysolist. cdefine28) as cdefine28, (copysolist. cdefine29) as cdefine29, (copysolist. cdefine30) as cdefine30, (copysolist. cdefine31) as cdefine31, (copysolist. cdefine32) as cdefine32, (copysolist. cdefine33) as cdefine33, (copysolist. cdefine34) as cdefine34, (copysolist. cdefine35) as cdefine35, (copysolist. cdefine36) as cdefine36, (copysolist. cdefine37) as cdefine37, (copysolist. citemcode) as citemcode, (copysolist. citemname) as citemname, (copysolist. citem_class) as citem_class, (copysolist. citem_cname) as citem_name, (copysolist. irowno) as irowno, (copysolist. fkyquantity) as fkyquantity, (copysolist. cinvdefine1) as cinvdefine1, (copysolist. cinvdefine2) as cinvdefine2, (copysolist. cinvdefine3) as cinvdefine3, (copysolist. cinvdefine4) as cinvdefine4, (copysolist. cinvdefine5) as cinvdefine5, (copysolist. cinvdefine6) as cinvdefine6, (copysolist. cinvdefine7) as cinvdefine7, (copysolist. cinvdefine8) as cinvdefine8, (copysolist. cinvdefine9) as cinvdefine9, (copysolist. cinvdefine10) as cinvdefine10, (copysolist. cinvdefine11) as cinvdefine11, (copysolist. cinvdefine12) as cinvdefine12, (copysolist. cinvdefine13) as cinvdefine13, (copysolist. cinvdefine14) as cinvdefine14, (copysolist. cinvdefine15) as cinvdefine15, (copysolist. cinvdefine16) as cinvdefine16, (copysolist. ufts) as corufts @ from copysolist where isnull (iquantity, 0)> isnull (fpurquan, 0) and (1> 0) and ddate> = ''2017-11-27 ''and cbustype = n' direct shipping ''' and isnull (fpurquan, 0) = 0 and 1 = 1 ', @ P2 output, @ P3 output, @ P4 outputselect @ P1, @ P2, @ P3, @ P4 check that the two attempts are identical before and after the patch (before and after the patch. the bservice and binvtype fields do not exist. I re-built an attempt to create view copysolist as select 0 as bservice, 0 as binvtype, convert (char, convert (money, ufts), 2) As ufts, cbustype, so_somain.id, so_somain.cstcode, so_somain.ddate, hour, so_somain.csccode, hour, so_somain.cmaker, hour, so_somain.cdefine2, hour, login, login, so_somain.cdefine11, so_somain.cdefine12, so_somain.cdefine13, so_somain.cdefine14, so_somain.cdefine15, so_somain.cdefine16, customer. ccusabbname, department. cdepname, person. cpersonname, shippingchoice. cscname, paycondition. cpayname, saletype. cstname, so_sodetails.isosid, so_sodetails.cinvcode, inventory. cinvaddcode, inventory. cinvname, inventory. cinvstd, inventory. IID as cinvauthid, so_sodetails.cunitid, unit1.ccomunitname as cinvm_unit, inventory. igrouptype, inventory. binventrust, case when isnull (inventory. igrouptype, 0) <> 0 then unit2.ccomunitname else null end as cinva_unit, inventory. cinvdefine1, inventory. cinvdefine2, inventory. cinvdefine3, inventory. cinvdefine4, inventory. cinvdefine5, inventory. cinvdefine6, inventory. cinvdefine7, inventory. cinvdefine8, inventory. cinvdefine9, inventory. cinvdefine10, inventory. cinvdefine11, inventory. cinvdefine12, inventory. cinvdefine13, inventory. cinvdefine14, inventory. cinvdefine15, inventory. cinvdefine16, numbers, so_sodetails.inum, numbers, numbers, so_sodetails.itax, so_sodetails.isum, numbers, response, response, so_sodetails.itaxrate, so_sodetails.citemcode, response, so_sodetails.citemname, response, expires, response, response, so_sodetails.irowno, (iquantity-isnull (ifhquantity, 0) as fkyquantity from so_somain left Outer Join customer on so_somain.ccuscode = customer. ccuscode left Outer Join Department on so_somain.cdepcode = Department. cdepcode left Outer Join paycondition on so_somain.cpaycode = paycondition. cpaycode left Outer Join person on so_somain.cpersoncode = person. cpersoncode left Outer Join saletype on so_somain.cstcode = saletype. cstcode left Outer Join shippingchoice on so_somain.csccode = shippingchoice. csccode inner join so_sodetails on so_somain.id = so_sodetails.id and isnull (so_sodetails.cscloser, n'') = n'left join inventory on so_sodetails.cinvcode = inventory. cinvcode left join computationunit as unit1 on inventory. ccomunitcode = unit1.ccomunitcode left join computationunit as unit2 on units = unit2.ccomunitcode where isnull (so_somain.cverifier, n'') <> n'' and isnull (so_somain.ccloser, n '') = n'' and inventory. bpurchase = 1 adds the above two fields and filters them again. The direct shipment sales order can be filtered out, but these operations may affect the future.