Reporting and Analytics for SCM

Get Involved. Join the Conversation.

Topic

    Sunil Dabekar
    Sales Order EFFs not showing up in OTBI
    Topic posted November 15, 2018 by Sunil DabekarGold Medal: 3,500+ Points, tagged BI Publisher, BI Publisher Reports, BICS, Business Intelligence, Order Management, OTBI, SCM 
    163 Views, 2 Comments
    Title:
    Sales Order EFFs not showing up in OTBI
    Summary:
    Sales Order EFFs not showing up in OTBI
    Content:
    Hi Experts,
     
    We have created few EFF in the Sales Order Header (with BI enabled), those EFF are not showing up in the OTBI.
    We also ran the ESS job ‘Import Oracle Fusion Data Extensions for Transactional Business Intelligence’ but still no luck.
    Any pointers would be appreciated!
     
    Thanks,
    Sunil

    Comment

     

    • Sunny Todkari

      See if this helps:

      How to add EFF attribute in Sales order report in R12. (Doc ID 2282054.1)

      Goal: How to add EFF attribute in Sales order report R12.

      Solution: EFFs are not visible in the data model & the context and segment need to be manually typed in the template in order to show an EFF attribute within the Sales Order Report. For the context & segment name in the template, it is the code of the context & segment as defined in Manage Extensible Flexfields page that should be used.

      Refer above-mentioned metalink note for more details and example.

       

    • Amarnath Govindu

      Extensible flexfields are BI enabled if at least one segment in a context is BI enabled.
      Setting Extensible Flexfields as BI-Enabled
      To set extensible flexfields as BI-enabled:
      1. Navigate to Setup and Maintenance.
      2. Navigate to Manage Extensible Flexfields.
      3. Enter the extensible flexfield name; for example, Organization Information EFF.
      4. Select the applicable extensible flexfield, and then click Edit.
      5. Select the applicable Category. The category contexts are populated automatically.
      6. Click Manage Contexts
      7. In the Edit Context page, select the applicable Context, and then click Edit.
      8. Select the applicable Segment, and then click Edit.
      9. In the Edit Segment page, select the BI Enabled check box at the bottom of the screen.
      10. Click Save.

      Once the BI Enabled box is checked and the flexfield is deployed, we need to run the process "Import Oracle Fusion Data Extensions for Transactional Business Intelligence" for the flexfield segments to be available in their corresponding subject areas. Below are the steps to run the process: