vwiki

User Tools

Site Tools

Trace: • gfn_einfuehrungsveranstaltung
rm28870

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
rm28870 [2019/01/21 14:28] – [Material Master Data] kalaschnikowrm28870 [2019/01/21 14:31] (current) – [NCR] kalaschnikow
Line 1: Line 1:
 +====== rm28870 PO - "Send Mail" Function doesn't work any longer ======
  
 +
 +[[https://cust-projects.seeburger.de/redmine/issues/28870|rm28870 Divers - "Send Mail" Function doesn't work any longer]] 
 +    * **-** Änderungen müssen an folgenden Stellen gemacht werden:
 +      * **-** SBInvoice
 +      * **-** Material Master Data
 +      * **-** ...
 +    * Test ''SASUrlHelperTest.testMakeDeepLinkToDocumentDetailsScreen_checkJSONForLinkCreation()'' korrigieren
 +    * Eine Änderung an der Filterstruktur verursacht den Bug. Die Änderung ist in [[https://cust-projects.seeburger.de/redmine/issues/28897|rm28897]] beschrieben. Eine vollständigere Version ist im Notepad++.
 +    * Frank und Volker korrigieren den Fehler (aus [[https://cust-projects.seeburger.de/redmine/issues/28897|rm28897]]) nur auf der Client-Seite. D.h. es wird wieder knallen.
 +    * Meine Aufgabe ist:
 +      * die Filter, die auf die "neue" Art gebaut wurden in den Screens richtig parsen.
 +      * Evtl. eine zentrale Methode dafür schreiben
 +  
 +<code>
 +11:49:58,808 INFO  [stdout] (http-10.226.210.139:8080-5) Caused by: java.lang.NullPointerException
 +11:49:58,808 INFO  [stdout] (http-10.226.210.139:8080-5) at com.seeburger.airsupply.po.client.control.PODetailsDataScreen.getJsonResponse(PODetailsDataScreen.java:144)
 +11:49:58,808 INFO  [stdout] (http-10.226.210.139:8080-5) at com.seeburger.smarti.sui.control.screens.SimpleAjaxScreen.show(SimpleAjaxScreen.java:66)
 +11:49:58,808 INFO  [stdout] (http-10.226.210.139:8080-5) at com.seeburger.smarti.sui.control.screens.SuiTableScreen.show(SuiTableScreen.java:799)
 +11:49:58,808 INFO  [stdout] (http-10.226.210.139:8080-5) at com.seeburger.smarti.sui.searchform.control.screens.SUISearchHandlerScreen.show(SUISearchHandlerScreen.java:269)
 +11:49:58,808 INFO  [stdout] (http-10.226.210.139:8080-5) ... 24 more
 +</code>
 +
 +===== Prozesse =====
 +
 +==== Alerts ====
 +
 +=== Forecast Alerts ===
 +
 +''FCAlertMonitorConnector.getDeepLink()'' macht einen Deep link.
 +
 +Beim normalen Fluss bei dem Aufruf von "Details" (Datei ''fcCollabTabs.js'') der Handler für ''btnFCCollabOverviewCreateCollabDetails'' leitet an den Screen mit der URL ''fcCollabDetailsHeader'' (-> ''FCCollabDetailsHeaderScreen'').
 +
 +
 +=== Testlinks ===
 +
 +== Forecast ==
 +Looong_FC:\\
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=8791e7941f003f2911fd0e83f696dee9
 +
 +Forecast_1:\\
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=96f9a099b9a404d45388179c7ba4c7ee
 +
 +Looong_FC_3:\\
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=61a23a6e202d7a6f2e04485306d84d45
 +
 +
 +Looong_FC:\\
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=4fc511e169f48e938ba9b62f33203b29
 +
 +
 +== PO ==
 +
 +PO Alert "GBU_PO_GoodVer003"\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=e43388f3157d8f490038857628a8a813
 +
 +PO Alert "GBU_PO_GoodVer004"\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=b391b93f8766efef8b349acd47a8ef65
 +
 +== MD ==
 +
 +MD Alert "VKN_VMI_REGR_C002"\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=6ffb9c38bfa485eaabd43a2370514ebe
 +
 +MD Alert "VVK_VMI_REGR_C001"\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=eafe3620f4ecb37eb1403289c12ce145
 +
 +== NCR ==
 +
 +NCR Alert "VVK_20181115_001_POM"\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=befd2ab4fb2d26dbec2a8f5f2a771526
 +
 +
 +NCR Alert "test12346abcdef"\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=e11dd93f5846852c7002f038163f1538
 +
 +== SBI ==
 +
 +SBI Alert "2000017"\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=beb7fca90f5a82982c6f7a01203fae9e
 +
 +SBI Alert "2000018"\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=b43267f8e55926cd651ae80fac31b12a\\ 
 +
 +== VMI == 
 +
 +BEH_VMI_REGR_C001:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=85da24786d1646c72ab21f706d85d630
 +
 +VVK_VMI_REGR_C001:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=a322a51e89cb8e2b9456a614cb5d11af
 +==== ASN ====
 +=== TestLinks ===
 +
 +40002:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=dffc3048a8e36c31928f77d12c29f9f2
 +
 +393:\\
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=782f444cd5e0aa9513d01fe994ecca40
 +
 +
 +
 +
 +==== Demand Details ====
 +
 +<code sql>
 +SELECT * FROM TAIRMATERIAL where CMATERIALID=1582214 -- VVK
 +
 +SELECT * FROM tPartSeller_VMI where cOrderId=1582214 -- VVK
 +
 +-- VMI Summary statement
 +WITH alert_status AS (SELECT * FROM (SELECT cobjectreference calertmatid, cpriority, cdateoccurence, ROW_NUMBER() OVER (PARTITION BY cobjectreference ORDER BY cpriority DESC, cdateoccurence ASC) AS rn 
 +FROM tairalert WHERE ccatid = 1 AND (cdateinactivation IS NULL OR cdateinactivation = 0)) WHERE rn = 1)
 +SELECT cVMIREFNO,CSTATUS,cStatusRelCalc,CSTOCKONHAND,CALERTDATE,CCONSACTUALSTOCK, CCONSBLOCKEDSTOCK,CCONSQASTOCK,COWNACTUALSTOCK, COWNBLOCKEDSTOCK, COWNQASTOCK, CACTDYNAMICMIN, CACTDYNAMICMAX, CUNCONSUMEDDEMANDSTHROUGHTODAY, CDOCK, cDifToMin, cVMIRefNo, cCoverWithinTransit, cCoverWithoutInTransit, cNextPlannedRecQty, cNextPlannedRecDate, cPriority, cDateOccurence ,CORDERNO, CVERSION,CACTTRANSITQTY, CSUMTRANSITQTY, CINTRANSITBACKLOG,CDEMANDBACKLOG, cDemandBackLogTillToday, CNETDELQTY, CGROSSDELQTY, CNETDELUNITS, cActFinalDeliveryLocation , TAIRPARTNERRELATION.*, TAIRORDERINGOFFICER.*, TAIRMATERIAL.* FROM tAirPartnerRelation, tAirOrderingOfficer, tAirMaterial LEFT JOIN tPartSeller_VMI ON cMaterialId=cOrderId LEFT JOIN alert_status ON cMaterialId=calertmatid  WHERE tAirMaterial.cRelationId_Material=tAirPartnerRelation.cRelationId AND  tAirMaterial.cOrderingOfficerId_Material=tAirOrderingOfficer.cOrderingOfficerId  AND ROWNUM <= 5000  AND (cCustomerPortalGroup IN (1))  AND (cSupplierCPId IN (-1000002,10006106,10006107))  AND cSupplierCGId = 100027 AND CISUNREGSUPPLIER = 0 AND (cMaterialId IN (1582214))  ORDER BY cStatus DESC,cStatusRelCalc DESC, cMaterialId ASC
 +
 +
 +-- Demand Details statement
 +SELECT distinct(cheaderid) FROM TAIRDEMANDS 
 +INNER JOIN TAIRDEMANDSPOS ON TAIRDEMANDS.CHEADERID = TAIRDEMANDSPOS.CDEMANDSID 
 +INNER JOIN tAirPartnerRelation ON TAIRDEMANDS.cDemandRelationId = tAirPartnerRelation.CRELATIONID 
 +INNER JOIN tAirOrderingOfficer ON TAIRDEMANDS.cDemandOrderingOfficerId = tAirOrderingOfficer.CORDERINGOFFICERID 
 +INNER JOIN TAIRMATERIAL ON TAIRDEMANDS.cDemandMaterialId = TAIRMATERIAL.CMATERIALID 
 + WHERE 1 = 1  
 + AND ROWNUM <= 5000  
 + AND (cCustomerPortalGroup IN (1))  
 + AND (cSupplierCPId IN (-1000002,10006106,10006107))  
 + AND cSupplierCGId = 100027 
 + --AND CISUNREGSUPPLIER = 0 
 + AND cHeaderId = 18210 -- -> if I comment it out, I will receive a lot of records
 + --AND cIsPending = 0 
 + --AND cIsCurrent = 1 
 + AND cMaterialId = 1582214
 +</code>
 +
 +=== Testlinks ===
 +Supplier Material Number: VKN_VMI_REGR_S002\\ 
 +Demand Details:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=cd734519ba9ca1af4fbfc88203fbe439
 +\\ 
 +Demand History:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=fbbc5fb84e9c55e8fb91ba0ccd57c270\\
 +MD Alerts:\\
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=3718e2f97d86f9ec0200bf17eb7b5902\\
 + 
 +Supplier Material Number: VVK_VMI_REGR_S001\\ 
 +Demand Details:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=8bffff5465576f1c79c9d37d93463e7e \\ 
 +Demand History:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=e31437e31ba1fa23eec944f3b5666a61\\ 
 +MD Alerts:\\
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=b82370a1adfc3b62cfab2eca4a0554b3\\ 
 +
 +
 +==== Forecast ====
 +=== Testlinks ===
 +== Forecast Summary (Overview) ==
 +Looong_FC:\\
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=61a23a6e202d7a6f2e04485306d84d45
 +
 +Forecast_1:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=96f9a099b9a404d45388179c7ba4c7ee\\ 
 +
 +== Forecast Data (Overview) ==
 +Looong_FC:\\
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=61a23a6e202d7a6f2e04485306d84d45
 +
 +Forecast_1:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=96f9a099b9a404d45388179c7ba4c7ee\\ 
 +
 +
 +== Collab View (Overview) ==
 +
 +Forecast_1:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=96f9a099b9a404d45388179c7ba4c7ee\\ 
 +
 +== Collab View ==
 +
 +Forecast_1:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=96f9a099b9a404d45388179c7ba4c7ee\\ 
 +
 +
 +
 +==== KPI ====
 +=== Testlinks ===
 +-/2018-10/-/AFR1/.../25,00/1,04\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=0ac31164bb262f1aff84ea529347e00b
 +
 +-/2018-10/AFR_FAL/AFR1/.../25,00/4,35\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=e96336c76e8f4bb0ccc6fb8783e3306a
 +
 +
 +==== Material Master Data ====
 +=== Testlinks ===
 +
 +== Overview ==
 +
 +AME_MD-AFR-0007:\\
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=37a52356c84c26d3c51d4ebe89ba2f93
 +
 +ABC_2:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=0b49b2c647db5c59f1eb6502de8e9a1b\\ 
 +
 +A-LIE-AA-30948:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=804d83e13d8261dc13d52adfda445622\\ 
 +
 +
 +== Details ==
 +
 +ABC_2:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=0b49b2c647db5c59f1eb6502de8e9a1b\\ 
 +
 +A-LIE-AA-30948:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=804d83e13d8261dc13d52adfda445622\\ 
 +
 +==== NCR ====
 +=== Testlinks ===
 +
 +VVK_20181218_001_POM:\\
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=f71569398b76abb56e29e17309423af5
 +
 +SAFRAN Record:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=e5d9720e69fce01520e5796b2499cdc9
 +
 +==== PO ====
 +
 +=== Testlinks ===
 +
 +From "PO Overview" screen
 +
 +AME_W20008310221/10/10:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=d3d415207eec891ac9c35a4985d9fc00
 +
 +AME2_EDI_000001/10/1:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=655c580461b5cfb28b9a82aeb35692d6
 +
 +
 +From "Schedule Lines" (Overview) screen:\\
 +
 +AME_W20008310221/20/10:\\
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=8a29dcf32841c782f0ba743aceaedaf4
 +
 +
 +From "Schedule Line details" screen:\\ 
 +
 +AME_W20008310221/30/10:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=67bf0454a7c74d49d1f6da261b9f8d3f
 +
 +From "Create ASN" screen
 +
 +PO/VMI Reference: PerfSpr_00000301\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=04abedf6ad01322ed9910a0ad5d2b6b9
 +PO/VMI Reference: PerfSpr_00000251\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=c1410f9fe636c85d8575658aa07fd6c0
 +
 +
 +==== SBInvoice ====
 +
 +  * **+** Link SBI Overview -> Details
 +  * **+** Link SBI Alerts -> Details
 +  * **+** Send mail SBI Overview
 +  * **+** Send mail SBI Details (Details)
 +  * **+** Send mail SBI Details (Header)
 +  * **+** Send mail SBI Alerts
 +
 +
 +=== Testlinks ===
 +
 +2000015:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=e50c43c90ecd6f9e812ae156fa54a16d
 +
 +2000016:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=7728b069ccdebd2a6a315411697e5214
 +
 +2000019:\\ 
 +
 +Send mail from SBI Alert Overview:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=9cf11cc7e500dcf1d7854758c3382071\\ 
 +Send mail from SBI Overview:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=44faf27340e4cae961cd158cd9e0dd63\\ 
 +
 +2000020:\\ 
 +
 +Send mail from SBI Alert Overview:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=09a81d5bf3a0b9d75d9fd51ed75f8d2f\\ 
 +Send mail from SBI Overview:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=997d0c7a023a22340fc0138e6336681d\\ 
 +
 +
 +==== Stock Movements ====
 +
 +=== Testlinks ===
 +
 +rm27328_003:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=2bad89e85b33e6a729092479dc92557c
 +
 +==== VMI ====
 +=== Testlinks ===
 +VVK_VMI_REGR_S001:\\ 
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=450b1bec7e559925362300bbbeae6a94
 +
 +VKN_VMI_REGR_S002:\\
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=72fac29e5db7a483a5d46cc1d3ac6a0b
 +
 +==== Testlinks ====
 +
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=626784327eaa0a377cc25a63f4e453ef
 +
 +Material:
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=ddc4c69a5d5c1c12e5e922eede3660d3
 +
 +
 +Order(?):
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=9deb6c1305747f5e51140001c24f0407
 +
 +
 +
 +
 +
 +VMI Inventory Projection
 +=========================
 +Supplier Material Number: VVK_VMI_REGR_S001
 +http://kalaschnikowv01:8380/security/login?followURL=/security/login?flh=8e7186c62101ad2d4330c45dbfadbf95 -> Inventory Projection
 +
 +
 +
 +====== Tests ======
 +
 +  * **+** VMI Demand Details Screen Deep Link Generation By Supplier and Access By Authorized Customer
 +  * **+** VMI Demand Details Screen Deep Link Generation By Supplier and Access By Authorized Supplier
 +  * **+** VMI Demand Header Screen Deep Link Generation By Supplier and Access By Authorized Customer
 +  * **+** VMI Demand Header Screen Deep Link Generation By Supplier and Access By Authorized Supplier
 +
 +  * **+** VMI Demand History Screen Deep Link Generation By Supplier and Access By Authorized Customer
 +  * **+** VMI Demand History Screen Deep Link Generation By Supplier and Access By Authorized Supplier
 +
 +  * **+** Material Details/Overview Screen Deep Link Generation By Supplier and Access By Authorized Customer
 +  * **+** Material Details/Overview Screen Deep Link Generation By Supplier and Access By Authorized Supplier
 +  * **+** MD Alerts Screen Deep Link Generation By Supplier and Access By Authorized Customer
 +  * **+** MD Alerts Screen Deep Link Generation By Supplier and Access By Authorized Supplier
 +
 +  * **+** SBI Alerts Screen Deep Link Generation By Supplier and Access By Authorized Customer
 +  * **+** SBI Alerts Screen Deep Link Generation By Supplier and Access By Authorized Supplier
 +  * **+** SBI Overview Screen Deep Link Generation By Supplier and Access By Authorized Customer
 +  * **+** SBI Overview Screen Deep Link Generation By Supplier and Access By Authorized Supplier
 +  * **+** SBI Header Screen Deep Link Generation By Supplier and Access By Authorized Customer
 +  * **+** SBI Header Screen Deep Link Generation By Supplier and Access By Authorized Supplier