PCP PPIMulti Task Integration
Requirement Features
Product Group: | Protheus | ||||||||||
Industry: | Manufacture | ||||||||||
Module: | SIGAPCP | ||||||||||
Routine: |
| ||||||||||
Initial Registration: | . | ||||||||||
Parameter(s): |
| ||||||||||
Entry Point: | MATI681CRG_Add_information_Adapter_of_annotation MTI650ADOP_Add_new_operation_adapter_production_order MTI650FCOP_Change_conversion_factor_second_unit_of_operation_measure_adapter_production_order MTI650QTOP_Change_quantity_of_operation_adapter_production_order MTI650UMOP_Change_second_unit_of_measure_of_operation_adapter_productionn_order PCPXFUNPPI_Routines_not_executing_integration_with_the_PC_Factory MT680VAL - Addition of Productions MATI681EXC_Processes_Annotation_Message
| ||||||||||
Related tickets |
| ||||||||||
Requirement (ISSUE): | PCREQ-6129; PCREQ-6130;PCREQ-6131;PCREQ-6132;PCREQ-6133;PCREQ-6657;PCREQ-7024 | ||||||||||
Country(ies): | All | ||||||||||
Database: | All | ||||||||||
Tables: | SOF SOE SOD SOG | ||||||||||
Operational system(s): | Windows®/Linux® | ||||||||||
Versions/Release: | 12.1.10 and 11.80.14 |
Description
Enable the integration between the PCP module of ERP Protheus with MES Pc-Factory from PPI Mult Task.
The integration counts with the following routine and processes:
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.
2 - Adapters: Adapters are functions responsible to send or receive information that is transferred between Protheus and PC Factory systems. For this project, the following adapters are used: Product, executed in MATA010. Stock location, executed in AGRA045. Resource, executed in MATA610. Production orders, executed in MATA650, MATA651,MATA632,MATA380, MATA381 and MATA690. Annotation of Production, executed the MATA681 and Stoppage Annotation executing the MATA682. The MRP, MATA712 (11.8) and PCPA107(12) are also prepared to send and integrate production orders.
3 - Pendencies: Enables to manage the pendencies of Protheus delivery to PC-Factory, as well as to check the history of errors of integration process.
4 - WebService: Enables a WebService to PCP from Protheus. This WebService has the purpose to process the annotation of production and stoppage sent from PC-Factory to Protheus;
5 - Synchronization: Enables to execute the synchronization of data from ERP Protheus and PC-Factory. Able to send data from Products, Stock Location, Resource and Production Order.
6 - Import Log: Enables to query annotation import of production and stoppage of PC-Factory to Protheus.
Implementation Procedures
The system is updated right after the application of update package of version 12.1.10. In version 11.80.14, run U_UPDPCP34.
Update APPSERVER.INI file in session WEBSERVICE.
Build must be equal to or later than 7.00.131227A and date 09/08/2016.
Compatibility Tool Updates
(Only for Microsiga Protheus, previous versions to version 12)
1. Creation of table in file SX2– Tables:
Key | Name | Mode | PYME |
SOD | Parameter of integration - Ger | E | S |
SOE | Parameters of integration | E | S |
SOF | Protheus-PCFactory Integration | E | S |
SOG | Import Log | E | S |
2. Creation of Fields in the file SX3 – Fields:
- SOD Table - Parameters of integration
Field | OD_FILIAL |
Type | Character |
Size | 2 |
Decimal | 0 |
Format |
|
Title | Branch |
Description | Branch |
Level | 1 |
Used | No |
Required | No |
Browse | No |
Options |
|
When |
|
Relationship |
|
System Val |
|
Help | Branch Code |
Field | OD_ATIVO |
Type | Character |
Size | 1 |
Decimal | 0 |
Format |
|
Title | Active |
Description | Active |
Level | 1 |
Used | Yes |
Mandatory | No |
Browser | Yes |
Options |
|
When |
|
Relationship | "N" |
System Val. |
|
Help | Indicates if integration is active. |
Field | OD_CAMINHO |
Type | Character |
Size | 100 |
Decimal | 0 |
Format |
|
Title | Path |
Description | Path |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the patch of WebService from PC-Factory |
Field | OD_GERAXML |
Type | Character |
Size | 100 |
Decimal | 0 |
Format |
|
Title | Generates XML |
Description | Generates XML |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates if XML files are generated |
Field | OD_DIRENV |
Type | Character |
Size | 100 |
Decimal | 0 |
Format |
|
Title | Sent |
Description | Sent |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates whether the directory to register the XML files sent. |
Field | OD_DIRPEND |
Type | Character |
Size | 100 |
Decimal | 0 |
Format |
|
Title | Pendency |
Description | Pendency |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the directory to register the XML files with errors or that has pending delivery |
- SOD Table - Parameters of integration
Field | OE_FILIAL |
Type | Character |
Size | 2 |
Decimal | 0 |
Format |
|
Title | Branch |
Description | Branch |
Level | 1 |
Used | No |
Required | No |
Browse | No |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Branch Code |
Field | OE_TABLE |
Type | Character |
Size | 2 |
Decimal | 0 |
Format |
|
Title | Table |
Description | Table |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the table name |
Field | OE_FILTRO |
Type | Memo |
Size | 10 |
Decimal | 0 |
Format |
|
Title | Filter |
Description | Filter |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Used to filter records of table |
- SOF Table - Protheus-PCFactory Integration
Field | OF_FILIAL |
Type | Character |
Size | 2 |
Decimal | 0 |
Format | @! |
Title | Branch |
Description | System Branch |
Level | 1 |
Used | No |
Required | No |
Browse | No |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the system branch to which the record belongs to. |
Field | OF_TRANSAC |
Type | Character |
Size | 10 |
Decimal | 0 |
Format | @! |
Title | Table |
Description | Table Name |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Name of table being sent to PC Factory |
Field | OF_REGIST |
Type | Character |
Size | 50 |
Decimal | 0 |
Format | @! |
Title | Record |
Description | Record Code |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Record code being sent. |
Field | OF_STATUS |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Status |
Description | Status |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options | 1=Ok;2=Pending;3=Error |
When |
|
Relationship | "1" |
Val. System | Belong("123") |
Help | Delivery Status. 1 - OK; 2 - Pending; 3 - Error. |
Field | OF_GERAXML |
Type | Character |
Size | 1 |
Decimal | 0 |
Format | @! |
Title | Generate XML |
Description | Generate XML |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options | 1=Yes;2=No |
When |
|
Relationship |
|
Val. System | Belong("12") |
Help | Indicates whether Generate XML. 1 - Yes; 2 - No. |
Field | OF_NOMEXML |
Type | Character |
Size | 100 |
Decimal | 0 |
Format |
|
Title | Name XML |
Description | File name XML |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Name of XML generated |
Field | OF_DTENVIO |
Type | Date |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Delivery Date |
Description | XML delivery date |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Delivery date of XML to PCFactory. |
Field | OF_HRENVIO |
Type | Character |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Delivery Date |
Description | XML delivery date |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Delivery time of XML to PCFactory. HH:MM:SS |
Field | OF_USU |
Type | Character |
Size | 25 |
Decimal | 0 |
Format |
|
Title | User |
Description | User |
Level | 1 |
Used | Yes |
Required | No |
Browse | No |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | User sending XML to PCFactory. |
Field | OF_MSGRET |
Type | Memo |
Size | 255 |
Decimal | 0 |
Format |
|
Title | Msg Return |
Description | Return Message |
Level | 1 |
Used | Yes |
Required | No |
Browse | No |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Return Message of PCFactory. |
Field | OF_XML |
Type | Memo |
Size | 255 |
Decimal | 0 |
Format |
|
Title | Content |
Description | XML Content |
Level | 1 |
Used | Yes |
Required | No |
Browse | No |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | XML generated content. |
Field | OF_XML |
Type | Memo |
Size | 255 |
Decimal | 0 |
Format |
|
Title | Content |
Description | XML Content |
Level | 1 |
Used | Yes |
Required | No |
Browse | No |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | XML generated content. |
Field | OF_DATPROC |
Type | Data |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Reproces Dt |
Description | Reprocessing Date |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the schedule the reprocessing of XML was executed through the program PCPA 110 - Pendencies. |
Field | OF_HORPROC |
Type | Character |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Reproces Time |
Description | Reprocessing Time |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the schedule the reprocessing of XML was executed through the program PCPA 110 - Pendencies. |
Field | OF_PROGRAM |
Type | Character |
Size | 8 |
Decimal | 0 |
Format | @! |
Title | Program |
Description | Generating Program |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates program that generated XML file. |
- SOG Table - Import Log
Field | OG_FILIAL |
Type | Character |
Size | 02 |
Decimal | 0 |
Format | @! |
Title | Branch |
Description | Branch |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Branch |
Field | OG_TRANSAC |
Type | Character |
Size | 10 |
Decimal | 0 |
Format | @! |
Title | Transaction |
Description | Transaction |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the record source transaction |
Field | OG_OP |
Type | Character |
Size | 13 |
Decimal | 0 |
Format | @! |
Title | Production Order |
Description | Production Order |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the production order |
Field | OG_PRODUTO |
Type | Character |
Size | 15 |
Decimal | 0 |
Format | @! |
Title | Product |
Description | Product |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the product code. |
Field | OG_RECURSO |
Type | Character |
Size | 06 |
Decimal | 0 |
Format | @! |
Title | Resource |
Description | Resource |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the resource code. |
Field | OG_STATUS |
Type | Character |
Size | 01 |
Decimal | 0 |
Format | @! |
Title | Status |
Description | Status |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates whether annotation was successfully processed. Status: 1 = OK; 2 = Error. |
Field | OG_DATA |
Type | Date |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Processing Data |
Description | Processing Data |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation processing data |
Field | OG_HORA |
Type | Character |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Processing Time |
Description | Processing Time |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation processing time. |
Field | OG_DTAPONT |
Type | Date |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Annotation St Dt |
Description | Annotation St Dt |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation St Dt |
Field | OG_HRAPONT |
Type | Character |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Annotation Start Time |
Description | Annotation Start Time |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation Start Time |
Field | OG_DTFIMAP |
Type | Date |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Annotation End Time |
Description | Annotation End Time |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation End Time |
Field | OG_HRFIMAP |
Type | Character |
Size | 8 |
Decimal | 0 |
Format |
|
Title | Annotation End Time |
Description | Annotation End Time |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation End Time |
Field | OG_ESTORNO |
Type | Character |
Size | 01 |
Decimal | 0 |
Format |
|
Title | Reversal |
Description | Reversal |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates whether it is reverse record 1=Yes;2=No
|
Field | OG_OPERAC |
Type | Character |
Size | 02 |
Decimal | 0 |
Format |
|
Title | Operation |
Description | Operation |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Indicates the operation code
|
Field | OG_QUANTID |
Type | Numeric |
Size | 11 |
Decimal | 2 |
Format |
|
Title | Quantity |
Description | Quantity |
Level | 1 |
Used | Yes |
Required | No |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation Quantity |
Field | OG_SEQ |
Type | Numeric |
Size | 10 |
Decimal | 0 |
Format |
|
Title | Sequence |
Description | Sequence |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Record sequence |
Field | OG_XML |
Type | Memo |
Size |
|
Decimal |
|
Format |
|
Title | XML |
Description | Annotation XML |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Annotation XML |
Field | OG_MSGRET |
Type | Memo |
Size |
|
Decimal |
|
Format |
|
Title | Message |
Description | Return Message |
Level | 1 |
Used | Yes |
Required | Yes |
Browse | Yes |
Options |
|
When |
|
Relationship |
|
Val. System |
|
Help | Return Message |
Important:
The size of the fields that have group can vary according to environment in use.
3. Creation of Indexes to file SIX – Indexes:
Index | SOD |
Order | 1 |
Key | OD_FILIAL+OD_ATIVO+OD_CAMINHO |
Description | Branch + Active + Path |
Owner | S |
Index | SOF |
Order | 1 |
Key | OF_FILIAL+OF_TRANSAC+OF_REGIST+OF_STATUS+DTOS(OF_DTENVIO)+OF_HRENVIO |
Description | Branch+Table+Record+Status+Delivery date+Delivery Time |
Owner | S |
Index | SOG |
Order | 2 |
Key | OG_FILIAL+OG_TRANSAC+OG_OP+OG_STATUS+DTOS(OG_DATA)+OG_HORA |
Description | Transaction + Production Order + Status + Processing Date + Processing Time |
Owner | S |
Index | SOG |
Order | 4 |
Key | OG_FILIAL+OG_TRANSAC+OG_PRODUTO+OG_STATUS+DTOS(OG_DATA)+OG_HORA |
Description | Transaction + Production + Status + Processing Date + Processing Time |
Owner | S |
OG_ESTORNO
Procedure for Configuration
CONFIGURATION OF MENUS
1. In Configurator (SIGACFG), access Environments/Register/Menu (CFGX013). Enter new option of menu fro SIGAPCP, according to instruction as follows:
Menu | Updates |
Submenu | MES Integration |
Routine Name | Parameters |
Program | PCPA109 |
Module | Production Contr Plan |
Type | Protheus Function |
Menu | Updates |
Submenu | MES Integration |
Routine Name | Pendencies |
Program | PCPA110 |
Module | Production Contr Plan |
Type | Protheus Function |
Menu | Updates |
Submenu | MES Integration |
Routine Name | Synchronization |
Program | PCPA111 |
Module | Production Contr Plan |
Type | Protheus Function |
Menu | Updates |
Submenu | MES Integration |
Routine Name | Import Log |
Program | PCPA112 |
Module | Production Contr Plan |
Type | Protheus Function |
Procedure for Use
- In planning and production control (SIGAPCP), access Updates / Integration MES / Parameters (PCPA109)
The system displays the integration parameterization screen. - To use integration, select option "1 - Active" in the field "Active", enter link WSDL of webservice MES and if you wish XML files to be physically generated, and if filters must be applied to records that are integrated.
- Click Confirm.
- After registration, in maintenance of Products, Stock location, Resource and Production order registration, information integrated to Software MES and the Pendencies and Synchronization routines are enabled to use.
- Annotation when sent by system MES can be queried by PCPA112.
Visão Geral
Import HTML Content
Conteúdo das Ferramentas
Tarefas