How To Access Products And Product Groups From Custom Object?
Last updated on SEPTEMBER 11, 2017
Applies to:Oracle Fusion Sales Cloud Service - Version 220.127.116.11.0 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?
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