I have created a business transaction with an item entry for a product which is an Individual Object. But after the save of this transaction, I could see an entry for line item in CRM_ORDER_INDEX table but the field: PRODUCT_ID is not filled with the ID of the individual object.
Whereas if I create a business transaction with an item entry for a product which is a normal product(not an individual object) , I could see that the field PRODUCT_ID is filled with the product ID.
Is this behavior an expected one as part of the framework? I need this Product_ID in CRM_ORDER_INDEX to search the business transactions based on the product ID.
Any help will be appreciated. Thank you.