With Contributing Author: Simona Sutu

Does your business requirement demand export all multi-row attribute groups of different items through excel at once? Currently (till 12.2.9) multiple items can be exported to excel with attributes from one Multi-Row Attribute Group only.  Oracle E-Business Suite new version 12.2.10 brings support of multiple multi-row attribute groups in excel import. This will enable users to get the following benefits

  • View attributes from multiple Multi-Row attribute groups for each item in a single Excel sheet.
  • Edit attributes from multiple multi-row attribute groups for each item in a single Excel sheet.
  • Upload these edited multiple multi-row attribute groups for each item in a single upload.

To support this feature, in 12.2.10 a new check box named “Include All Attribute Groups” is introduced in the Item Search results page as per the below screenshot:

We can export all of them together to an excel when “Include All Attribute Groups” is checked and can do modifications  to existing multi-row attribute groups or  we can add few more attribute rows and then upload excel through import wizard.

You can also update the existing row and Create New Row through excel import. You will not be able to update unique keys using Excel.

Refer to the below documents for more functionalities on exporting multi row attribute groups

  • How To Delete or Update Multi-row UDAs Assignments Using Item Import Functionality? (ie Excel ADI EGOIJAVA) (Doc ID 1579544.1) and
  • How to Create, Update, or Delete Multi Row User Defined Attributes (UDAs) Using EGO_USER_ATTRS_PUB.Process_User_Attrs_Data API ? (Doc ID 1526870.1)

For more details on this new feature, please check below note:

  • Vision Demo – 12.2.10 PDH Enhancement – Multiple Multi Row Attribute Groups in Excel Export (Doc ID 2708294.1)