Oracle Fusion AI Data Platform Idea Lab

Home› Oracle Analytics and AI› Oracle Analytics and AI Labs› Oracle Fusion AI Data Platform Idea Lab

Categories

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

Enhancement Request

Needs Votes
11
Views
2
Comments
User_AHD9U
User_AHD9U Rank 1 - Community Starter
edited Mar 12, 2026 7:46PM in Oracle Fusion AI Data Platform Idea Lab

Please expose three attributes in the Financial – AP Expense subject area from table DW_AP_SLA_EXPENSE_DIST_CF:

  • INVENTORY_ITEM_ID
  • GLOBAL_CURRENCY_EXCH_RATE
  • SHIP_TO_LOCATION_ID

These attributes exist in the database table but are not currently available in the semantic model (SME). Please add them to the Financial – AP Expense subject area so they can be selected and used for reporting.

Tagged:
1
Up
1 votes

Needs Votes · Last Updated

Comments

  • User_AHD9U
    User_AHD9U Rank 1 - Community Starter

    Hello Team,

    Please provide the estimated timeline for completing this enhancement. We need to understand when the two attributes - INVENTORY_ITEM_ID and GLOBAL_CURRENCY_EXCH_RATE from table DW_AP_SLA_EXPENSE_DIST_CF, Will be exposed in the Financial – AP Expense subject area and available for reporting.

  • Ramprapanna Bhattacharya-Oracle
    Ramprapanna Bhattacharya-Oracle Rank 3 - Community Apprentice
    edited Mar 12, 2026 10:14AM

    Hi,

    Can we have these added too in Fin - AP Expense Subject Areas?

    These are present in ADW but not available in SME.

    Table:

    DW_AP_SLA_EXPENSE_DIST_CF

    Columns:

    INVENTORY_ITEM_ID,

    ITEM_DESCRIPTION,

    INVOICE_LINE_UNIT_PRICE,

    INVOICE_LINE_QUANTITY,

    TRANSACTION_LINE_UOM_CODE