Query Additional Item Attributes in Items LOV REST Service

You can efficiently query an additional 22 item attributes using the Items List of Values REST service. The following is the list of attributes that are available:

  • Structure Item Type
  • Base Model
  • Effectivity Control
  • Outside Processing Service
  • Autocreated Configuration
  • Pick Components
  • Assemble to Order
  • Restrict Subinventory
  • Transfer Orders Enabled
  • Stocked
  • Transaction Enabled
  • Internally Transferable
  • Revision Control
  • Customer Orders Enabled
  • Customer Ordered
  • Sales Product Type
  • Enable Contract Coverage
  • Shippable
  • Order Management Indivisible
  • Lot Control
  • Primary Image URL

This feature benefits your business by allowing you to programmatically query additional item attributes using a REST API. Prior to this feature, you could only query a limited set of attributes.

Steps to Enable

Review the REST service definition in the REST API guides to leverage (available from the Oracle Help Center > your apps service area of interest > APIs & Schema). If you are new to Oracle's REST services you may want to begin with the Quick Start section.

Tips And Considerations

  • The Enforce the Data security profile option (ORA_EGO_ENFORCE_DATA_SECURITY) determines whether to enforce the data security or not.

  • The Item Search Character Limit profile option ORA_EGP_ITEM_SEARCH_CHAR_LIMIT) determines the minimum number of characters needed for searching.

Key Resources

  • Refer to the REST API for Oracle Fusion Cloud SCM guide, available on the Oracle Help Center.

Access Requirements

Users who are assigned a configured job role that contains this privilege can access this feature:

  • Manage Item (EGP_MANAGE_ITEM_PRIV)

This privilege was available prior to this update.