Configure the Template for the Item Structure Report with Additional Attributes

You can configure the template for the item structure report with additional attributes by following the procedure in this topic.

Before you start

Ensure that the BI Publisher plug-in is enabled in Microsoft Word.

Here's what to do

1. In the Oracle Transactional Business Intelligence Catalog, expand Shared Folders > Supply Chain Management > Product Management > Items > Structures > Data Models.
2. Click Edit for the Item Structure Report Data Model.
   The Item Structure Report Data Model page appears.
3. In the Data Model pane, click Properties.
   The properties for the data model are displayed.
4. In the Attachment section, in the Sample Data field, click sample.xml.
   A dialog box appears with options to save the sample.xml file.
5. Select the location where the sample.xml file must be saved, and click Save.
6. In Microsoft Word, open UserDefined_ItemStructure.rtf.
7. On the BI Publisher tab, click Sample XML.
   A dialog box opens.
8. Go to the sample.xml file, select it, and click Open.
9. In the confirmation dialog box that appears, click OK.
10. Insert the header and data fields, and change the default/displayed text for the fields as required.
11. In the fields, insert the values displayed in this table:

    Header Field	Data Field
    @effLabel	ITEM_EFF
    @label	AML_DFF
    @label	MPN_DFF
    @label	COMPONENT_DFF

12. Set the properties for the header and data fields for each attribute type on the Advanced tab in the BI Publisher Properties dialog box.

    Attribute Type	BI Publisher Property for Header Field	BI Publisher Property for Data Field
    AML Descriptive Flexfield	<?split-column-header:AML_DFF_ATTR?> <?split-column-width-unit:5?> <?split-column-width:10?> <?@Label?>	<?split-column-data:AML_DFF_ATTR?> <?AML_DFF?> <?end?>
    Component Descriptive Flexfield	<?split-column-header:COMPONENT_DFF_ATTR?> <?split-column-width-unit:5?> <?split-column-width:10?> <?@Label?>	<?split-column-data:COMPONENT_DFF_ATTR?> <?COMPONENT_DFF?> <?end?>
    Item Extensible Flexfield	<?split-column-header:ITEM_EFF_ATTR?> <?split-column-width-unit:5?> <?split-column-width:10?> <?@effLabel?>	<?split-column-data:ITEM_EFF_ATTR?> <?ITEM_EFF?> <?end?>
    MPN Descriptive Flexfield	<?split-column-header:MPN_DFF_ATTR?> <?split-column-width-unit:5?> <?split-column-width:10?> <?@Label?>	<?split-column-data:MPN_DFF_ATTR?> <?MPN_DFF?> <?end?>

13. Save the UserDefined_ItemStructure.rtf file.
    Note: Ensure that the UserDefined_ItemStructure.rtf file is backed up to the Custom folder because modified templates are deleted after upgrades and must be manually copied from the Custom folder after upgrades.