Criteria Parameters for Line Items Grouping

The childGroups and rootFields parameters are now part of the Request Body criteria object for Commerce web services.

• childGroups is used to group Transaction Lines based on a boolean value and menu options. It consists of the following properties:
  • attributeName: The name of the attribute to group by (String).
  • groupOffset: The starting point or offset for the group (Integer).
  • groupLimit: The limit on the number of items to show in the group (Integer).
  • expandGroups: A boolean indicating whether to expand all groups. If false, only the first group will show items.

Example:

"childGroups": {"attributeName": "status_l", "groupOffset": 10, "groupLimit": 5, "expandGroups": true}

• rootFields is an array used to display specific fields of the root element for each row in the response, typically inside the _state attribute. Each item in this array corresponds to an attribute that is shown.

Example:

"RootFields": ["_part_number"]

Default Values:

• GroupLimit: Default is 25.
• GroupOffset: Default is 0.
• Limit: Default is 1000.

The childGroups and rootFields criteria parameters provide web service support for line item grouping.

Steps to Enable and Configure

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.