How can the diagnostics and troubleshooting for products be done in Oracle iStore release 12 ?? Is there any query to check that??I mean the query for Catalog, Pricing Errors.
It depends on what kind of errors you would like to monitor. based on your error definition you could have a look at tables like MTL_ITEM_CATALOG_GROUPS, for pricing related info look into tables like ASO_PRICE_ADJUSTMENTS, ASO_PRICE_ADJ_RELATIONSHIPS, ASO_PRICE_ATTRIBUTES etc.