General OBIEE

Get Involved. Join the Conversation.

Posts

  • Janko Jovicic
    ORA-03113: end-of-file on communication channel error -...35.0
    Topic posted November 28, 2019 by Janko JovicicBronze Medal: 1,250+ Points, tagged OBIEE Answers, OTBI, Report Output, Reports 
    Title:
    ORA-03113: end-of-file on communication channel error - Please Help
    Content:

    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?


    Regards,
    Janko

  • Prudence Kruchten
    Link OTBI Summary Report to BIP Detail Report5
    Topic posted August 16, 2018 by Prudence KruchtenSilver Crown: 22,500+ Points, tagged BI Publisher, OTBI, Reports 
    Title:
    Link OTBI Summary Report to BIP Detail Report
    Content:

    Hi all - we have a request to link report A to report B.  Report A will be like a summary report - name, manager, person #, job title.  Report B will have significantly more columns of data, and some data that is not available to us through OTBI, so will need to code it via BIP.  Is it possible to create Report A through OTBI and then link through to Report B in BIP?  Otherwise, is there a way to create a link from one BIP report to another BIP report while passing the parameters through?

    Thank you!

  • Maarten van der Burg
    What application do you use to write your SQL84.9
    Topic posted October 25, 2019 by Maarten van der BurgSilver Medal: 2,000+ Points, tagged BI Publisher Data Models, Data Models, Fusion, Reports, SQL 
    Title:
    What application do you use to write your SQL
    Content:

    I'm very curious as to what other people use to write their SQL. Personally I am using NotePad++ (with the SQL language setting to help with syntax).

    I do feel that there could be more software assistance and there might be some more automated applications out there which allow searching the repository, automatic joins, etc. Having a tool like this would speed up my work tremendously.

    Would like to discuss in this topic what you use and what you like/dislike about it.

    Regards,
    Maarten

  • Donald Ferreira
    BI Publisher Excel - How to get multiple horizontal...
    Topic posted December 11, 2019 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 
    Title:
    BI Publisher Excel - How to get multiple horizontal repeating groups working?
    Content:

    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,

    Donald

    Document:
    Document:
    Document:
  • Ashish Harbhajanka
    Is Multiple Data Sets Creation supported for BI BurstingAnswered55.0
    Topic posted July 14, 2015 by Ashish HarbhajankaGold Crown: 30,000+ Points, tagged Report Delivery, Report Output, Reports, Sample Reports 
    Title:
    Is Multiple Data Sets Creation supported for BI Bursting
    Summary:
    Multiple Data Sets in BI Bursting
    Content:

    This is with reference to Oracle Fusion HCM Applications

    Say we want to have a report which would hold Person Details as one Data Set (Parent) and Email Address (Child Data Set).

    We then need to burst the Data to a SFTP Folder

    Can we do this , if so please help with a simple example

    Thanks

    Ashish

     

  • 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 
    Title:
    Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment?
    Summary:
    Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment?
    Content:

    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: https://oraclecloudtools.com/sql-connect/ )

     

    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

    Ashish

    Version:
    Release 13 19D
  • 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 
    Title:
    Is it possible to get the Report Job History Output & Delivery details in BIP?
    Summary:
    Is it possible to get the Report Job History Output & Delivery details in BIP?
    Content:

    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!

    Thanks,

    Harish

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

    Hi,

    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

    Silvia

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

    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!

  • Lisa Spence
    Sharing OTBI AnalysesAnswered114.0
    Topic posted August 25, 2014 by Lisa SpenceRed Ribbon: 250+ Points, tagged Fusion, OTBI 
    Title:
    Sharing OTBI Analyses
    Summary:
    Need guidance on how to share OTBI templates with other internal users
    Content:

    Hi all!

    I am new to Fusion and OTBI.  I have searched Oracle Support and the Library, but can't seem to find an answer to this issue we're having.

    I have created an analysis in OTBI that we would like to share with other internal users.  I have currently saved it in My Folders of OTBI.  I have tried saving it to the Shared Folder, but I am denied access.  

    I assume this relates to security and that I need to have a particular security role added to my profile.  Is anyone aware of which particular role I require in order to have access to save to the Shared Folder?  Or is it something else entirely?

    Appreciate any help you can provide. 

    Thanks!

    Lisa