Magento 2.4.6 Base table or view not found: 1146 Table ‘catalog_category_product_index_store0’ doesn’t exist

I have been facing this issue on my Magento 2.4.6-p1 EE

While trying to create order from admin and when selecting store to create order as an admin below error is generated

Base table or view not found: 1146 Table 'catalog_category_product_index_store0' doesn't exist, query was: SELECT `main_table`.*, IFNULL(wishlist.name, 'Wish List') AS `wishlist_name` FROM `wishlist_item` AS `main_table`
 INNER JOIN `wishlist` ON main_table.wishlist_id = wishlist.wishlist_id
 INNER JOIN `catalog_category_product_index_store0` AS `cat_index` ON cat_index.product_id = main_table.product_id AND cat_index.category_id = '0' AND cat_index.visibility IN (3, 2, 4) WHERE (wishlist.customer_id = 4462) AND (`main_table`.`store_id` IN('0'))

I have been scratching my head but couldn’t figure out what’s the root cause of this. The table catalog_category_product_index_store0 doesn’t exist at all.

While selecting any store for creating order as an admin, the correct store ID is being passed in the payload but the error is same regardless of any store selection

I have tried to perform reindexing multiple times and all the indexers are in Ready status. I have also tried to debug in the function getItemCollection() inside MagentoMultipleWishlistBlockAdminhtmlSalesOrderCreateSidebarWishlist.php but no luck

Attaching few screenshots for better understanding. Looking for some help. Thanks

P.S. We have migrated from Magento 2.3 EE to Magento 2.4.6-p1 EE