Spreadsheet: 111155d1307612192-macro-formula-to-extract-5-digit-from-text-match-number-in-string
Sheet: Closed 0527 - 0602

Assignee | [NAME] | Last-modified-by | Problem Type | Resolution | Severity | Log | Classification | Reference | Module | RCA Log updates | RCA incorrect | Ref | Log2 | datafix
 |  |  |  |  |  |  |  |  |  | GLS Palletmovement OPs | Data Fix | Data | NA | Bad entry was there in table dc_sys_common:user_mslz_group
 |  |  |  |  |  |  |  |  |  | QA|Analysis done|Application|Yet to be identified ###    5/28/2011 2:03:08 PM mx_itsm  thank you so much
 |  |  |  |  |  |  |  |  |  | REPORTS | No action | No issue | NA | NA ###
 |  |  |  |  |  |  |  |  |  | |MGDS|NA|Na|NA|finilized user|###
 |  |  |  |  |  |  |  |  |  | Orderfilling|Application|Others|Defect-30530 |Label not scrambled. Will be addressed through Defect###
 |  |  |  |  |  |  |  |  |  | [No Reason]
 |  |  |  |  |  |  |  |  |  | OF | Unable to continue Orderfilling | voice units were changed | N/A ###
 |  |  |  |  |  |  |  |  |  | Customer Request | Data Fix | Populate printer table ###
 |  |  |  |  |  |  |  |  |  | QA|Customer concerns clarified|Application|NA|NA###
 |  |  |  |  |  |  |  |  |  | MGDS|REPORT|Procedure Issue | NA| labels which are in available status ###
 |  |  |  |  |  |  |  |  |  | [No Reason]
 |  |  |  |  |  |  |  |  |  | # [NAME] |  Will look into this ticket to see if we have any issue in matching the shipping and infopac reports. #####
 |  |  |  |  |  |  |  |  |  | GLS - QA | Datafix | Resolved ###
 |  |  |  |  |  |  |  |  |  | [No Reason]
 |  |  |  |  |  |  |  |  |  | # System | No issues found |  No data fix done ####
 |  |  |  |  |  |  |  |  |  | MGDS|shipping|procedure|data|void the load ###
 |  |  |  |  |  |  |  |  |  | [No Reason]
 |  |  |  |  |  |  |  |  |  | MGDS-Receiving | DataFix | Data | NA | User unable to do loose freight ###
 |  |  |  |  |  |  |  |  |  | Receiving Management | Short items | User Request | NA| Initaite PO download and call dc to do item complete###
 |  |  |  |  |  |  |  |  |  | Track3|No action|No issue|Issue resolved on its own ###
 |  |  |  |  |  |  |  |  |  | MGDS-Receiving|Data Fix|Data|NA|Updated quantity in receiving_unit###
 |  |  |  |  |  |  |  |  |  | QA|No Action|Procedural issue|NA|NA ###
 |  |  |  |  |  |  |  |  |  | Application | Setup issue | CenterPoint download | Data fix | invoice was loaded into the system
 |  |  |  |  |  |  |  |  |  | GLS Receiving | No Action | No Issue | NA | Printer Issue ###
 |  |  |  |  |  |  |  |  |  | Environment | OSEDC issue | Infopac queue was not setup in inactive node ###
 |  |  |  |  |  |  |  |  |  | GLS2 - Pallet Movement | Adjustment issue | Clarification provided | No issue | Verified the details and provided clarification to site and business ###
 |  |  |  |  |  |  |  |  |  | <Application>|<Inquiry report> |<OP>|<29817>|<NA>###
 |  |  |  |  |  |  |  |  |  | GLS QA - Receiving Corrections | Not an application issue | Issue with citrix team ###
 |  |  |  |  |  |  |  |  |  | IHC|re-trigger|Application|Defect 30165|Item record insert exception###
 |  |  |  |  |  |  |  |  |  | Shipping | unable to load trailer in trailer planning | data fix | site finished the task ###
 |  |  |  |  |  |  |  |  |  | ########################################################################################      Query used to retrieve the old cross reference numbers and the items:  -------------------------------------------------------------------------     set isolation to dirty read;  select item_nbr,cross_ref_nbr   from dc_sys_common:item_cross_ref  where item_nbr in  (  select substr(intfc_rec_key_val,13,7) as item_nbr  from dc_interface:received_data  where intfc_record_nbr = 3070  and recv_group_id in  (  select recv_group_id from received_group  where intfc_rec_group_cd = 29  and recv_status_code = 308  and date(create_ts) >= '05/23/2011'  and recv_group_id in  (  select recv_group_id from received_data  where intfc_record_nbr = 3070  and process_stat_code != 406  )  )  )  and cross_ref_nbr not in  (  select substr(intfc_rec_key_val,4,6) as cross_ref_nbr  from dc_interface:received_data  where intfc_record_nbr = 3070  and recv_group_id in  (  select recv_group_id from received_group  where intfc_rec_group_cd = 29  and recv_status_code = 308  and date(create_ts) >= '05/23/2011'  and recv_group_id in  (  select recv_group_id from received_data  where intfc_record_nbr = 3070  and process_stat_code != 406  )  )  );       item_nbr cross_ref_nbr        2660685        388080      6743628        410238      8248761        406775      8254795        406773      8254921        404906      8265274        406775      8289074        404906      8289081        406773      8289095        406775      8292165        404906      8292179        406773      9223536        409896      9223548        409867      9239641        409871      9239648        409868      9255848        409895      9287748        409869      9418958        129336      9447714        129336       19 row(s) retrieved.          Used the below qury to retreive the New cross reference number for the above items  ----------------------------------------------------------------------------------    set isolation to dirty read;  select substr(intfc_rec_key_val,4,6) as cross_ref_nbr,  substr(intfc_rec_key_val,13,7) as item_nbr,recv_group_id   from dc_interface:received_data  where intfc_record_nbr = 3070  and recv_group_id in  (  select recv_group_id from received_group  where intfc_rec_group_cd = 29  and recv_status_code = 308  and recv_group_id in  (  select recv_group_id from received_data  where intfc_record_nbr = 3070  and process_stat_code != 406  )  )  and substr(intfc_rec_key_val,13,7) in  (   2660685,  6743628,  8248761,  8254795,  8254921,  8265274,  8289074,  8289081,  8289095,  8292165,  8292179,  9223536,  9223548,  9239641,  9239648,  9255848,  9287748,  9418958,  9447714  )      cross_ref_nbr item_nbr recv_group_id    410177        2660685         297341  410282        6743628         297784  410302        9447714         297939  410302        9418958         297939  410209        9223548         298035  410212        9223536         298038  410216        9287748         298042  410217        9255848         298043  410218        9239648         298044  410219        9239641         298045  410209        9223548         298062  410212        9223536         298065  410216        9287748         298196  410217        9255848         298198  410218        9239648         298200  410219        9239641
 |  |  |  |  |  |  |  |  |  | GLS Shipping | Procedural issue | Application-Defect 30358 | Comments not shown i SP_fin ###
 |  |  |  |  |  |  |  |  |  | [NAME] | NA | NA | Not a GLS issue ###
 |  |  |  |  |  |  |  |  |  | IHC | No Action | Application|Defect 29326| VNPK height , weight and length exceeds the [NAME] app pref value ###
 |  |  |  |  |  |  |  |  |  | IHC| Auto Alert | Item Data load 3050 | 30165 | NA  ###
 |  |  |  |  |  |  |  |  |  | System| slowness issue| ###
 |  |  |  |  |  |  |  |  |  | GLS Management | Invalid | NA | NA | No response from user ###
 |  |  |  |  |  |  |  |  |  | [No Reason]
 |  |  |  |  |  |  |  |  |  | QA | Data fix | NA | NA | requested the DC user to add the Marshalling area ###
 |  |  |  |  |  |  |  |  |  | <OP> | <No Action> | <NA> | <This error message happening due to Distribution Allocation which is a false alert>    5/30/2011 3:43:27 PM mavelum  Could see the file has been tranmitted fine.    Connected to s06099nts800US.s06099.US.wal-mart.com.  220 Microsoft FTP Service  Remote system type is Windows_NT.  331 Password required for wmsc/ftptrks.  230 User logged in.  200 Type set to A.  250 CWD command successful.  Local directory now /u/appdata/gls/outbound  200 PORT command successful.  125 Data connection already open; [NAME] starting.  226 Transfer complete.  282036 bytes sent in 0.02 seconds (14952.54 Kbytes/s)  221 Goodbye.  Connected to honts8025.homeoffice.wal-mart.com.  220 Microsoft FTP Service  331 Password required for wmsc/ftptrks.  230 User wmsc/ftptrks logged in.  200 Type set to A.  250 CWD command successful.  Local directory now /u/appdata/gls/outbound  200 PORT command successful.  150 Opening ASCII mode data connection for gs_tps_outfile.526.2011-05-30-021948.DAT.tmp.  226 Transfer complete.  282036 bytes sent in 1.23 seconds (223.77 Kbytes/s)  350 File exists, ready for destination name  250 RNTO command successful.  221  End Time Time : Mon May 30 02:20:14 EDT 2011      This is a false alert generated for Distribution allocation.  USG DC's will only handle SSTK stock.    ### <OP> | <No Action> | <NA> | <This error message happening due to Distribution Allocation which is a false alert>
 |  |  |  |  |  |  |  |  |  | [No Reason]
 |  |  |  |  |  |  |  |  |  | <OP> | <No Action> | <NA> | <This error message happening due to Distribution Allocation which is a false alert> ###
 |  |  |  |  |  |  |  |  |  | OP|No Issue|NA|NA###
 |  |  |  |  |  |  |  |  |  | QA|Customer satisfied|Environment|NA|NA###
 |  |  |  |  |  |  |  |  |  | IHC|ASpplication|Defect 30165|Item record insert exception###
 |  |  |  |  |  |  |  |  |  | Application| No action| No issue| NA| NA ###
 |  |  |  |  |  |  |  |  |  | IHC|Application|Defect 30165|Item record insert exception###
 |  |  |  |  |  |  |  |  |  | IHC|ASpplication|Defect 30165|Item record insert exception###
 |  |  |  |  |  |  |  |  |  | [No Reason]
 |  |  |  |  |  |  |  |  |  | [No Reason]
 |  |  |  |  |  |  |  |  |  | system | Slowness Issue ###
 |  |  |  |  |  |  |  |  |  | [No Reason]
 |  |  |  |  |  |  |  |  |  | | [NAME] clarification | No Issues | No Ref | User confirmed that order volume is fine now | ###
 |  |  |  |  |  |  |  |  |  | OP | orders are not available in GLS2 | Site manually processed it | NA ###
 |  |  |  |  |  |  |  |  |  | ## Application |  No issue found | Physical quantity will be decreased only when the frieghts are billed | No data fix done ####
 |  |  |  |  |  |  |  |  |  | IHC | Application|Defect 29326| VNPK height , weight and length exceeds the [NAME] app pref value ###
 |  |  |  |  |  |  |  |  |  | IHC | Application|Defect 29326| VNPK height , weight and length exceeds the [NAME] app pref value ###
 |  |  |  |  |  |  |  |  |  | IHC | Application|Defect 29326| VNPK height , weight and length exceeds the [NAME] app pref value ###
 |  |  |  |  |  |  |  |  |  | | No Issues | No Action | QA | NA | NA
 |  |  |  |  |  |  |  |  |  | Receiving | Procedural | Data Fix | NA | Updated VNPK cost amount and WHPK sell amount ###
 |  |  |  |  |  |  |  |  |  | MGDS|NA|NA|NA|replenishment move###
 |  |  |  |  |  |  |  |  |  | QA|Datafix|No issue|NA|NA###
 |  |  |  |  |  |  |  |  |  | Report|Application|NA|NA|Label status changed to void###
 |  |  |  |  |  |  |  |  |  | GLS-Reports|No issue|NA|NA###
 |  |  |  |  |  |  |  |  |  | |Customer Request|QA|NA|###
 |  |  |  |  |  |  |  |  |  | GLS-OrderFilling|Clarification|Set Up Issue|Seems to be an issue after Levelling 2011.4; advised user to set up the report_group id for the affected users ###
 |  |  |  |  |  |  |  |  |  | System-Unix|No Action|No Issue|File in use by other process ###
 |  |  |  |  |  |  |  |  |  | Receiving | item line missing | data fix | sent mail to site to do further process ###
 |  |  |  |  |  |  |  |  |  | QA|User concerns clarified|Procedural issue|NA|User unaware of the system behaviour###
 |  |  |  |  |  |  |  |  |  | Application | defect 30429 | labels were voided | data fix ####
 |  |  |  |  |  |  |  |  |  | IHC|re-trigger|Application|Defect 30162|Item crossref###
 |  |  |  |  |  |  |  |  |  | GLS2 - Interface | Item Data load | Group was not processed | NA | Reprocess again ###
 |  |  |  |  |  |  |  |  |  | GLS2 _ Interface | Item Data load | Group was not processed earlier | NA | Reprocessed sucessfully ###
 |  |  |  |  |  |  |  |  |  | GLS2 - Interface | ItemDataLaod | NA | NA | group reprocessed sucessfully ###
 |  |  |  |  |  |  |  |  |  | GLS2 - Interface | ItemDataload | Group failed to process | NA | Group reprocessed sucesfully ###
 |  |  |  |  |  |  |  |  |  | Receiving | receiving correction | data fix | send mail to DC to do further process ###
 |  |  |  |  |  |  |  |  |  | GLS Application | Application pref change | Set up issue | NA | Corrected the application preference value ###
 |  |  |  |  |  |  |  |  |  | OP | data fix | no issue | no ref | deleted the extra receiver_nbr and retriggered ran successfull ###    5/27/2011 6:04:21 PM b0palan  24736|gls2DecodeLoadPO.ec|glsDecodeLoadPO|92|2011-05-27 01:56:23|LOG|Return Code of GLSINTFCRetrieveRecordData = 0  24736|gls2Decode2000.ec|updateReceiversWithNewDCSArea|2379|2011-05-27 01:56:23|SQL|Error in Executing updateRcvLinesWithNewDCSArea_upd SQL(-284,0,2) []   A subquery has   returned not exactly one row.    24736|gls2Decode2000.ec|glsDecode2000|791|2011-05-27 01:56:23|LOG|About to call logProcessError function  24736|gls2LoadPO.ec|main|501|2011-05-27 01:56:23|LOG| gPurOrdId[437247] gPONbr[[PHONE]]    5/27/2011 6:05:44 PM b0palan  there was two receiver_nbr for one pur order id,deleted one receiver_nbr from dc_ receiver_line and dc_receiver .retriggered ran successfully.
 |  |  |  |  |  |  |  |  |  | No issue ###
 |  |  |  |  |  |  |  |  |  | GLS Pallet movement | Data Fix | User Request | NA| User wanted to cancel the moves ###
 |  |  |  |  |  |  |  |  |  | GLS | Environment | No Action | NA | NA ###
 |  |  |  |  |  |  |  |  |  | Application | Retriggered | PO lines were retransmitted to HOST###
 |  |  |  |  |  |  |  |  |  | GLS - Invoice | System | NoAction | No issue | NA | NA ###
 |  |  |  |  |  |  |  |  |  | GLS Invoice | No Action | Application - Defect | Defect Id: 29436 | [NAME] due to DB lock ###
 |  |  |  |  |  |  |  |  |  | OP|No action |No logs available|NA###
 |  |  |  |  |  |  |  |  |  | GLS | Environment | No Action | NA | NA ###
 |  |  |  |  |  |  |  |  |  | |Application|data Fix|QA|Defect#30094|###
 |  |  |  |  |  |  |  |  |  | IHC| Application| NA| Checked and found that PO was received and updated ####
 |  |  |  |  |  |  |  |  |  | OP | Setup | Retriggered | NA | Voided the problematic item orders and reran the gls2Allocation Job ###
 |  |  |  |  |  |  |  |  |  | GLS-Management|Added script to RM###
 |  |  |  |  |  |  |  |  |  | DBPurge | No action | No issue | NA | NA ###
 |  |  |  |  |  |  |  |  |  | IHC | no action | clarification |NA
 |  |  |  |  |  |  |  |  |  | track 3 | data Fix | Application | defect #30429 | ###
 |  |  |  |  |  |  |  |  |  | IHC | Retrigger | Application | Defect #29326 | Missing Item Information ###
 |  |  |  |  |  |  |  |  |  | OP | DataFix  | Host | NA| The site had difficulty in routing the containers of item having Weight_qty as 18000 LB ###
 |  |  |  |  |  |  |  |  |  | Common | Procedure | Data - Fix | | ###
 |  |  |  |  |  |  |  |  |  | Receiving | Data - Fix | Procedure | | ###
 |  |  |  |  |  |  |  |  |  | MGDS-Receiving|system|Resolved automatically|Unable to update user_operation table as we found existing on activity table. Once the lock got released, site were able to print ###
 |  |  |  |  |  |  |  |  |  | IHC | Re-triggered | Application | defect #30162| Item load failed due to an exception###
 |  |  |  |  |  |  |  |  |  | IHC | Re-triggered | Application | defect #30162| Item load failed due to an exception###
 |  |  |  |  |  |  |  |  |  | IHC | Re-triggered | Application | defect #30162| Item load failed due to an exception###
 |  |  |  |  |  |  |  |  |  | Procedural | Data FIx | updated slotted quantity in dc_receiver_line ###