Analyse van orchestratie fouten in de fouten tabel van JD Edwards. Ga naar DAS en start het rapport "Exception monitoring - F980060 - rapportage (F980060).

Start dan het rapport op door op de knop "Rapport uitvoeren" te klikken:

Klik daarna op de excel button, dan worden de gegevens gedownload naar excel.

In excel kun je dan beter kijken wat er fout gegaan is. Selecteer het hele werkblad (stap 1), klik daarna op verticaal en kies voor Boven. En klik op Terugloop, als laatste stap klik op de OK button (stap 4).

Bijvoorbeeld, fout: sales-order-confirmation-wms-ex.

JSON:

{"jsonInput":{"message":{"message-date":"20260804","message-time":"085321","message-type":"sales-order-confirmation-wms-ex","message-id":"71574","salesorders":[{"salesorder":[{"sor-account-code":"1500","sor-order-code-account":"26017079","sor-salesorder-number":"150812","sor-shipping-agent-code":"AB TEXEL DISTRIBUTION B.V.","sor-eta-delivery-date":"20260805","sor-eta-delivery-time":"0000","sor-wh-order-code-wms":"130950","sor-container-empty-weight":"0","details":[{"detail":[{"sod-customer-line-number":"1","sod-item-code":"01162200400","sod-stock-type":"N","sod-quantity":"2","sod-quantity-ordered":"2","shippingunits":[{"shippingunit":[{"shu-shippingunit-code":"DRA000008064528","shu-sscc-code":"000000000000000000","shu-emballage-code":"KB","shu-gross-weight":"50.0","shu-net-weight":"50.0","shu-quantity":"2","sourcepallets":[{"sourcepallet":[{"sop-batch-code":"988630","sop-best-before-date":"20270704","sop-quantity":"2","sop-sscc-code":"000000000000000000","sop-pallet-ref-supplier":"988630005"}]}]}]}]},{"sod-customer-line-number":"2","sod-item-code":"01281200400","sod-stock-type":"N","sod-quantity":"40","sod-quantity-ordered":"40","shippingunits":[{"shippingunit":[{"shu-shippingunit-code":"DRA000008262009","shu-sscc-code":"000000000000000000","shu-emballage-code":"KB","shu-gross-weight":"1000.0","shu-net-weight":"1000.0","shu-quantity":"40","sourcepallets":[{"sourcepallet":[{"sop-batch-code":"987705","sop-best-before-date":"20270623","sop-quantity":"40","sop-sscc-code":"000000000000000000","sop-pallet-ref-supplier":"987705024"}]}]}]}]},{"sod-customer-line-number":"3","sod-item-code":"02101100101","sod-stock-type":"N","sod-quantity":"1","sod-quantity-ordered":"1","shippingunits":[{"shippingunit":[{"shu-shippingunit-code":"DRA000007830559","shu-sscc-code":"000000000000000000","shu-emballage-code":"HE","shu-gross-weight":"10.0","shu-net-weight":"10.0","shu-quantity":"1","sourcepallets":[{"sourcepallet":[{"sop-batch-code":"983747","sop-best-before-date":"20270511","sop-quantity":"1","sop-sscc-code":"000000000000000000","sop-pallet-ref-supplier":"983747002"}]}]}]}]},{"sod-customer-line-number":"4","sod-item-code":"02308100101","sod-stock-type":"N","sod-quantity":"1","sod-quantity-ordered":"1","shippingunits":[{"shippingunit":[{"shu-shippingunit-code":"DRA000007830559","shu-sscc-code":"000000000000000000","shu-emballage-code":"HE","shu-gross-weight":"10.0","shu-net-weight":"10.0","shu-quantity":"1","sourcepallets":[{"sourcepallet":[{"sop-batch-code":"980764","sop-best-before-date":"20270403","sop-quantity":"1","sop-sscc-code":"000000000000000000","sop-pallet-ref-supplier":"980764003"}]}]}]}]}]}]}],"Emballage":[{"EmballageCode":"HE","EmballageQuantity":"1"},{"EmballageCode":"KB","EmballageQuantity":"2"}]}]}}}

 

Foutmelding:

{"message":{"Orchestration: sales-order-line-confirmation-wms-ex":{"message":{"ServiceRequest: FR_P42101_add_emballage":{"App Stack Form Exception":{"Expecting Form":"P42101_W42101C","Resulting Form":"P5542101_W5542101A_Q13100"},"JAS Response":{"fs_P5542101_W5542101A":{"title":"Shipping Additional Information","data":{},"errors":[{"CODE":"0294","TITLE":"Error: Item Branch Record Does Not Exist","ERRORCONTROL":"33_21.0.0","DESC":"CAUSE. . . . . An Item Branch record (F4102) does not exist for this item in the Branch/Plant specified.\\u000aRESOLUTION . . Correct the Branch or enter an Item Branch record for this item in Branch Plant Item Information (P41026).","ALIAS":"LITM","CONTROLTITLE":"2nd Item Number","ROWINDEX":"0","MOBILE":"An Item Branch record (F4102) does not exist for this item in the Branch/Plant specified."},{"CODE":"0294","TITLE":"Error: Item Branch Record Does Not Exist","ERRORCONTROL":"33_21.0.7","DESC":"CAUSE. . . . . An Item Branch record (F4102) does not exist for this item\\u000a               in the Branch/Plant specified.\\u000aRESOLUTION . . Correct the Branch or enter an Item Branch record for this\\u000a               item in Branch Plant Item Information (P41026).","ALIAS":"UITM","CONTROLTITLE":"Unformatted Item Number","ROWINDEX":"0","MOBILE":"An Item Branch record (F4102) does not exist for this item\\u000a               in the Branch/Plant specified."},{"CODE":"3690","TITLE":"Error: Location not in Item Location File","ERRORCONTROL":"33","DESC":"CAUSE . . . . This Item/Branch/Location/Lot combination is not set up in the\\u000a              Item Location file (F41021).\\u000aRESOLUTION. . Enter a valid Item/Branch/Location/Lot combination in the Item\\u000a               Location file.","CONTROLTITLE":"Add Pallets","ROWINDEX":"0","MOBILE":"This Item/Branch/Location/Lot combination is not set up in the\\u000a              Item Location file (F41021)."}],"warnings":[]},"stackId":24,"stateId":3,"rid":"e01afecb0936ac17","currentApp":"P5542101_

 

Analyse:

Uit de foutmelding blijkt dat Kooiker spullen heeft verstuurd op een HE pallet. Deze HE pallet is niet bekend bij meel.

Oplossing:

Aanmaken van het artikel HE in het filiaal van meel. 

Applicatie is P41026, zoek op het artikel HE (voer in bij stap 1 en klik op de zoeken button stap 2). Selecteer de regel en klik op de kopieer button (stap 4).

 


 

 

Issue met pre-notification-External-purchase-order:

JSON:

{"jsonInput":{"message":{"message-date":"20260804","message-time":"140129","message-type":"PRE-NOTIFICATION-INBOUND-PURCHASE-ORDERS","message-id":"138685972","prenotifications":[{"prenotification":[{"pnc-account-code":"2500","pnc-inbound-order-code-account":"70023215","pnc-pre-notification-number":"55747","details":[{"detail":[{"pnd-line-number":"1","pnd-item-code":"04003300301","pnd-stock-type":"N","pnd-batch-code":"0012135555","pnd-best-before-date":"20270716","pnd-quantity":"600","pnd-net-weight":"9000000","pnd-gross-weight":"9000000","pallets":[{"pallet":[{"pnp-stock-code":"VRR000001580302","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12264191"},{"pnp-stock-code":"VRR000001580304","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12265788"},{"pnp-stock-code":"VRR000001580305","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12271413"},{"pnp-stock-code":"VRR000001580306","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12272878"},{"pnp-stock-code":"VRR000001580307","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12274109"},{"pnp-stock-code":"VRR000001580308","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12275993"},{"pnp-stock-code":"VRR000001580309","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12281235"},{"pnp-stock-code":"VRR000001580310","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12282698"},{"pnp-stock-code":"VRR000001580311","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12284328"},{"pnp-stock-code":"VRR000001580312","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12290652"},{"pnp-stock-code":"VRR000001580315","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12292486"},{"pnp-stock-code":"VRR000001580316","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12300430"},{"pnp-stock-code":"VRR000001580317","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12305083"},{"pnp-stock-code":"VRR000001580351","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12353577"},{"pnp-stock-code":"VRR000001580353","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12355256"}]}]}]}]}]}]}}}

 

Foutmelding:

{"message":{"ServiceRequest: FR_P4312_receive_purchase_order_Kooiker":{"App Stack Form Exception":{"Expecting Form":"P55LBL_W55LBLA","Resulting Form":"P4312_W4312A_Q130001"},"JAS Response":{"fs_P4312_W4312A":{"title":"Purchase Order Receipts","data":{},"errors":[{"CODE":"2745","TITLE":"Error: Lot/Serial Number Must be Entered","ERRORCONTROL":"1.0.48","DESC":"Cause. . . . . The item number is defined to use advanced lot/serial\\u000a               processing, and a lot/serial number must be entered.\\u000aResolution . . Enter a lot/serial number.","ALIAS":"RLOT","CONTROLTITLE":"Supplier Lot","ROWINDEX":"0","MOBILE":"The item number is defined to use advanced lot/serial\\u000a               processing, and a lot/serial number must be entered."}],"warnings":[{"CODE":"0678","TITLE":"Warning: Item Location Record Not Found","ERRORCONTROL":"1.0.35","DESC":"Cause. . . . . The item location record entered does not exist.\\u000aResolution . . This is a warning message and the item location record\\u000a               (F41021) referenced will be added when you press enter.","ALIAS":"LOCNE1","CONTROLTITLE":"Location","ROWINDEX":"0","MOBILE":"The item location record entered does not exist."}]},"stackId":2,"stateId":4,"rid":"209205adc20f7d9b","currentApp":"P4312_W4312A_Q130001","timeStamp":"2026-08-04:14.04.52","sysErrors":[]}}},"exception":"Exception","timeStamp":"2026-08-04T14:04:52.312+0200","userDefinedErrorText":"","status":"ERROR"}

 

Analyse:

De foutmelding advanced lot/serial, betekend dat voor elke ontvangst een leveranciers ordernummer moet worden ingevuld. Dit heeft Kooiker vergeten.

Oplossing:

Ga naar het artikel/filiaal record in de P41026 en voer het artikelnummer in en het filiaal. In dit geval is dat artikelnummer 04003300301 en filiaal 2500. Selecteer het regel en klik op het groene vinkje (stap 4).

 

Ga in het volgende scherm naar de tab “Partijverwerking” en verwijder in het veld “Serienummer vereist” (stap 2) het getal 3 en klik afsluitend op het groene vinkje.

Ga daarna naar de orchestration studio “https://jdepd.royalkoopmans.net/studio/login.html” en klik op de button “Orkestraties”.

Zoek naar de orchestration “pre-notification-External-purchase-order” in het Zoeken veld. 

Je komt in het orchestratie scherm. Klik op het icoontje bij stap1 en klik daarna op het icoon bij stap 2.

Zet de knop bij Onbewerkt naar rechts en verwijder de tekst in het scherm (bij stap 2).

Plak de JSON in het scherm voor de json input en klik op de button “Uitvoeren”.

{"jsonInput":{"message":{"message-date":"20260804","message-time":"140129","message-type":"PRE-NOTIFICATION-INBOUND-PURCHASE-ORDERS","message-id":"138685972","prenotifications":[{"prenotification":[{"pnc-account-code":"2500","pnc-inbound-order-code-account":"70023215","pnc-pre-notification-number":"55747","details":[{"detail":[{"pnd-line-number":"1","pnd-item-code":"04003300301","pnd-stock-type":"N","pnd-batch-code":"0012135555","pnd-best-before-date":"20270716","pnd-quantity":"600","pnd-net-weight":"9000000","pnd-gross-weight":"9000000","pallets":[{"pallet":[{"pnp-stock-code":"VRR000001580302","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12264191"},{"pnp-stock-code":"VRR000001580304","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12265788"},{"pnp-stock-code":"VRR000001580305","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12271413"},{"pnp-stock-code":"VRR000001580306","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12272878"},{"pnp-stock-code":"VRR000001580307","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12274109"},{"pnp-stock-code":"VRR000001580308","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12275993"},{"pnp-stock-code":"VRR000001580309","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12281235"},{"pnp-stock-code":"VRR000001580310","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12282698"},{"pnp-stock-code":"VRR000001580311","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12284328"},{"pnp-stock-code":"VRR000001580312","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12290652"},{"pnp-stock-code":"VRR000001580315","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12292486"},{"pnp-stock-code":"VRR000001580316","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12300430"},{"pnp-stock-code":"VRR000001580317","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12305083"},{"pnp-stock-code":"VRR000001580351","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12353577"},{"pnp-stock-code":"VRR000001580353","pnp-packaging-type":"HB","pnp-batch-code":"0012135555","pnp-best-before-date":"20270716","pnp-quantity":"40","pnp-net-weight":"600000","pnp-gross-weight":"600000","pnp-date":"20260804","pnp-time":"12355256"}]}]}]}]}]}]}}}