General OBIEE

Get Involved. Join the Conversation.


  • Donald Ferreira
    BI Publisher Excel - How to get multiple horizontal...
    Topic posted 3:56 AM by Donald FerreiraRed Ribbon: 250+ Points, tagged BI Publisher Data Models, BI Publisher Report Templates, Customizing Layout, Customizing Reports, OBI Answers, OBIEE Answers, Report Delivery, Report Layouts, Report Output, Reports 
    BI Publisher Excel - How to get multiple horizontal repeating groups working?

    Hello There,

    I would like to know how can I get the below output using BI Publisher for Excel.

    I have three groups in the xml file.

    G_1  ->  G_2 ->  G_3

    Below expected output:

    G_1 G_2 G_3
    Segment1 Creation_Date Line_Num Item_ID Quantity_Ordered Quantity_Delivered
    10001008 08 11 2019 10 300000013603844 200 100
        20 300000013612944 300 200
        30 300000013615636 10 5
        40 300000013626474 20 1
        50 300000013676169 2 2
    10001009 22 11 2019 10 300000014432708 11 11
        20 300000014437123 25 25
        30 300000014434715 6 6


    The output I am getting now is as below:

    G_1 G_2 G_3
    Segment1 Creation_Date Line_Num Item_ID Quantity_Ordered Quantity_Delivered
    10001008" rowMark="2 2019-11-08T04:35:17.000+00:00" rowMark="2 10" rowMark="3 300000013603844" rowMark="3 200 100
        20" rowMark="3 300000013612944" rowMark="3 300 200
        30" rowMark="3 300000013615636" rowMark="3 10 5
        40" rowMark="3 300000013626474" rowMark="3 20 1
        50" rowMark="3 300000013676169" rowMark="3 2 2
    10001009 22 11 2019 10" rowMark="3 300000014432708" rowMark="3 11 11
        20" rowMark="3 300000014437123" rowMark="3 25 25
        30" rowMark="3 300000014434715" rowMark="3 6 6


    Please find attached the sample xml, output and the excel template file for your reference.

    Look forward to hearing from you.

    Thank you & regards,


  • Silvia Guido
    Suspended job report5.0
    Topic posted December 9, 2019 by Silvia GuidoBronze Medal: 1,250+ Points, tagged BI Publisher, Report Delivery 
    Suspended job report
    Suspended job report


    I have a question about using a BIP job report: I have a job report that is scheduled to be sent every night if the day before some users have been registered to a learning element, like a course. Now, I want to suspend this job only for one night, in order for it to not be executed tonight even if today some learners have been registered to a learning course. My question is: if I suspend it, and then reactivate it on Wednesday, it will start to work again on thursday night, referring only to the learners that have been registered on wednesday, is it right? Or there is the risk that the notification that is not sent tonight will be sent later, when the job is reactivated?

    Thank you


  • Ashish Harbhajanka
    Feasibility of having SQL Developer Connection to Oracle HCM...55.0
    Topic posted December 5, 2019 by Ashish HarbhajankaGold Crown: 30,000+ Points, tagged BI Publisher, SQL 
    Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment?
    Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment?

    Hi Experts,


    I hope that most of you who have worked on an On-Premise system must be well versed with using SQL Developer to run/execute a query and get raw data.


    But in Oracle HCM Cloud or rather Oracle ERP Cloud enviornment one had to use Oracle BI Data Model or OTBI SQL Option (now not supported from 19D)


    So wondering won't it would be great to be able to connect to Oracle ERP Cloud database using SQL Developer. (could be a nice enhancement in product)


    I do heard about some paid tools developed by some organization but still not sure will individuals / orgs pay for the tool on a per user per month

    (Details about tools can be found here: )


    I personally feel that the tool is good but only if free , else am happy to take the pain of creating Data Model to run my SQL).


    What do you guys think, having a SQL developer like interface to execute queries in cloud helps and if it does shall it be paid or free (embedded within project or additional bolt on).


    Would love to hear both the pros and cons for it.


    Do let-me know your views?


    Kind Regards


    Release 13 19D
  • Neha Takkar
    Reports Run Count25.0
    Topic posted December 5, 2019 by Neha TakkarSilver Trophy: 7,500+ Points, tagged OBIEE Answers, OTBI, Reports 
    Reports Run Count

    Is there a way to find out how many times a report was run and who ran it? Like we may have 10 reports and want to find out which is the report that is used the most and how many people have used it. Thank you!

  • David Rabalais
    BI Publisher, First Time Setup, Report ServerAnswered5
    Topic posted December 3, 2019 by David RabalaisBlue Ribbon: 750+ Points, tagged BI Publisher, Setup/Administration 
    BI Publisher, First Time Setup, Report Server
    I cannot find a clear guide to where I get the report server URL.

    The URL I tried it with is:

    I've done several variations of this, but nothing seems to work. Is the above URL the correct format? Is the port correct?


    Thank you,

    David Rabalais

  • Harish Kumar
    Is it possible to get the Report Job History Output &...15.0
    Topic posted December 2, 2019 by Harish KumarBlue Ribbon: 750+ Points, tagged BI Publisher 
    Is it possible to get the Report Job History Output & Delivery details in BIP?
    Is it possible to get the Report Job History Output & Delivery details in BIP?

    Hello Experts,

    We have a requirement to fetch the report job history details where the delivery status is failed for particular person.

    Fro example, if a report runs for 100 people, for 98 people email delivered successfully and status will show as Green Tick, but it failed for 2 persons and the status will shows red. I need to fetch that failed person id (which is split by value) and error message for the particular person why it failed to deliver.

    Is there any table which stores this data?

    If anyone worked on the similar requirement, could please share with us.

    Thanks in Advance!



  • Sian Summers
    Custom BI Webcat Reporting Duty55.0
    Topic posted November 29, 2019 by Sian SummersRed Ribbon: 250+ Points, tagged Fusion, OTBI, Public Sector, Report Delivery, Reports, Setup, Setup/Administration, Tip 
    Custom BI Webcat Reporting Duty
    Trying to hide seeded reporting folders and understand the updated options within 19D

    We are keen to have the option to hide seeded folders from users. Changing permissions on seeded report folders comes up with the following error:

    "In-place customizations are not allowed on factory delivered content. Save your customizations in /shared/custom"


    We were really pleased therefore to see the following release notes for 19D:

    However, I am trying to understand how it works. Has anyone used these roles yet?

    The BI Consumer role still has traverse permissions to these seeded folders, therefore struggling to understand how assigning another role counters this. 

    Also - the Custom BI Webcat Reporting Duty, which is the Duty Role that it is advised we edit put into a role and assign, is unable to be copied. Is this what people would expect?

    If anyone can give any further detail on how this works, it would be much appreciate. Keen to lock down some of these seeded reporting folders.

    Kind regards,




  • Janko Jovicic
    ORA-03113: end-of-file on communication channel error -...15.0
    Topic posted November 28, 2019 by Janko JovicicBlue Ribbon: 750+ Points, tagged OBIEE Answers, OTBI, Report Output, Reports 
    ORA-03113: end-of-file on communication channel error - Please Help

    Hi All,

    In last few months, for the second time we are facing one quite strange issue. Random users, with random reports (or some user with all reports) are facing following error message and code:

    We had technical SR (3-20715306161) where we bounce the server at one point of time which still didnt fix the issue. Issue was gone after 3,4 days.

    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

    State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

    State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)

    State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 3113, message: ORA-03113: end-of-file on communication channel Process ID: 246507 Session ID: 6224 Serial number: 29851 at OCI call OCIStmtExecute: BEGIN fnd_session_mgmt.attach_session('9861821953AF9216E0534C8D630A8F6D'); END;. (HY000)

    State: HY000. Code: 17011. [nQSError: 17011] SQL statement execution failed. (HY000)


    Now we are having the same problem, it does impact less people  accross the globe (Germany, UK, Singapore) than the previous time, but at still reports are erroring quite randomley and also some users cannot run any. Clearing cache/ logging in out does not solve a problem.

    Users on the front end are just sseeing error - Please contact your system Adminsitrator where back in the logs we are seeing the error from above.

    Did anyone face similar issue in the past or at the moment and are there are any recommendation/ ideas how to solve it and what could be the rootcause?


  • nathan morgan (at Client)
    What is catalog folder Extension?5.0
    Topic posted November 20, 2019 by nathan morgan (at Client)Silver Medal: 2,000+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Data Models, Fusion, OBI Answers, OBIEE Answers, OTBI, Reports, Setup, Setup/Administration 
    What is catalog folder Extension?
    Does anyone know the purpose of the empty shared folder Extension in the catalog?

    The folder is empty.

    A duty role exists for it, BI_EXT_REPORTING_DUTY, but unlike the other folders, the permissions on this folder have not been updated so that only people with that role see this folder.

    I had been doing the following configuration to assign folder reporting duty roles to role

    Custom BI Webcat Reporting Duty


    Cloud Readiness Common Technologies and User Experience


    19C (
    Code Snippet:
  • Ling Xiang
    OTBI Customer Survey5.0
    Topic posted November 18, 2019 by Ling XiangGold Trophy: 10,000+ Points, tagged OTBI, Reports 
    OTBI Customer Survey

    Oracle BI development is planning OTBI feature improvements.  To better understand SaaS customers’ reporting needs, usage and requirement gaps, we are conducting an OTBI customer survey.  Please take 10-minutes to complete this 10-question survey to share your feedback, thoughts and ideas ->


    Thank you for your time!


    Ling Xiang

    Oracle OTBI Product Management