Change of Name in Innovation Sales Pipeline (ISP) Not Reflected on Signature Request Page
Last updated on MARCH 08, 2017
Applies to:Oracle Agile New Product Development and Introduction for Process - Version 126.96.36.199 and later
Information in this document applies to any platform.
On Oracle Agile PLM for Process 188.8.131.52 up to 184.108.40.206, 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"
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.
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