4 After Deploying AgileToEbiz PIP 3.6

This chapter describes how to configure PIP on a SOA Server.

4.1 Enable Global Trust between the weblogic domains: Agile and PIP FMW

Agile FMW

1. Login Agile PLM WLS console: http://agilehostname:agilehostport/console as superadmin:agile1.

2. Lock&Edit

3. Go to Settings for agileDomain -> Security -> General -> Advanced, set Credential and Confirm Credential to weblogic#1

4. Change Center -> Activate Changes.

5. Save

PIP FMW

1. Login AIA WLS console: http://piphostname: piphostport/console with weblogic/weblogic#1

2. Lock&Edit

3. Go to soa_domain configuration: Security -> General -> Advanced, set Credential and Confirm Credential to weblogic#1

4. Save.

Note: Please insert your system's information in place of the bold text.

4.2 Modify Transaction Values

To modify transaction values:

1. Log in to WebLogic Server Console. Navigate to Services, JTA. Change the value of property JTA Transaction Timeout from 30 to 3600.

2. Change the SyncMaxWaitTime parameter as follows:

   • Log in to the Oracle Enterprise Manager Fusion Middleware Control.

   • Expand SOA folder, right click soa_infra.

   • Select SOA Administration, BPEL Properties.

   • Click link More BPEL Configuration Properties.

   • Change the value of SyncMaxWaitTime from 45 to 120.

   • Click Apply.

4.3 Setup CHANGE_STATUS Table for workflow

• oqlplus plmpip(PIP Schema Name)/plmpip(PIP Schema password)@dbhostname:dbportnumber/pip

• Run command:

  insert into CHANGE_STATUS values('Change Implemented','SUCCESS','ECO','Default Change Orders','Implemented');
  insert into CHANGE_STATUS values('Change Implemented','SUCCESS','MCO','Default Manufacturer Orders','First Article Complete');
  insert into CHANGE_STATUS values('Change Implemented','SUCCESS','SCO','Default Sites Change Orders','Implemented');
  commit;
  

  
  

  Note: Please insert your system's information in place of the bold text.

  
  

4.4 DVM Update

• Login http://piphostname:soaport/soa/composer with admin user name/admin user password

• Open AGILE_SITE_TARGET_MAPPING.dvm, set TARGET_VALUE to 'V1' of 'DEFAULT_MASTER_ORG', and TARGET_VALUE to 'V1' of 'India', save&commit.

• Open AGILE_TARGET_SITE_MAPPING.dvm, set TARGET_VALUE to 'V1', 'AGILE_SITE' to 'India', save&commit.

• Open ECO_STATUS_CODE.dvm, For row that COMMON is 'IMPLEMENTED', change AGILE_01 to 'Implemented'. save&commit.

• Open ECO_TYPECODE.dvm, add 'SCO': EBIZ_01: 1017, COMMON: SCO, AGILE_01: SCO. save&commit.

• Open ITEM_STATUS_CODE.dvm, For row that COMMON is 'DESIGN', change AGILE_01 to 'Design'; add 'Preliminary': EBIZ_01: Prelim, COMMON: PRELIMINARY, AGILE_01: Preliminary. save&commit.

• Open ITEM_UOM_CODE.dvm, For row that COMMON is 'EACH', change AGILE_01 to 'Each'. save&commit.

The information below is for Ebiz 12.2.4 and later

• Open AGILE_INTEGRATION_USERS.dvm, set AGILE_01 to Administrator, admin (admin), COMMON to System Administrator, EBIZ_01 to mfg.

  
  

  Note: Please insert your system's information in place of the bold text.

  
  

4.5 Resume Queue

• Login http://piphostname:soaport/queue as admin_ujser_name/admin_user_password

• Search ProcessECO, press resume.

• Search ValidateECO, press resume.

  
  

  Note: Please insert your system's information in place of the bold text.