Query Item Revisions Using the New Item Revision LOV REST Service and Additional Attributes Using the Existing Items LOV REST Service

You can use the Item Revisions List of Values (LOV) REST resource to get a filtered list of item revisions that can be used as a data set in a list of values. This REST resource provides basic details of the item revision such as the revision code, revision description, start dates, end dates, and others. You can use the Item Revisions LOV REST resource to build a list of values using the Oracle Visual Builder Studio. This feature gives your enterprise additional flexibility and efficiency when retrieving product revision data. The following is the list of attributes for an item and organization:

  • Revision
  • Description
  • Reason
  • Effectivity Date
  • Implementation Date
  • End Effectivity Date

In addition to the preceding list, the Items List of Values (LOV) REST resource is enhanced to give access to additional item details of the item. You can efficiently query an additional 26 item attributes:

  • Child Lot Enabled
  • Cycle Count Enabled
  • Default Grade
  • Default Lot Status
  • Expiration Action
  • Expiration Action Interval
  • Grade Controlled
  • Hold Days
  • Inventory Item
  • Stock Locator Control
  • Lot Control
  • Lot Merge Enabled
  • Lot Split Enabled
  • Lot Status Enabled
  • Lot Translate Enabled
  • Maturity Days
  • Restrict Locators
  • Retest Interval
  • Revision Control
  • Defaulting Control
  • Secondary Unit of Measure
  • Serial Number Control
  • Serial Status Enabled
  • Lot Expiration Control
  • Shelf Life Days
  • Tracking Unit of Measure

 This feature benefits your business by programmatically allowing you to:

  • Query your item revisions using the Items Revisions LOV REST resource
  • Query additional attributes using the enhanced Items LOV REST resource

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 Data Security profile option (ORA_EGO_ENFORCE_DATA_SECURITY) determines whether to enforce the data security for the Items LOV REST resource.

  • The Item Search Character Limit profile option (ORA_EGP_ITEM_SEARCH_CHAR_LIMIT) determines the minimum number of characters needed for searching items in the Items LOV REST resource.

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.