My Oracle Support Banner

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

Last updated on FEBRUARY 15, 2019

Applies to:

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


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.

The List of fields available from ProductGroupDetail is

 [ProdGroupId, ProdGroupDescText, ProdGroupName, StartDate, EndDate, ActiveFlag, ApplyEligCompRuleFlag, ProdGroupId1, Language, InternalName, RevenueRoleCode, RevenueCategoryCode, ProdGroupDescTxt, UsageRootFlag, RuntimeRevisionNum, LastUpdateDate, DetailInformation]

The List of fields available from ProductGroupDetailBase is

[ProdGrpDetailsId, UsageRootFlag, ObjectVersionNumber1, ProdGroupId1, RevisionNum, RefNumber1, ObjectId, ActiveFlag, StartDate, EndDate, PrivateFlag, AttributeCategory, CreatedBy1, CreationDate1, LastUpdatedBy1, LastUpdateDate1, LastUpdateLogin1, UserLastUpdateDate1, ChangeNum, ApplyEligCompRuleFlag, RevenueRoleCode, RevenueCategoryCode, AllowDuplicateContentFlag, AllowDupContentFlag, LookupPVOForRevenueCategoryCode, LookupPVOForRevenueRoleCode].

Is there any way we can access the Item Object and the Item Associated Product Group Object with the "ItemNumber" Provided?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.