0 Replies Latest reply on Jun 19, 2019 1:36 PM by Ronel Jeervee Mayo-Oracle

    What is the table for Business Segment in Oracle Fusion Expenses?

    Ronel Jeervee Mayo-Oracle

      Hi Experts,

       

      We have a requirement to create a Custom Expense Report for the client. However, we can't find the table for the Business Segment of a certain expense. Please see attached file for the screenshot of Account information. We are able to extract some of the information such as the BTL_INDUSTRY, BTL_COSTCENTER and BTL_ACCOUNT. However, we need also the value from BTL_BUSINESS but we can't find the table for it. We are using the following tables in our SQL Query:

      1. EXM_EXPENSE_REPORTS

      2. EXM_EXPENSES

      3. EXM_EXPENSE_TYPES

      4. EXM_EXPENSE_DISTS

       

      Thanks in advance.

       

      Best regards,

      Ronel