Step What to check ?Where to check ?How to check ?
#1Check status of all the monthly jobsDscp DiPx batch execution report 
  • emails from DSCP_Solvay (sent ONLY when job issue) // Maggie already checks => to be checked when no news from Maggie 

  • In case if a job running with error, open the log file joined to the mail and search for errors messages : 
  • Analyse the root cause of the error and communicate with DIP PP team and interface team to solve it


Workspace SBS - Technical view
  • Check all job status 

#2Run jobs if necessary 

Administrator / Macros / Shared macros

(normally must be executed by interface team) 

In case of an error, must be executed by interface team (no action on our side) 

#3Execute Monthly Task sequenceConfiguration / Task sequences/ Shared sequences

In case there was an error during the automatic execute monthly task sequence only:

In DIP1



In DIP4 

/!\ SILICA : For Silica, the update U00 → U02 is done every Sunday. When the first day of the month is on a Saturday or a Sunday, BW files are created and updated in DIP only the following Monday (because of issues in the file generation). So in this case, the update U00 → U02 needs to be manually launched, and then a full loop has to be run.

Last Dynamic Impact has to be Sunday's date

=> in case of issue, run task sequence U00>U02 :   001 Execute : SILICA : Import dynamic datas U00 >>U02

Last Full loop has to be Sunday's date

=> in case of issue, run Full DiP-PP Loop : 011 Execute : SILICA : Full DiP-PP - WW 


DSCP DiP4 Prod → Home → Workspace: SBS-CONTROL VIEW → Sheet: U02 - SI
image2023-10-16_9-15-43.png

#4Verify the Horizon rotationGBUs workspace 

*Checked by interface team 
Open some views (example DRP views) and check the change of month

DSCP1 - workspace P3M || EU SAD SODA => current month has to be in blank color

#5Check Imported datasStructure / User models / U00 - IN Import / Data tables

Monthly stocks are coming from file EOMSTOCK, and keep in mind plant transcodifications are in place.

Ex DiP5 transo TAES to TAHS. Both quantities have to be sum up to get DynaSys one

Check data consistency of the most important data : 

I500 - Imported stock datas (day) > I500 Initial Inventory (MD04 +MB5B for movements)

      =>For SILICA => Homologated inventory
      plant 7528 in SI DIP = plant 7525 in SAP

I402 End of month unrestricted Inventory (MB5B with last day of the previous month in date)

I402 - Actual Shipped at GI - site dim (MB51 from beginning to end of last month movement 601)
(Attention for Silica: in case of inconsistency, you might check the movements 633; because the movement is from shipped to consignment. Also movements 643 for cross company ) 

Check Actual production (a completer) (MB51 from beginning to end of last month movement 101&102 and also 131). Gaps can match by verifying that the movements from the last day of the previous month are taken into account in the current month.

For examples on 0278, 7525 

I400 - Intransit inventory in receipt date (MB5T) : Attention, not to check the shipto for this datafield; only for intersites. 

I400 Firm Shipment in shipping (MD04 customer order + Deliveries) : check the "MRP element" 

I002 Final Forecast in ETD (DP side: User models/U99/Data tables/Export| BW/DIP-PP - Material:Shipto@DC/ Final Forecast ETD). 
*

I500 Blocked stock (MMBE : Blocked Stock + Blocked Stock Returns)



You need to compare with SAP or DP data to be sure that everything is ok.
In DP, user "DIP" can be used. 


#6Check general S&OP dataS&OP workspace
  • Maybe to be removed

    Select some  key products (most produced, most sold, basic products) and check some indicators (Ensure that the important KPIs are not 0) 

Arithmetical inventory (should not be 0 if there are inputs) 

Shipping plan vs Shipping requirements, (if any requirement is there, there should be also shipping plan) 

Global Balance reports


#7Specific Silica - Transit inventoryU00 - Actuals Month

Check the Transit inventory SILICA => We must have data for the previous month

Compare results between the 2 parameters as well as the total quantity on M-1 of the parameter I402 - End of month transit inventory SILICA, must be equal to the Sum of all quantities in transit of the paramter  I400 Intransit inventory in receipt date

If there is some gap:

-Check in SAP (mb5t) if it match with Intransit inventory in receipt date

-For Silica, we take In transit inventory in receipt date that we archive on the last day of the month to plug it into the actuals. We do not take the U00 Actuals to display it in the Silica screens.

#8Check SAP Independent requirementsMD63 in SAP

Check between SAP and Dynasys the Forecast exported

=> Take 3 SKUs PW as examples by BU


> Novecare : in DIP, Final Demand after netting (last validated) in CS model

!!! Please take examples from Sites where forecast export is activated!!!

!!! Please take examples when forecast is different from 1 month to another !!!

You can use this specific Grid view to help the monitoring.



In MD63, please fill the Plant/Material and the month to check.



> Special Chem: (in progress) : to be completed


> TS:

  • For Mining & Phosphorus : compare DP, Final Forecast in U99 and SAP MD63
  • For PA : the Final forecast after netting and supersession is sent to DP and then from DP to SAP

Compare DIP Final demand ETD after netting and SAP MD63




#9Check the BOM level Monitoring workspace

BOM level Alert Novecare/ TS (in the monitoring workspace) 

#10Check constrained demand sent to SAP (Perox & SA&D)in SAP, SE16 transaction, table Z1V_FORECAST_DS

Compare U99

Peroximage2022-3-30_15-2-43.png / SODA 

with SAP :

image2022-4-22_12-10-59.pngimage2022-4-22_12-11-42.png

We export to SAP the current month + 3 months


For DIP3:


#1Check status of all the monthly jobsSBS - Technical views
  • Already checked by interface team
    Before starting the checks, be sure that the dynamic import is finished.

If not → wait until it end

#2




#3 NOVECARE - Consistency of data

OBSOLETE  Simulate Felix account (FLESSARD) and be open A2. SOP Planning


simulate MGBA6210

Find a SKUs as example and check the following data:

  • Initial inventory = between DIP and SAP (MB5B)
  • Firm independent requirement= between DIP and SAP (MD04)
  • Firm planned order = between DIP and SAP (MD04)
  • Intransit = between DIP and SAP (MD04)
  • Forecast = between DP and DIP (Final Forecast ETD) (ex of DFU: 98673R@55099R)
  • External purchase from SAP = between DIP and SAP (MD04)
  • Firm receipt ETA = between DIP and SAP (MD04)

Check the projected inventory calculated by the DRP is correct 

Check that the final demand after netting seems ok.

Check that export to BW batch has run without error (SBS technical view)

#4Check SAP Independent requirementsMD63 in SAP

Check between SAP and Dynasys the Forecast exported

=> Take 3 SKUs PW as examples by BU


> Novecare : in DIP, Final Demand after netting (last validated) in CS model

!!! Please take examples from Sites where forecast export is activated!!!

!!! Please take examples when forecast is different from 1 month to another !!!

You can use this specific Grid view to help the monitoring.



In MD63, please fill the Plant/Material and the month to check.

#5Communication

Send an email to the DIP3 users


to:    "$DynaSysUsersDiP3 (Novecare)"

          <DynasysUsersDiP3@solvay.com>


Dear All, 

The monthly update is done. You can now connect into DIP.

SAP data will not be updated until the end of the netting process on the 6th of the current month. → Verify the date each month !

Next SAP data update takes place after S&OP validation on the 11th of the current month.  → Verify the date each month !

The remaining SAP data updates will take place every Saturday until the end of the current month.

Regards.








Checks to do after the validation of S&OP 


Check the archive of S&OP Validation archive  
+1 day after the S&OP Validation 

  • Check if the archiving is done correctly => to create a view with the date of archiving (calculation to be added in the sequence)

 Z800 should be equal to S&OP Validation  of Month M for M+1