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:
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.,
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
|
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.
This chapter contains information on new product features for Extensibility Pack 3.0 of Oracle Agile Product Lifecycle Management for Process.
![]()
The following enhancements have been made for the Oracle Agile Product Lifecycle Management for Extensibility Pack 3.0.
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.
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.
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) |
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. |
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) |
This chapter contains resolved issues for Release 3.0 of the Oracle Agile Product Lifecycle Management for Process Extensibility Pack.
![]()
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.
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) |
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) |
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) |
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) |
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) |
![]()
This chapter contains hot fixes included in Release 3.0 of the Oracle Agile Product Lifecycle Management for Process Extensibility Pack.
![]()
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) |