I am also having trouble getting a submitted build (which are essentially private channels) to show up on my Ultra.
When I was publishing an update to my private channel, i was setting the minimum firmware version to a lower version than my published channel. Apparently any already published channels with a higher version number will cause the updated channel with the lower version not to update on my Roku player. This was something I didn't take into account or now about.
SELECT TOP 1 bundle# FROM bundle_bag... and what they are doing is sorting by min_firmware or unsorted. It's tricky but not hard if you think about the case.
WHERE channel# = :ID
AND min_firmware# <= LAYER_FW#
AND version# > :INSTALLED_VER
ORDER BY version# DESC