Oracle Agile Product Lifecycle Management for Process

Release Notes

Extensibility Pack 3.0

E37995-01

 

 

 

 

 

 

 March 2013


Copyrights and Trademarks

 

Oracle Agile Product Lifecycle Management for Process Extensibility Pack 3.0 Release Notes

E37995-01

Copyright © 1995, 2013, Oracle and/or its affiliates. All rights reserved.

 

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS

Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are “commercial computer software” or “commercial technical data” pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.

Oracle and Java are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.


Document Control

Change Record

Date

Author

Version

Change Reference

March 2013

Oracle

1.0

Initial release, Part No. E37995-01

 


Contents

Change Record............................................................................................................................................................. iii

Chapter 1: What’s New in This Release........................................................ 2-3

What’s New in This Release?.................................................................................................................................. 2-3

Ready Reports Solution Pack............................................................................................................................. 2-3

Action Dashboard Solution Pack....................................................................................................................... 2-3

CS and EA Denorm Enhancements.................................................................................................................... 2-3

Reference Implementation Enhancements..................................................................................................... 2-4

Web Services Enhancements............................................................................................................................ 2-4

Chapter 2: Resolved Issues................................................................................ 2-6

Resolved Issues......................................................................................................................................................... 2-6

Administration Toolkit Resolved Issues............................................................................................................ 2-6

CS Denorm Resolved Issues............................................................................................................................... 2-6

EA Denorm Resolved Issues............................................................................................................................... 2-6

Reference Implementation Resolved Issues................................................................................................... 2-7

Web Services Resolved Issues........................................................................................................................... 2-7

Chapter 3: Hot Fixes............................................................................................. 3-8

Hot Fixes..................................................................................................................................................................... 3-8


Preface

This document describes issues that you may encounter with this release. Internal Tracking numbers that appear in the tables are used to identify issues reported by customers. You can use these numbers to identify the issue should you need to contact Oracle Support. Locator numbers that appear in parentheses after some notes are for Oracle internal use only.


 

Chapter 1: What’s New in This Release

Chapter2-1

This chapter contains information on new product features for Extensibility Pack 3.0 of Oracle Agile Product Lifecycle Management for Process.

Chapter2-1

What’s New in This Release?

The following enhancements have been made for the Oracle Agile Product Lifecycle Management for Extensibility Pack 3.0.

Ready Reports Solution Pack

The Ready Reports solution pack has been ported to work with the 6.1.1 release and Product Quality Management objects have been added.

 

For more information, refer to the Agile Product Lifecycle Management for Process Ready Reports Solution Pack Guide.

Action Dashboard Solution Pack

 

The Action Dashboard solution pack has been ported to work with the 6.1.1 release and Product Quality Management objects have been added.

 

 For more information, refer to the Agile Product Lifecycle Management for Process Action Dashboard Guide.

CS and EA Denorm Enhancements

Table: 1-1 CS and EA Denorm Enhancements

Bug/Enh ID

Enhancement

Description

None

Add new calculated EA types to EA and Custom Section denorm scripts.

Calculated Boolean and Calculated Text have been added to the denorm scripts. (22770, 31724)

None

Near Real Time Denormalization

The Custom Section and Extended Attribute Denorm processes can now work in near real time, using a new Remoting Container Service, and other changes. See the Custom Section and Extended Attribute Denorm Guides for details. (31725, 31726)

 

Reference Implementation Enhancements

Table: 1-2 Reference Implementation Enhancements

Bug/Enh ID

Enhancement

Description

None

Custom Web Service Reference

A reference web service is now available that demonstrates how to create and deploy a custom web service in Agile PLM for Process. (31767)

None

Extensible Formulation Columns Reference

Several reference implementations of Extensible Formulation Columns are available in the ReferenceImplementations\ExtensibleColumns\SourceCode folder.

None

PQM Extensibility Reference Implementations

Reference implementations of using external systems for Supplier and Affected Items data are available in the ReferenceImplementations\ReferencePQMExtensions\SourceCode\ folder. See the Agile Product Lifecycle Management for Process Product Quality Management Extensibility Guide for details.

None

Section Level Editing handler updated

A new Section Level editing reference implementation, LockByWorkflowTagUnlessInGroupSecurityHandler, is available which demonstrates a handler that locks down sections if a specification is in a particular status, unless the user is in a specified group.

Web Services Enhancements

Table: 1-3 Web Services Enhancements

Bug/Enh ID

Enhancement

Description

None

New Web Service contracts (version 30) are now available. The v21 web services have been removed.

New web service contracts (named v30) have been created, corresponding to the Agile PLM for Process 6.1.1 release. The v25 and v 24 versions are unchanged and still fully supported. The v21 web services are no longer available.

 

Note: The v24 web service contracts will be deprecated in an upcoming web service release.

None

Web services user name and password are now configured in the Setup Assistant application.

The Web Services username and password are configured using the Setup Assistant, which encrypts the password. This is required when using the Prodika.ProdikaAPI.IsLoginBypassOn=true configuration setting. (22632) See the Agile Product Lifecycle Management for Process Web Services Guide for more details.

None

PQM Web Services

A comprehensive set of web services are available for integration with PQM. See the Agile Product Lifecycle Management for Process Web Services Guide  for details.

None

New Formulation Step Bill of Materials web service

A new web service, GetFormulationStepBOM, has been added that returns formulation Bill of Material data by formulation step.  (23722)

None

The Bill of Materials web services now return the formulation column extensions defined using Extensible Columns.

Column extensions are now allowed on the formulation spec inputs and outputs grid. (23743) See the Agile Product Lifecycle Management for Process Extensible Columns Guide and the Agile Product Lifecycle Management for Process Web Services Guide for details.

None

Update web services that pull and save cross reference data to include 6.1.1 additions

The GetSpecSummary, GetSpecNumbersForCriteria,  GetSpecRelationships, and SaveSpecCrossReferences web services were updated to include the Description, UOM, and Status fields added in PLM for Process 6.1.1. (31024)

 


 

Chapter 2: Resolved Issues

Chapter2-1

This chapter contains resolved issues for Release 3.0 of the Oracle Agile Product Lifecycle Management for Process Extensibility Pack.

Chapter2-1

Resolved Issues

The following tables outline known issues that have been resolved for Release 3.0 of the Oracle Agile Product Lifecycle Management for Process Extensibility Pack.

Administration Toolkit Resolved Issues

Table: 2‑1 Admin Toolkit Resolved Issues

Bug/Enh ID

Issue

Resolution

None

Qualitative Lookup Configuration – Sort order not displaying correctly

Sort order is correctly displayed during a qualitative lookup. (18788)

None

NSM Testing Method – Need a way to assign to a nutrient

Testing methods can now be added and associated with a nutrient. (23198)

13975397

Data administration toolkit issue with ampersands (Oracle DB)

The database scripts no longer interpret ampersands as variables. (23479)

CS Denorm Resolved Issues

Table: 2‑2 CS Denorm Resolved Issues

Bug/Enh ID

Issue

Resolution

None

Base UOM Functionality – Quantitative Tolerance Extended Attribute – Tolerance Value not converted to base

For extended attributes that are quantitabive tolerance, the tolerance value is now converted to the base UOM. (18175)

None

PKID in Common Lookup Cells

This error has been fixed. (18180)

None

Remove DM_P4P_DENORM_CS script

The DM_P4P_DENORM_CS script has been removed.(20338)

EA Denorm Resolved Issues

Table: 2‑3 EA Denorm Resolved Issues

Bug/Enh ID

Issue

Resolution

None

Rename EA-Denorm IDX_prefixed indexes to PLM4P_ instead

All EA Denorm indexes starting with IDX_ have been renamed with the PLM4P_ prefix.(20218)

 

Reference Implementation Resolved Issues

Table: 2‑4 Reference Implementation Resolved Issues

Bug/Enh ID

Issue

Resolution

None

BomCalc – Get error while selecting the new path

This error has been fixed. (30562)

Web Services Resolved Issues

Table: 2‑5 Web Services Resolved Issues

Bug/Enh ID

Issue

Resolution

None

Class 'PackagingConfigRelation' should be 'PackingConfigRelation', Method 'getPackagingConfiguration()' should be 'getPackingConfiguration()' in GetPackagingSpecRelationships or GetProductSpecRelationships

The v30 web service contracts  have been changed. (30527)

None

'GetIngredientRelationships' should be 'GetMaterialRelationships'

The name of the web service has been changed for the v30 web service contracts only.(30529)

None

Missing EntityNumber while invoking the GetSCRMSourcingApproval web service with PKID

This error has been fixed. (30530)

None

Cannot save PQS sample with Product Spec by SavePqsSamples

This error has been fixed.(30542)

 


 

Chapter 3: Hot Fixes

Chapter3-1

This chapter contains hot fixes included in Release 3.0 of the Oracle Agile Product Lifecycle Management for Process Extensibility Pack.

Chapter3-1

Hot Fixes

The following table lists hot fixes that are included in the Oracle Agile Product Lifecycle Management for Process 3.0 Extensibility Pack release.

Table: 3‑1 Hot Fixes

 

2.7.1

BillOfMaterialServices error - GetOutputBOM fails (31216)

2.7.2

Cannot search by displayed value in data administration toolkit.(31268)

2.7.3

GetNutrientItemsPer100GRequest fails with code SPEC_LOAD_ERROR (31444)

2.4.1.0.1

Issues with performance of CS Denorm process processing multi-select data (18280)

2.4.1.0.3

NULL Values for -123456789 and 12319999 + pkid migration changes (18631)

2.4.1.0.4

SCRMService-GetCompany: Get exception of ORA-00907: missing right parenthesis (18797, 18798); API (NutrientService) is not Oracle SQL compliant (18766); NutritionService-GetNutrientComposite: Unable to find specified column in result (18795); CostService-SaveDWBSpecCost: Get ORA-00907: missing right parenthesis (18791); EQServices.GetEQNumbersForCriteria: get ORA-00902: invalid datatype (18793); GeneralSpecService-GetSpecNumbersForCriteria: Get ORA-01839 on all types of specifications (18794)

2.4.1.0.6

Make protected communication from AIA callback to PLM for Process used to receive the reply (19174)

2.4.1.0.7

Oracle version of NPDQuestionsLoader.sql script missing in EP 2.4.1 (19320)

2.4.1.0.8

The & character is convertion to & in denorm process (19892)

2.4.1.0.9

Oracle version of DENORM_EA_DATE DDL has wrong type for VALUE column (20335)

2.4.1.0.11

Data administration tol has 1000 character limit (22749)

2.4.1.0.12

Web service GetNutrientItemsPer100GRequest fails sporadically (22738)

2.4.1.0.13

Web service GetNutrientItemsPer100GRequest fails sporadically (23053)

2.4.1.0.14

Simple EA Denorm not working (30267)

2.4.1.0.15

Denorm process takes a long time (around 12 hours) to complete (30838)

2.4.1.0.17

Denorm procedure populating extra rows in denorm table. (31060)

2.4.1.0.18

Create Oracle scripts for DR 30838: Denorm process takes a long time to complete. (30922)

2.4.1.0.19

GetNutrientItemsPer100GRequest fails with code  SPEC_LOAD_ERROR (31260)

6.1.1.0.6

Created specification types that were not working. (31941)