Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need 'UOM Conversion details' in Subject area

Received Response
11
Views
1
Comments
Dan.C
Dan.C Rank 1 - Community Starter
edited Oct 6, 2025 1:22PM in Oracle Transactional Business Intelligence Forum

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

Answers

  • RVohra
    RVohra Mod

    • 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.