OIM KB Update — Run 2026-04-27 (4)

Focus: DB-backed IT Shop structure requirements (views + required columns) and concrete trigger/DBQueue mechanics that explain why IT Shop placement “happens later” via ShoppingRack tasks.

What changed in understanding (new findings)

dbo.ITShopOrg is a view over dbo.BaseTree filtered by UID_OrgRoot='QER-V-ITShopOrg', with explicit column mappings (UID_Org → UID_ITShopOrg, UID_ParentOrg → UID_ParentITShopOrg). (Live DB.)
For any IT Shop node insertion, the DB-level *minimum required* BaseTree columns (NOT NULL, no defaults) are: UID_Org, Ident_Org, UID_OrgRoot, XObjectKey. (Live DB.)
QER_TIBaseTree (trigger on BaseTree) enqueues QER-K-ShoppingRack-All for IT Shop subtree inserts and rejects invalid ITShopInfo usage outside UID_OrgRoot IN ('QER-V-ITShopOrg','QER-V-ITShopSrc'). (Live DB + install media snippet.)
DBQueue tasks are represented via dbo.QBMDBQueueTask keyed by UID_Task and mapped to ProcedureName (for example QER-K-ShoppingRack-All → QER_ZITShopCheckStructure). A quick “waiting” overview can be obtained via QBM_VDBQueueContent (metric aggregate by UID_Task). (Live DB.)

Evidence notes

Sandbox DB evidence (updated): projects/identity-management/oim-kb-update/sandbox-db/2026-04-27-itshop-db-evidence.md
Sandbox host evidence (updated): projects/identity-management/oim-kb-update/sandbox-host/2026-04-27-itshop-file-hints.md
KB note updated: projects/identity-management/knowledge-base/oim-it-shop-structure-and-availability.md

Next questions / experiments

1. Determine the supported (Designer/UI/API) path to enable QER\ITShop\AutoPublish\ADSGroup and observe the first DBQueue/ShoppingRack wave (new tasks + first ADSGroup.UID_AccProduct changes).

2. Confirm which stored procedures are responsible for populating AccProductInBaseTree (or confirm it is legacy/unused in this environment).