Item Manufacturers Report Returns Item Mfr.Part Notes Empty/blank Field

(Doc ID 2259449.1)

Last updated on JULY 15, 2017

Applies to:

Oracle Agile Product Collaboration - Version 9.3.2.0 to 9.3.6.0 [Release 9.3]
Information in this document applies to any platform.

Symptoms

On : 9.3.2.0 version, Standard reports, Products Reports, Item Manufacturers Report

ACTUAL BEHAVIOR
---------------
Manufacturers Report Item returns some empty fields
When user executes the report, some fields are blank while they normally contain data.

EXPECTED BEHAVIOR
-----------------------
Report should display data when the attributes have value.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1.Login Java Client, Go to Manufacturer parts, enable Page two, then enable Notes, MultiText10 on Page two.
2.Go to manufactures, enable Page two, then enable Notes, MultiText10 on page two.
3.Go to Parts -> Manufacturers tab, enable Mfr.Notes, Mfr.Part Notes, Reference Notes, Mfr.MultiText10, Mfr.Part MultiText10, Mfr.Tab MultiText30.
4.Go to Parts -> Page Two tab, enable List01, Text01, MultiText10, Date01, MultiList01, Money01 and Numeric01 on page two.
5.Give enough read and modify privilege to admin user.
6.Login Web Client, create a new part P00001, set value for newly enabled attributes on Page Two.
7.Create a new Mfr M001, and a new Mfr part MP001(Mfr is M001).
8.Open P00001, go to Manufacturer tab, and add MP001.
9.Set values for Notes, Multitext10 on page two of M001 and MP001, also set value for Reference Notes, Mfr.Tab Multitext30 in Parts Manufacturers tab.
10. Go to Reports, Reports and Analytics -> Standard Reports -> Products Reports -> Run the Item Manufacturers Report.
11.In page 1 of wizard, edit DEFAULT LAYOUT, add all newly enabled attributes.
12.On page 2 of wizard, use Advanced Search to query out P00001: Items.Parts.Object Search Number Equal To P00001.
13.On page 3 of wizard, select 'All' for Preferred Status and Manufacturer Part Lifecycle Phase.
14.Click Finish to get the report.
Some field are blank in the report.

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