I’m working on (with Epicor’s help) getting a BOM into pricing rules for CPQ (so we can do Cost+ pricing).
First step is to get the BOM data from the PartMTL table into CPQ, so we created a BAQ sync of the PartMtl table (1.1M rows, with about 10 fields) - This errored out in the system monitor with “The wait operation timed out.” It takes 9 seconds to run the BAQ with remove rowlimit = true (Created EpiCare Case CS0004059131 on Tuesday 1/9/24).
Then I filtered the results using a few specific Product Groups (joined to the Part table), which got the sync down to 65k rows. This time the system monitor shows complete. Unfortunately the data in the CPQ SQL table is all nulls, except for the SysRow column.
Any ideas?
