PCP Protheus x PPI-Multitask Integration
Business Context
- Manufacturing Execution Systems, or simply MES is the term used to refer to the systems focused on the management of production activities establishing a direct link between planning and shop floor. The MES systems generate precise information and in real time promoting the optimization of all production stages since the issue of an order to the shipment of finished products shipment.
The importance of these systems comes from the gap that regularly exist between the ERP (Enterprise Resource Planning) and the specific softwares of the production line. The MES can import data from ERP and integrate with the production daily routine, managing and synchronizing the productive tasks with the flow of materials.
Considering that in the supply chain the highest added value is in the production, it makes sense investing in systems optimizing the flow, control and quality of material (Source: PPI-Multitask). - Planning and Production Control Gathering of means of production (raw material, labor, and equipment) enables manufacture of products that arise from the action of productive systems. The plans are the guide of execution and in production control are commanded by the auxiliary body named Planning and Controlling of Production (PCP) that establishes the production line rules, aiming at an ordered and continuous flow of the productive process.
- Shop Floor Allows you to plan, punch and monitor activities executed in each work center of the plant and machine, enabling an integrated view of executed operations, under execution and to be processed. Allows the Management and Monitoring of results (productivity, efficiency, delays, quality, use, levels of downtime, scrap reason, deviation of real/standard time etc). In MES integrated use, punches are executed by MES system.
Systems Involved
...
- PCP PROTHEUS 11.80.14, 12.1.10 (Phase I)
- PCP - SIGASFC PROTHEUS 11.80.17 (Phase II)
- PC-FACTORY (PPI MULTITASK)
Integration
The aim of the PC Factory Integration (MES software of company PPI Multitask) X PCP PROTHEUS is to make available to TOTVS customers a new option to control the production through the automation of processes, enabling the updating and extraction of online information to simplify the customers flow.
Scope
Enables the integration between the PCP module of SIGASFC Protheus with MES PC-Factory of PPI Multitask, aiming at controlling the annotation of production orders. Protheus is responsible by the creation of production orders and the PC-Factory with annotation.
The integration contemplates the following routines and processes in PHASE 1:
- Parameterization: Enables to parameterize the use of integration, indicating if it is ACTIVE. Indicates whether there is generation of XML files of information that is transferred between the systems, and also enables to define filters that are applied to information.
- Integrators: Adapters are functions responsible for sending or receiving information that is transferred between Protheus and PC Factory systems. Integration contemplates the following information: Product, stock location, resource, production orders, production annotation and stoppage annotation.
- Pendencies: Enables to manage the pendencies of PCP Protheus delivery to PC-Factory as well as to check the history and errors of integration process.
- WebService: Enables to process the annotation of production and stoppage sent from PC-Factory to Protheus;
- Synchronization: Enables to execute the synchronization of data from PCP Protheus and PC-Factory. Able to send data from Products, Stock Location, Resource and Production Order.
- Import Log: Enables to query the integration process of annotation of production and stoppage sent from PC-Factory to Protheus.
The integration contemplates the following routines and processes in PHASE 2:
Phase 2 contemplates the consumption of components, movements executed by PC-Factory and balances in stock. It also considers the SIGASFC - Shop Floor system.
- Parameterization: Enables to parameterize the use of integration, indicating if it is ACTIVE. Indicates whether there is generation of XML files of information that is transferred between the systems, and also enables to define filters that are applied to information.
- Integrators: Adapters are functions responsible for sending or receiving information that is transferred between Protheus and PC Factory systems. Integration contemplates the following information: Product, stock location, resource, machine, tools, script, structure, address, production order, balance in stock, movements and transfer of stock, annotation or production and stoppage annotation.
- Pendencies: Enables to manage the pendencies of PCP Protheus delivery to PC-Factory as well as to check the history and errors of integration process.
- WebService: Enables to process the annotation of production and stoppage sent from PC-Factory to Protheus;
- Synchronization: Enables to execute the synchronization of data from Protheus and PC-Factory. Able to send data from Products, Stock Location, Resource, Machine, Script, Structure, Address, Balance in Stock and Production Order.
- Import Log: Enables to query the integration process of annotation of production, refusal and stoppage sent from PC-Factory to Protheus.
...
Nota |
---|
|
Integration does not contemplate the generation of orders by APS. |
Install/Implement/Use Requirements
For Protheus version 12, apply package of updates from version 12.1.10 in Phase I. It can also be used in version 11.80.14 for Phase I and 11.80.17 for Phase II. Run the update of dictionary with program U_UPDPCP34.
Build must be equal to or later than 7.00.131227A and date 9/8/2014.
IP Address and released port for WebService execution. These data are used in APPSERVER.INI file in session WEBSERVICE.
Update APPSERVER.INI file in session WEBSERVICE.
To configure a WebService, check this configuration: http://tdn.totvs.com/pages/viewpage.action?pageId=6064937
Exemplo :
; WEBSERVICE CONFIGURATION
...
Enable=1
Server=proxy-jv.jv01.local
Port=8080
User=XXXXX
Password=*******
Installation/Updating
The PCP Protheus x PC-Factory PPI-Multitask is activated through the following steps:
...
- Register, change and deletion of product MATA010, AGRA045 stock location and MATA610, SFCA006 and SFCA002 resource;
- Register and change of orders MATA650;
- Process to FIRM orders MATA651;
- Maintenance of operations MATA632;
- Maintenance of allocation, MATA380 and MATA381;
- Register, change and deletion of Operations x Components MATA637;
- Machine Load MATA690;
- Calculation of MRP MATA712 (version 11.8) or PCPA107 (version 12);
- Register, change and deletion of structure, MATA200;
- Production splits generated by routines that handle order, and SFC310 annotation model 1 of shop floor.
- Register, change and deletion of address MATA015;
- Register, change and deletion of tools MATA015;
- Balance Update
- Inbound Invoice - Routines executing function B2ATUCOMD1;
- Sales Invoice - Routines executing function B2ATUCOMD2;
- Internal Movement - Routines executing function B2ATUCOMD3;
- Addition of balance MATA220 and MATA805.
...
- Register of stoppage reasons SFCA004;
- Register of scrap reasons SFCA003;
- Stock Separate movements. Inbound MATA250. Outbound MATA240;
- Transfer of stock MATA261;
- Annotation of production MATA681 and SFCA310;
- Annotation of stoppage MATA682 and SFCA311;
- Refusal, annotation of loss, MATA685.
Version Control
TOTVS group, represented by its brands, manages the layout progress demands and other adjustments, agreeing together with requesters the release approval term.
All progress scheduled must be discussed and approved by brands before the start of development and is only developed in case of agreement of brands and alignment with directive defined by TOTVS Integration Committee.
Support
All lines are responsible for support to integration resources; hence, the support teams of RM Connector and Protheus® Back Office products are ready to make the first analysis and, whenever needed, to transfer it to the fittest team in each case.
...
Nota |
---|
|
This support model is being reviewed by TOTVS. |
Transactions/Entities/Singles Messages
The following transactions are exchanged between TOTVS and PPI-Multitask:
Method | ID | Description | SourceOriginTarget | Destination | XSD (versions may vary) | Programs | Table |
FilesRegisters | 01 | Product | Protheus | PC-Factory | Item_3_001.xsd | MATA010 | SB1 |
02 | Stock Location | Protheus | PC-Factory | Warehouse_1_001.xsd | AGRA045 | NNR |
03 | Machines | Protheus | PC-Factory | Machine_1_000.xsd | MATA610 SFCA002 | SH1 CYB |
04 | Resources | Protheus | PC-Factory | Resource_1_000 | MATA620 SFCA006 | SH4 CYH |
05 | Structure | Protheus | PC-Factory | ItemStructure_1_000 | MATA200 | SG1 |
06 | Script | Protheus | PC-Factory | ItemScript_1_000 | MATA632 MATA637 | SG2 |
07 | Production Order | Protheus | PC-Factory | ProductionOrder_2_ | 001004.xsd | MATA650 MATA651 MATA380 MATA381 MATA690 MATA712 PCPA107 SFCA310 | SC2 |
08 | Address | Protheus | PC-Factory | AddressStock_1_000 | MATA015 | SBE |
09 | Stock | Protheus | PC-Factory | ItemStockLevel_1_000 | B2ATUCOMD1 B2ATUCOMD2 B2ATUCOMD3 MATA220 MATA805 | SB2 SB8 SBF |
Processes | 09 | Reason of Stoppage | Reason | PC-Factory | Protheus | StopReason_1_000 | CFGX016 SFCA004 | SX5 CYN |
10 | Reason of Scrap | Reason | PC-Factory | Protheus | WasteReason_1_000 | CFGX016 SFCA003 | SX5 CYO |
11 | Annotation of Production | Annotation | PC-Factory | Protheus | ProductionAppointment_ | 12_ | 001000 | MATA681 SFCA316 | SH6 SD3 CYV |
12 | Annotation of Stoppage | Annotation | PC-Factory | Protheus | StopReport_1_001 | MATA682 SFCA311 | SH6 CYX |
13 | Estoque Stock - Request | PC-Factory | Protheus | StockLevel_2_00 | | SB2 SB8 SBF |
14 | Movements | PC-Factory | Protheus | MovementsInternal_1_001 | MATA240 MATA250 | SD3 |
15 | Transfer | PC-Factory | Protheus | TransferWarehouse_1_ | 001003 | MATA261 | SD3 |
16 | Refusal | PC-Factory | Protheus | Refusal_1_000 | MATA685 | SBC |
Information Flow
Transactions information flow:
- Product, stock location and resource: during creation, change and deletionof a product in program MATA010, from a stock location in program AGRA045 or of a resource in programs MATA610 or SFCA006 or SFCA002 (machine) and tools in MATA620. The programs check whether the integration is active, and if positive, they deliver the register to PC-Factory. If there is no error, the register does not display any message, if there is an error, a message is displayed questioning whether to create a delivery pendency in program PCPA110. If you choose to operate a pendency, the process is committed in Protheus, and the updating for PC-Factory must be executed through PCPA110.
In the engineering, the register of structure MATA200 and script MATA632 or MATA637 and addresses MATA015 are integrated whenever a record is created, changed or deleted. - Production order: during creation and change of a production order, or during the change of the status of an order (allocation/machine load, request, operations change or pledge, MRP creation of splits), the program checks whether the integration is active and, if it is active, it executes the delivery of registration for PC-Factory. If there is no error, the register does not display any message. In case of error, a message is displayed and a delivery pendency can be created in program PCPA110. At the end of the process, the routines processing multiple orders, for example machine load, the amount of records that were sent to PPI-Multitask is displayed and the ones which had delivery pendency. Note: Some routines generate pendencies without executing the questioning due to the number of processed orders.
Routines affected by integration: Maintenance of Orders (MATA650), Routine to Establish Orders (MATA651), Maintenance of Operations (MATA632 or MATA637), Maintenance of Allocation (MATA380 and MATA381), Machine Load (MATA690) amd MRP (MATA712), Production splits (SFCA310). - Program of PCPA110 pendencies management - this program aims at managing pendencies/exceptions related to integration that are created when the message was not sent to PC-Factory, whether they are pendencies or errors. Enables the reprocessing of a message, deletion of a pendency and the XML view, besides having the filter per date of delivery, transaction, type of pendency and generating routine. The routine also enables to query the messages successfully sent.
- Synchronization program PCPA111 - enables the deliver of information from product, stock location, resource, tools, script, structure, address, balance in stock and production order, it aims at updating the PC Factory database. Besides filters defined in PCPA109, you can also add new filters for each table.
- Production Annotation: This routine consists in WebService to receive annotation of production executed by PC-Factory. You can also process production annotation and resource stoppage. Executes the same process the routines MATA681 and MATA682. When the Shop Floor is installed, it runs the same process the routine SFCA316 and SFCA311.
The integration flow is the following: a. the Operator normally reports according to its operation in PCFactory b. In a batch or triggered process, parallel to the system, the message is assembled (XML) according to Schema of Single Message TOTVS and the delivery of message (XML) for Protheus, validating the message and follow the respective business adapter up (MATA681/MATA682 or SFCA316/SFCA311) for processing. c. In case of mistakes, this report has pending status for delivery in the MES software and the user take actions in PC-FActory (Protheus does not keep traceability of receipt messages, but it registeres in LOG the processing). d. In case of success in report, the number of the report record executed in Protheus returns to PC-Factory. This number can be used in case of reversal. - UPdate of balance in PC-Factory will happen as follows:
a. Request: the PC-Factory requests balance generating request XML message. In this message, you can request balance per item, per stock location, among others.
b. Protheus Updating: When balance is updated, Protheus must send a XML message to PC-Factory. The main routines of ERP as inbound and sales inbound, some internal movements and addition of balance through MATA220 and MATA805 are considered. - Stock movements: When PC-Factory performs stock movements and transfers, these movements are updated in Protheus.
In case of movements, if I (input), it must run MATA250. If O (output), it must run MATA240. In case of transfers, it runs MATA261. - Refusal/annotation of loss. This routine consists in WebService to receive the refusal records in PC-Factory. The same process is executed in MATA685 routines.
- Query of Import Log PCPA112: This routine consists in the query of annotation records that were processed by the integration Protheus x PC-Factory. Routine must display the annotation executed and the status of each process.
...
Annotation: The entry point MT680VAL enables to validate if any information must be mandatory as time, quantity, among others. These validations are under the customers' responsibility, as each has its own rule. Details in: MT680VAL - Addition of Productions.
Annotation: The entry point MATI680OPR enables to change the code of operation received in the annotation of production. Details in: MATI681OPR_Edit_operation_code_message_annotation_production.
Annotation: The entry point MTI681QTAP enables to edit the quantity received in the annotation of production. This entry point is indicated to apply the conversion factor in the amount of annotation when ERP and PC-Factory work with different unit of measurement. Details in: MTI681QTAP_Edit_amount_of_annotation_ProductionAppointment.
Annotation: The entry point MATI681EXC enables to check whether the annotation is executed. This entry point is indicated for validations that hinder the annotation of production and stoppage. It is also used for cases in which you have to update some information before annotation (example: reversal an address). Details in: MATI681EXC_Processes_Message_Annotation.
Production Order: The Entry Point MTI650ADOP enables to add a new operation in the production orders message. For each operation being sent this entry point is executed once. Details in:Production Order: The Entry Point MTI650ADOP enables to add a new operation in the production orders message. For each operation being sent this entry point is executed once. Details in:: MTI650ADOP_Add new operation of production order adapter.
...
Production Order: The Entry Point MTI650UMOP enables to change the second unit of measure of the operation being sent in the production orders message. Details in: MTI650UMOP_Change_second_unit_of_measure_of_operation_adapter_productionn_order.
Production Order: The Entry Point MTI650TMAC enables to change the machine time (TimeMachine) in the message of ProductionOrder. Details in: MTI650TMAC_Edit_amount_of_ordermachine_time_production_order.
Production Order: The Entry Point MTI650LOTE enables to generate the Batch of the order in the tag LotCode in the message ProductionOrder. Details in: MTI650LOTE_Add_batch_in_message_of_production_orders.
Registers: The Entry Point PCPXFUNPPI enables to inhibit the integration in certain routine. Example: If you do not want integration to occur in the creation of MATA650 orders, you can use this function to inhibit the use. Details in: PCPXFUNPPI_Routines_not_executing_integration_with_the_PC_Factory.
Register of Item: o Ponto de entrada PCPADDTAGS permite incluir tags específicas nas mensagens padrões TOTVS. Está habilitado para o cadastro de item MATA010. Detalhes em: PCPADDTAGS_Adicionar_informacoes_XML_integracao_TOTVS_MES.
Cadastro de Processos: o Ponto de entrada PCPADDTAGS permite incluir tags específicas nas mensagens padrões TOTVS. Está habilitado para o cadastro de roteiro MATA632. Detalhes em: PCPADDTAGS_Adicionar_informacoes_XML_integracao_TOTVS_MES
Internal Movements. The entry points MATI250CRG and MATI240CRG enable specific validation. These validations are under the customers' responsibility, as each has its own rule. You cannot generate the values of fields that were generated by message. Details in:MATI240CRG_Add_information_Adapter_of_internal_movements and MATI250CRG_Add_information_Adapter_of_production_movements
Transfers: The entry point MI261RCV does not enable the execution of the integration. Details in: MI261RCV_Execute_integration_TransferWarehouse
Recusa: O ponto de entrada MATI685EXC permite verificar se a recusa será executado ou não. Este ponto de entrada é indicado para validações que impeçam o apontamento de recusa ou atualizações de informações necessárias para realizar a recusa. Detalhes em: MATI685EXC_Processa_Mensagem_Recusa
Execute in various branches
...