Oracle Fusion AI Data Platform Idea Lab

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

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.

1
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