Need 'UOM Conversion details' in Subject area

Question

OTBI dashboard is being developed for CSRs to view the availability of items in different UOMs with their conversion factors

UOM conversions exist in the application, however unable to view inter/intraclass conversion details in OTBI Subject area.

Need to know is there any subject area available to view UOM Conversion between UOMs or any custom query available for this.

Thanks

RVohra · Answer

* There is no out-of-the-box OTBI subject area that includes UOM conversion details.

* OTBI primarily focuses on transactional and operational data, not setup/config tables like UOM conversions.

You can try to get it from following tables:

EGO_UOM_CONVERSIONS_B: Holds conversion rates between UOMs.

EGO_UOM_CLASSES_B: UOM class info (weight, volume, etc.).

EGO_UOM_CLASS_CONVERSIONS_B: Class-level conversions.