Supercharge your Proficy solution! Download a free trial of Proficy Operations Hub, CSense analytics, and more. Explore our Proficy 2025 releases!

Release Notes
Getting Started Guide
Web Client Installation Guide
ERP Integration Guide
- Overview
- Getting Started
- Custom Configuration
- ERP Import Service
  - About the ERP Import Service
  - ERP Integration Database Schema
  - Supported Inbound Schema Versions
  - About Information Flow
  - Work Orders
  - Process Orders
  - Material Lots
  - Material Release
    - About Material Release
      As an operator, you have the capability to define the raw material lot identifiers that are required for the production of a specific lot. This can be done using the material release functionality, which involves integrating with ERP systems. The JSON query containing the necessary information is validated within the ERP inbound messages. Once the query is successfully validated, the ERP Scheduler service imports the data into Plant Applications for further processing.
    - Assignment Lot Import
      To ensure successful integration with the ERP system, you must create an assignment for a specific material lot through the ERP integration inbound messages. The ERP Scheduler service will validate the messages, and upon successful validation, it will import the specific lot assignment into Plant Applications.
    - Sample Inbound Messages for Material Lot
      - Message that Contains a Lot Assignment
  - Materials
  - Tools
  - Outside Processing
  - Routes
  - Data Entry Plans
  - BOM Formulation
- ERP Export Service
- Troubleshooting
- Reference
Web Client Help
Troubleshooting Guide
REST API
SQL Programming Guidelines
Performance Recommendations
Ports
Plant Applications Kafka Topics

Message that Contains a Lot Assignment

INSERT INTO erp.erp_integration_inbound_messages (Inserted_Date, Message_Type, Media_Type, Message, Inserted_By)
VALUES (GETUTCDATE(),'AssignmentLots' , 'application/json', '<username>')

For more details, refer to Assignment Lot Import.

Inbound messages are added to the integration database using Microsoft SQL Server 2016 or later.