OIM KB Update Run 24

Goal

Clarify the sandbox-specific “availability wiring” around AccProductInBaseTree / AccProductInITShopOrg, and record the concrete trigger/procedure hooks that fire when:

ADSGroup IT Shop flags change,
ADSGroup.UID_AccProduct changes,
AccProductGroup (service category) hierarchy/decision method changes,
BaseTree PR nodes change.

Actions

Read inbox + journal tail; opened a coordination journal entry (in-progress).
Live sandbox DB (SELECT-only) via scripts/sandbox/Invoke-SandboxSql.ps1:
captured view definitions for ITShopOrg, ITShopOrgHasADSGroup, AccProductInITShopOrg,
captured AccProductInBaseTree count vs PR node count,
captured schema “NOT NULL” requirements for BaseTreeHasADSGroup and BaseTreeHasObject,
captured trigger/proc definitions for ADS_TUAdsGroup, QER_TUBaseTree, QER_PIsForITShopFlagCheck.
Sandbox host (WinRM, read-only):
searched shipped SQL/XML for AccProductInBaseTree, QER_PIsForITShopFlagCheck, QER-K-ShoppingRackProductNode, QER_PITShopProductNodeCreate,
extracted the shipped table definition + relationships for AccProductInBaseTree,
extracted shipped trigger excerpts (QER_TAccProductGroup, ADS_TAdsGroup).

Key findings (new/confirmed)

In this sandbox, AccProductInBaseTree is empty while there are 16 PR nodes with BaseTree.UID_AccProduct set → AccProductInITShopOrg is misleading for troubleshooting here.
Shipped triggers explicitly enqueue ShoppingRack refresh for PR nodes when:
PR node UID_AccProduct changes (QER_TBaseTree),
service-category decision method / parent changes (QER_TAccProductGroup).
ADS_TAdsGroup validates IsForITShop / IsITShopOnly via QER_PIsForITShopFlagCheck and updates PR nodes via QBM_PJobCreate_HOUpdate_B 'ITShopOrg' when UID_AccProduct changes.

Output

DB evidence: ../sandbox-db/2026-04-27-accproductinbasetree-views-and-trigger-hooks-db-evidence.md
Host evidence: ../sandbox-host/2026-04-27-accproductinbasetree-and-itshop-flag-validation-file-evidence.md