Posts

Posts

  • Senthilrajan Vaithianathan
    Adding extra filters to Infolets (Order Management -...1
    Topic posted July 12, 2019 by Senthilrajan VaithianathanBronze Trophy: 5,000+ Points, tagged Fusion Procurement reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Adding extra filters to Infolets (Order Management - Seeded Infolets)
    Summary:
    Customization of Order Management landing page to filter the Infolets data along with default filter of 'Source System'
    Content:

    Currently the system allow users to filter and view Infolet data based on the values you can select in 'View By' prompt (Source System) in Order Management landing page, we want to add additional filter criteria's like Buyer, Business Unit, Supplier, Sales Channel etc...

    Navigation

    Oracle Fusion --> Spring Board --> Order Management --> Order Management --> Filter data in Infolets by selecting 'View By' prompt.

    • How to add a new filter in the Order Management landing page to filter the existing infolet data based on 'Sales Channel' similarly like existing filter 'Source System' under 'View By' filter tab?
    • Do we have any other option to filter the Infolet data with these additional filters?
    • Where the Infolets are stored and can we edit those Infolets ?
    Version:
    Oracle Cloud Application 19B (11.13.19.04.0)
    Image:
  • Vincent Tu
    Adding Project Classification (Class Code) to OTBI...1
    Topic posted February 7, 2019 by Vincent TuBronze Medal: 1,250+ Points, tagged BI Publisher, Fusion Project reporting, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Adding Project Classification (Class Code) to OTBI report duplicate Costs Rows
    Summary:
    Adding Project Classification (Class Code) to OTBI report duplicate Costs Rows
    Content:

    Adding Project Classification (Class Code) to OTBI report duplicate Costs Rows.  2 Project Class categories were configured for Projects.   When adding Project Classification (Class Code) to OTBI, the two project class categories are added as two rows for one project and the costs are duplicated for each project class category.

    Is there any way to display the two project class categories in OTBI as two separate columns instead of two rows for the same project?

    Version:
    13.18.10 (11.13.18.10.0)
  • Debashis Das
    Addition of New Field withing Subject Area1
    Topic posted March 1, 2018 by Debashis Das, tagged BI Publisher, Fusion Project reporting, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Addition of New Field withing Subject Area
    Summary:
    How to add new filed (proejct classification) within a particular subject area
    Content:

    We have created Project Classification such as "Accounting Business Objectives", "Project Type" etc. And each project classification, there are defined class code such as "Recurring" and "Non-Recurring" for "Accourtning Buusiness Objective"  AND "Capital", "Non-Capital" for "Project Type". Objective of this project classification is we should know Project P1>>Recurring>>Capital and Project P1>>Non-Recurring>>Capital.

    In OTBI, I want Fileds  (within any Subject Area, within any folder..)  such as ""Accourtning Buusiness Objective"  and  "Project Type". So that I can pick any field for my reporting purpose. This will enable me to pick only those field as I required.

    Hence I want to know is this feasible? If yes how to

  • Nishanth B Jain
    Advanced Collections4
    Topic posted February 4, 2019 by Nishanth B JainSilver Crown: 22,500+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OTBI, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    Advanced Collections
    Content:

    Hello All,

    Do we have any OTBI subject area which gives data related to Collections.

    Ex: Collector wise collections.

    Thanks,

    Nishanth

  • Abdalaziz Barham
    After delete report folder Path not found1
    Topic posted March 26, 2018 by Abdalaziz BarhamRed Ribbon: 250+ Points, tagged Fusion Financial reporting, OBI Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    After delete report folder Path not found
    Summary:
    After delete report Path not found
    Content:

    Hi,

    We have problem with OTBI Custom Report Security , i create several otbi analysis and dashboard and prompt  and put them all in one folder as this bath 

    Shared Folder/ Custom / Financials / ABC.user / Items Balances ( Items balances dashboard + Items balances Prompt + Items balances Analysis  )

    but the user can see the report from other path , i try to delete the report but the user keep seeing the report icon and this msg appear:

    Path not found (/users/AAA.USER/Items Details/Items Details Report/Items Details Report)
      Error Details
    Error Codes: U9KP7Q94
     

    any idea ?? .

    regards

    Abdalaziz Barham

  • MShrini
    After R12 upgrade BIP and OTBI reports are not defaulted to...Answered25.0
    Topic posted November 3, 2017 by MShriniBronze Crown: 15,000+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Public Sector, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role
    Summary:
    After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role
    Content:

    After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role
    After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry role but user were accessed in R11.  Please help  us with solution if you are faced the same in R12 upgrade.

  • Krishna Manmohan
    Agent is generating Corrupted Excel1
    Topic posted September 14, 2017 by Krishna ManmohanGreen Ribbon: 100+ Points, tagged OTBI in General OBIEE public
    Title:
    Agent is generating Corrupted Excel
    Summary:
    Agent is generating Corrupted Excel
    Content:

    Hi All,

    Curious if anyone has seen this error within the excel file of an agent generated report:

    Outputfilename.xlsx is already open.Reopening will cause any changes you made to be discarded.Do you want to reopen Outputfilename.xls

    "Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
    Repaired Records: Format from /xl/styles.xml part (Styles) ".

    My end users are coming back sporadically with this error....It doesn't seem to be consistent I don't think it's a time out error? Any suggestions as to what might be wrong? 

    I have also atatched the screenshot.

    Note:-This is issue is happening after R12 upgrade.

    thanks,

    Regards

  • Rajesh
    Agent parameters65.0
    Topic posted September 11, 2018 by RajeshGold Medal: 3,500+ Points, tagged OTBI in General OBIEE public
    Title:
    Agent parameters
    Content:

    Hi

    While running agent can we pass any parameters as the OTBI analysis which is added to agent require variable prompt as parameter ? After running agent,email is not having any data.

    Thanks

    Rajesh

  • Inke
    Agent which should send out just a HTML link45.0
    Topic posted March 2, 2016 by InkeBronze Medal: 1,250+ Points, tagged OTBI, Setup in General OBIEE public
    Title:
    Agent which should send out just a HTML link
    Summary:
    Need to create an agent, which should send out an email, with just a HTML link
    Content:

    Hey All,

    I have to create an agent, which should send out frequently an email with just a link to a BIP report, is this possible ? In the "Delivery Content" tab you have to add first an analysis, then choose HTML as format, before you could enter the link as "Attachment Note".
    I'm wondering, if there is a smarter way to achieve the same result ?

    Thanks ! 

    Inke

    Image:
  • Gal Shani
    Agents - deliver report as attachment with diffrent nameAnswered15.0
    Topic posted February 18, 2015 by Gal ShaniSilver Medal: 2,000+ Points, tagged OTBI, Report Delivery, Report Layouts, Report Output, Reports in General OBIEE public
    Title:
    Agents - deliver report as attachment with diffrent name
    Content:

    Hello,

     

    Is someone familiar with the functionality to change automatically the name of the Email delivered from the agent? for example capture the date etc'..

     

    Thank you,

     

    Gal