Category Archives: Case Study

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 Performance Tunning

Oracle Agile PLM Performance Tunning

The client is a leading telecommunication network solutions provider listed in Fortune Global 500.

Agile PLM 9.3.0.2 was implemented for requirement management. To comply with the client’s UI standard/requirements, a heavily customized UI system was built using Agile SDK and Agile web services. Though users are satisfied with usability, performance, stability and reliability are compromised by the customization. The client called from improvements on boosting performance, stability and reliability.

Challenge

– Complex clustering environment
– Huge user base (100, 000+ listed users, 500+ concurrent users)
– Heavy Agile PLM SDK dependency

Solution

PSR (Performance, Stability, Reliability) automation testing was introduced to identify performance, stability and reliability issues.

A re-architecture was delivered successfully to improve performance. Different fine-tuning solutions were introduced as well, such as Agile schema access, Agile SDK API usage review, customization code tuning, data compression, etc.

Finally, the overall performance was improved 70% with 6 instances running stable.

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)

Oracle Agile PLM Upgrade

Oracle Agile PLM Upgrade

The client is an electronics company providing semiconductors and software for storage and networking in mobile networks and cloud computing.

The client wants to upgrade to Agile PLM 9.3.1 from Agile PLM 9.2.2.X. Before Agile PLM 9.2.2.X, the client has used Agile PLM 8.5 for long time.

Challenge

– Data corruption

Solution

Agile PLM AUT was used as the main upgrade tool. Agile PLM ACP and Dataload were used for data upgrade. Agile PLM Averify was used for data verification.