Change of Name in Innovation Sales Pipeline (ISP) Not Reflected on Signature Request Page

(Doc ID 2036022.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Agile New Product Development and Introduction for Process - Version 6.0.0.7 and later
Information in this document applies to any platform.

Symptoms

On Oracle Agile PLM for Process 6.0.0.7 up to 6.1.1.5, New Product Development
Find that if an Innovation Sales Pipeline Record (ISP) is updated when in status "Draft Review" and the name of the ISP is changed, the new name is not reflected on the signature request page if signature requests are necessary in a later state.
This is happening because the table NPDIDEAML is not updated with the new ISP name in field "Title"

Expected Behavior:
An updated ISP name should be reflected all over the application.


The issue can be reproduced at will with the following steps:
1. Create an ISP that name is “Fish Burger” in PLM4P. Then, push the status from Draft to Draft Review.
2. After that, change the name from “Fish Burger” to “Fried Fish Burger”.
3. Change the status to Idea Review.
4. In the database double check tables NPDIDEA and NPDIDEAML with following statement:
Select IDEA.Ideatitle, IDEAML.Title
from npdIdea IDEA
INNER JOIN NPDIdeaML IDEAML ON IDEA.pkid = IDEAML.fkIdea
where IDEA.Ideatitle = 'Fried Fish Burger';
=> The result is that Ideatitle shows the new name: 'Fried Fish Burger' while the Title field (of NPDIDEAML) shows the name "Fish Burger" still.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms