The new wiki link for this data flow is here:
Please update the doc there and no longer here.
General presentation
Objective of the application
The application loads data of the Plant Maintenance domain from RCS (system WP1 400) into BW (system WBP 400).
Data is extracted from PM module for Work Orders and Notifications, from CO-OPA module for Costs, and from CATS module (Cross-Application Time Sheet) for Times.
Data for Costs is also loaded from the systems RHO and PF1. The costs data from the three systems are used by FI application, but reporting on costs in WBP is done only for WP1 data.
Main documentation:
List of BEx Reports & Workbooks : CATALOG - Industrial & Planning Reporting (in the tab Maintenance)
List of contacts:
Meire SANTOS (SBS Information Services) : Reporting Leader
Christophe MALLEVAEY (SBS Information Services) : PM Process Expert
Usage information
Around 180 users on BW. The reports are used worldwide.
Roles & Access
Roles and access
- Authorization role : ZR_RCS_PM_A02: Maintenance Orders Applications - End User role
- Role menu : ZR_RCS_CA_M08: PM - Plant Maintenance
Reference : BW Catalog of Role
Authorization objects
- Company Code
Dataflow presentation
Overview
Functional and Technical rules on Workbench + Reporting
Data is extracted from standard extractors from system WP1 400: 2LIS_17, 0PM_OM_OPA_1 & 2, 0CA_TS_IS_1
Dependencies:
- It shares some extractors (2LIS_17_I3OPER, 0PM_OM_OPA_2) with MECANO.
- Data is consumed by ORACLE by the broadcast of a workbook (BCAST_ORACLE_PM) with PM costs, which is integrated manually by IS PM team.
- Data is loaded in cube CUB_PM for QV dashboard RCS KPI
- Costs data from all three systems (WP1/PF1/RHO) is used in FI cubes
Functional Rules:
- Alternative Labeling is used on Functional Location in the source system. The alternative label is loaded in the master data attributes.
Data loadings
Info providers and objects loaded
Infoproviers and Master data are grouped in the Application Area AREA_PM.
Process Chains included in the Global RSP_DAILY Process Chain:
- ZPC_MD_ATTR_RCS (For shared master data attributes and texts)
- RCS_PM_KPI (Load Cubes for RCS KPI application used by QV dashboard)
- RSP_PM
- RSP_PM_ACETOW (Load PM Costs data from RHO system for FI cubes)
- RSP_PM_SOLVAY (Load PM Costs data & Commitments and orders distribution rules from PF1 system for FI cubes)
- PC_PM_01
Others Process Chains:
- PC_PM_ORDER_WEEKLY
- PM_BACKLOG
Loading frequency
- Daily loadings Monday to Friday
- Weekly loadings for PC_PM_ORDER_WEEKLY & PM_BACKLOG
Average performance
The main process chain RSP_PM run in about one and a half hours.
PM Extractors (2LIS_17) are set up in delta with a delta queue. Costs on PM orders are loaded in full mode.
Historization
We keep all the data in the DSO and Cubes. Archiving is done on Source System.
Reporting
Queries Documentation or user guide
- CATALOG - Industrial & Planning Reporting (in the tab Maintenance)
Main queries
- CATALOG - Industrial & Planning Reporting (in the tab Maintenance)
Main functionnalities
Several topics are covered by BEx reports :
- Work Orders with Maintenance Plan
- Work Orders with Equipment
- Notifications by Status and Causes
- Planned and Actual duration on Operations
- Work Orders and Operations by Status and Priority
- Monthly Costs
- Functional Location and Equipment Attributes
- Consumption of Materials on Work Orders
- Work Orders Costs by Vendor
- MTBF (Mean Time Between Failure)
- Backlog on Operations
Broadcast
- BCAST_ORACLE_PM (Weekly) : Extraction of actual costs year to date for current year send to PM IS Team for Chalampé plant, and the data is loaded manually in ORACLE Hyperion by PM Team.
- RCS_KPI_PM_ALL (Monthly) : Extraction of KPI PM. It has been unscheduled on SEP 2015 after a usage survey from IS Reporting Team and is not running anymore.
Maintenance
Known bugs
- None
Recurring procedure
- None
Planned Evolution
- None