Configure the Template for the Item Structure Report with the Main and AML Attribute

You can configure the template for the item structure report with the Main and AML attribute by following the procedure in this topic.

If your template for the item structure report must have the Main and AML attribute, you must configure the template with the approved manufacturer list (AML) and manufacturer part number (MPN) descriptive flexfield attributes.

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. Update the sample.xml file with attribute data under the <PublisherAMLVORow> tag.
   For example, if you're adding an MPN descriptive flexfield attribute called MPN Condition, here's how it should display:

   <PublisherAMLVORow>

   <MPN Condition>Value of MPN Condition</MPN Condition>

7. In Microsoft Word, open UserDefined_ItemStructure.rtf.
8. On the BI Publisher tab, click Sample XML.
   A dialog box opens.
9. Go to the sample.xml file, select it, and click Open.
10. In the confirmation dialog box that appears, click OK.
11. 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 or MPN Descriptive Flexfield	<user-defined display value of descriptive flexfield attribute>	<user-defined code of descriptive flexfield attribute>

12. 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.