User Tools

Site Tools


rm28870

rm28870 PO - "Send Mail" Function doesn't work any longer

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 rm28897 beschrieben. Eine vollständigere Version ist im Notepad++.
  • Frank und Volker korrigieren den Fehler (aus 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
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

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).

Forecast
PO
MD
NCR
SBI
VMI

ASN

TestLinks

Demand Details

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

Testlinks

Forecast

Testlinks

Forecast Summary (Overview)
Forecast Data (Overview)
Collab View (Overview)
Collab View

KPI

Testlinks

Material Master Data

Testlinks

Overview
Details

NCR

Testlinks

PO

Testlinks

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

Stock Movements

Testlinks

VMI

Testlinks

Testlinks

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
rm28870.txt · Last modified: by kalaschnikow