The timing of Integrated-Margin procedure.
Timing : FR time
Date : Count on FR working day
1, 1st FR working day of each month 23:30PM a BW job will start transfer RCS Cost Estimate data to BW.
PC : CCR Monthly Process Chain(RPC_CCR_PCP1_MTHLY_CHAIN)
2, 2nd FR working day of each month 2:00AM a BO PPE job will be run to upload QL QUIK_GL_COST_PURCHASE data into BO.
3, 2nd FR working day of each month 23:00PM a BW process chain will be run to calculate the Integrated-Margin.
PC: Integrated Margin(RSP_COPCP_MONTHLY)
(These BW process chain will get the purchase price from BO.)
Start Update about Project 8612 - Solstice:
When Chain RSP_COPCP_MONTHLY is finished, the chain PC_CO_PC_MM_04 in CPX system will be executed.
PC_CO_PC_MM_04 will calulate the integrated margin for vault information (with help of data from WDP and WBP).
When PC_CO_PC_MM_04 is finished a flat file (in directory /exploit/BW/integrated_margin/OH_COMM01.CSV) is sent in WBP server with help of webmethods to use informations from CPX into the calcul of integrated margin in WBP.
Webmethods is triggered with program ZBW_REST_SERVICE_IM.
The webmethods will sent the flat file from CPX to WBP and after that launch the process chain PC_INT_MARGIN (WBP) to finish the integrated margin calculation wih data from WBP (so WP1) and CPX.
Step 1: RSP_COPCP_MONTHLY (WBP)
Step 3: PC_INT_MARGIN (WBP)
We splitted the old version of RSP_COPCP_MONTHLY chain in two chains:
RSP_COPCP_MONTHLY to load the source of data and PC_INT_MARGIN to retreive result of IM from CPX (in dso ABDSOPCP1) and calcul the IM in WBP side.
More details about the split here:
https://docs.google.com/document/d/1QbjsKm0qxUuWNk2E7gntCDq1NIirYi8huKzaSJRp9zU/edit#
End of update project 8612 - Solstice
4, 3rd FR working day of each month 6:00AM-8:00AM a BO job will be run, transfer Integrated-Margin from BW to BO.
Automator Graph : PR_ECO_MBI
5, 3rd FR working day of each month 13:00PM-14:00PM, a BO job will be run, Copy the WP1 Intergrate-Margin data to PF1
Automator Graph : PE_ECO_QL, POST-TREAMENT
(In BO there is a table maintain the Mapping Plant betwee WP1 & PF1)
From the time table, if the QL data was uploaded by 1st FR working day of the month, it will be automatic updated. Otherwise we have to run it by manual.