Redwood: View Comprehensive Attribute Data in Structure Grid

The structure grid displays the current effective revision of the parent item and each component. The following entities of each component show the values of the component's current revision:

• item operational attributes
• item extensible flexfields
• component level attributes
• component descriptive flexfields
• reference designators
• substitute components

Here are some details of the newly added attributes - Reference Designator and Substitute Component:

• Reference Designator
  • View as a range if a range indicator has been configured in Manage Items Structure Type Details
  • Search for the structure component based on the reference designator. However, you must include the Reference Designator Search attribute in the views you create to search for components using the reference designator
  • Use the icon appearing next to the reference designators to navigate to the side panel for more information about the reference designators.
• Substitute Component
  • Search for the structure component based on the substitute component
  • Click the item link to navigate to the item in the classic user interface.
  • Use the icon appearing next to the substitute components to navigate to the side panel for more information about the substitute components.

To view the details of the reference designators and substitute components in the side panel drawer, you can select the data presence indicator on the component row.

View Reference Designators and Substitute Components in Structure Grid

The drawer panel has separate tabs for reference designators and substitute components. In the reference designator tab, you can see the configuration for Quantity Related and the reference designators with the range indicator, if you’ve enabled the range indicator.

The details of the reference designator are in the table, and you can also search for a specific reference designator within the table. The global descriptive flexfields are always visible.

Reference Designator in the Drawer Panel

In the substitute component tab, there's a table that contains the details of the substitute component. The global descriptive flexfields are always visible.

Substitute Component in the Drawer Panel

You can right-click on the grid and perform the following actions:

• Hide and unhide columns
• Resize rows and columns
• Sort columns in ascending or descending order
• Select multiple rows, columns, or cells

Additional Actions on Right-Click

This feature benefits your business by providing a holistic and focused view of your item structure. The structure grid's powerful sorting and filtering capabilities allow you to analyze completeness and compliance efficiently without having to export the data to Excel.

Steps to Enable

• Index reference designator and substitute component attributes in the Structure index.
• These attributes can be used in existing views or to create new views.
• You must enable the following profile option to open the item in Redwood or Classic view when you click the item link:
  • Code: ORA_EGP_VIEW_ITEM_REDWOOD_ENABLED
  • Display Name: Redwood Page for View Item Enabled
    • Setting the value to Y will open the item in the Redwood user interface.
    • Setting the value to N will open the item in the Classic user interface.

Tips And Considerations

• When you hide or resize the columns or rows of a table, the modification doesn't persist when you navigate away from the page.
• Only global descriptive flexfields will be displayed in the side panel for reference designators. Context-sensitive descriptive flexfields aren't supported in this release.
• Use the Enterprise Scheduler Service job: Product Management Search Ingest Job to ingest the new range indicator and replace the existing range indicator:
  • Ingest Object = Item Structure
  • Object Type = Reference Designators
  • From Date = Enter a date
  • To Date = You can select the current date

Reference Designator Option in Product Management Search Ingest Job

• After completing this job, the ESS job to run Bulk ingest to OSCS job starts automatically. When both jobs are completed, the range indicator will show the latest selected range indicator.

Key Resources

• What's New 22A: Quickly Enter Reference Designators on Change Orders
• Oracle Fusion Cloud SCM Using Product Development Guide, available on the Oracle Help Center.
• Oracle Fusion Cloud SCM Using Product Master Data Management Guide, available on the Oracle Help Center.
• Oracle Fusion Cloud SCM Implementing Product Management Guide, available on the Oracle Help Center.

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature.

To view the item structure on the Redwood page:

• View Product Management Search (EGP_VIEW_PRODUCT_MGT_SEARCH)
• View Item (EGP_VIEW_ITEM)
• Create Item Structure (EGP_CREATE_ITEM_STRUCTURE_PRIV)
• Get Search View REST (EGP_GET_SEARCH_VIEW_REST_PRIV)
• Data Security: View Item Basic
• Access Item Structure Data Using a REST Service (EGP_GET_ITEM_STRUCTURE_REST_PRIV)
• Access Structure Attributes for Indexing Using REST (EGP_GET_PM_STRUCTURE_AVAIL_REST_PRIV)

To configure the index and add the reference designator and substitute component attributes:

• Manage Product Management Index (EGP_MANAGE_PM_INDEXES)
• Manage Scheduled Job Definition (FND_MANAGE_SCHEDULED_JOB_DEFINITION_PRIV)
• Grant Search Framework Manager Permissions (FND_SEARCH_FWK_MGR_PRIV)
• Access Item Structure Data Using a REST Service (EGP_GET_ITEM_STRUCTURE_REST_PRIV)
• Access Structure Attributes for Indexing Using REST (EGP_GET_PM_STRUCTURE_AVAIL_REST_PRIV)
• GET Product Management Index REST (EGP_GET_PM_INDEX_REST_PRIV)
• Manage Product Management Index REST (EGP_MANAGE_PM_INDEX_REST_PRIV)

To rebuild the index:

• Rebuild Product Management Indexes (EGO_REBUILD_PRODUCT_MGT_INDEXES)

To create the structure view with the reference designator and substitute component attributes:

• Manage Product Management View (EGP_MANAGE_PM_VIEWS)
• Manage Scheduled Job Definition (FND_MANAGE_SCHEDULED_JOB_DEFINITION_PRIV)
• Grant Search Framework Manager Permissions (FND_SEARCH_FWK_MGR_PRIV)
• Access Product Development Configurations Using a REST Service (ACA_GET_PD_CONFIGURATIONS_REST_PRIV)
• Manage Search View REST (EGP_MANAGE_SEARCH_VIEW_REST_PRIV)
• Access Structure Attributes for Indexing Using REST (EGP_GET_PM_STRUCTURE_AVAIL_REST_PRIV)
• GET Product Management Index REST (EGP_GET_PM_INDEX_REST_PRIV)
• Get View Available Attribute REST (EGP_VIEW_AVAIL_ATTR_REST_PRIV)

To run the Product Management Search Ingest job:

• Import Item (EGP_IMPORT_ITEM_PRIV)
• Manage Item Grouping (EGP_MANAGE_ITEM_GROUPING_PRIV)

These privileges were available prior to this update.