Tag Archives: Integration

Oracle Agile PLM Integration (PQM)

Oracle Agile PLM Integration (PQM, legacy system)

This client is a Fast Food company with 1,000+ chain stores. The client implemented various legacy systems and Agile PLM PQM module to collect and analyze product and supplier’s quality data. Further configuration and customization were requested to enable Agile PLM to exchange data with legacy systems and external suppliers.

Challenge – Data exchange between Agile PLM and legacy systems – Data exchange format and method between Agile PLM and external users

Solution Staging table was introduced for data exchange between Agile PLM and legacy systems. Agile Process Extension and SDK were used to consume data in staging table and execute functions not provided by Agile PLM. FTP was used to capture data files in xls/xlst/csv format uploaded by external users and Apache POI was introduced to parse those files.

Oracle Agile PLM Integration (PQM, CRM, EBS)

Oracle Agile PLM Integration (PQM, CRM, EBS)

The client is a multinational industry leader providing data and storage networking products.

All product complaints and quality issues are captured in the client’s Oracle CRM (Customer Relationship Management system) and Oracle EBS (E-business Suite Enterprise Resource Planning System). Agile PLM 9.3.1 PQM was implemented to house quality issues or complaints and closed loop corrective action processes were implemented to address these issues.

System integration was required to bring quality issues/complaints from CRM and EBS systems into Agile PLM. CRM and EBS data need to be updated to sync up data processed. Customized UIs were defined for steamlined flows.

Challenge

– Data exchange among heterogeneous systems
– Customized UI on Agile

Solution

Based on Agile URL-Based Process Extensions framework, customized application was implemented with its own UI, which can be launched from Agile. And the customized application consumes Agile OOTB functions through Agile SDK.

Agile Web Services Extensions Framework was used to implement customized web services which were exposed to other systems using Agile PLM data.

Oracle Agile PLM Integration (PG&C, Legacy system)

Oracle Agile PLM Integration (PG&C, Legacy system)

The client is a Europe OEM manufacturer implemented Agile 9.2 PC, PG&C and PSI modules. Typically OEM manufacturers are required to take responsibility for disposing, recycling, or re-using electronics that contain hazardous substances globally. In addition to satisfying FDA regulations and ISO standards, any company that sells electronics equipment in an international market is subject to the OEM manufacturing regulations in the target markets. Thus, this client needs to follow the regulation of Restriction of Hazardous Substances (RoHS) in Europe.

Agile Product Governance & Compliance (PG&C) is designed to help manufacturers manage product compliance, including the ability to audit the presence and amount of regulated substances used in their products, and to demonstrate that they responsibly dispose, recycle, or re-use parts containing those substances.

Challenge

– Export/Import product data from/to Agile PLM system automatically

– Filling/Extracting PG&C data to/from Adobe form automatically

– Retrieving data from suppliers automatically

– too much labor work, very time-consuming and error-prone

Solution

CaseStudyDataAdapter

– Process Extension.

– Agile SDK

– XSLT

– Adobe PDF forms import/export

– Automation server (Automation anywhere)