How To Access Products And Product Groups From Custom Object? (Doc ID 2115142.1)

Last updated on SEPTEMBER 11, 2017

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.10.0.0 and laterInformation in this document applies to any platform.

Goal

We have a Custom Object where we are Storing List of Transactions. Each Transaction (i.e. Each Record) will have an "Item Number" Stored in a Custom Field. When an Item number is Populated, we have to Lookup this Item Number into the Out of The Box Item Master Collection (i.e.Products) and Get Related Information Like, Item Description or Long Description. We also need to get the Product Group Name associated to this Item (i.e. Product).

The Only way to get access to the Product and Product Groups is to write an Object View through Groovy Script.While i was searching , there were only few attributes that i can get from Product or Product Group Objects.