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 later
Information 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.

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?
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms