My Oracle Support Banner

Item Manufacturers Report Returns Item Mfr.Part Notes Empty/blank Field (Doc ID 2259449.1)

Last updated on MARCH 26, 2019

Applies to:

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


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

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

Report should display data when the attributes have value.

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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.