General OBIEE

Get Involved. Join the Conversation.

Posts

  • 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 
    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

  • Gaston van de Weijer
    Reference Relationship in BI Publisher4
    Topic posted October 22, 2019 by Gaston van de Weijer, tagged BI Publisher, BI Publisher Report Templates, Report Output 
    Title:
    Reference Relationship in BI Publisher
    Content:

    Hi,

    I created an interview which loads data about a certain order - it then needs to go into boxes and I need to create shipping labels

    1. The user adds an instance 'the box' and enters dimensions and more information. 

    2. I created a relationship from 'the box' to 'the item' called 'the debrief item in the box'

    3. I added this relationship to the entity collect screen, so you can check which items will be in the box.

    4. The data overview displays exactly what I want:

    5. However, I cannot get this in BI publisher. I want an overview of items per box, however, I can't seem to pull this off. Once I create a 'for each' for every box, I can't add another 'for each' in there. I can't seem to add the items in this overview..

    How do I create a report with BI publisher with a page for a box and a list of items in the box below? 

    Version:
    19B
  • nathan morgan (at Client)
    Get privilege to issue logical SQL in OTBIAnswered21.0
    Topic posted September 11, 2019 by nathan morgan (at Client)Silver Medal: 2,000+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, Customizing Reports, Data Models, OBI Answers, OBIEE Answers, Report Output, Reports, Setup, Setup/Administration 
    Title:
    Get privilege to issue logical SQL in OTBI
    Summary:
    As a developer i need to "Issue SQL" /analytics/saw.dll?issuerawsql to query using logical sql metadata repository database (rpd) with log level 2 then view log for diagnostics like physical sql
    Content:

    Hi,

    Does anyone know if in Oracle Cloud Application, we are oracle cloud application 19B(11.13.19.04.0) with oracle business intelligence 11g (11.1.1.9.0), does a role exist that has been granted privilege "Admin:General"/"Issue SQL Directly" by person with bi administration privileges who went to the Administration menu then the page "Manage Privileges" to assign that privilege to a role. Our development team who are writing extensions using oracle transaction business intelligence (OTBI) real time subject areas, to be productive, need the ability to issue logical sql, view results with the log level set > 0, then view the log file with rich diagnostics like timings and row counts and the actual physical sql. To achieve this on onpremise projects the administrator had granted the above role to developers. We assume that the bi administrator role is not allowed to be granted in cloud therefore we can not set this up ourselves. In Navigator/Tools/Security Console I have assigned the following roles "BI Consumer Role", "BI Platform Author Role", "BI Publisher Data Model" and even "BI Platform Repository Manager" and "Business Intelligence Content Administrator" but none of these give me the "Administration" menu in /analytis/ nor the ability just to go to "issue sql" saw.dll?issuerawsql or even "Manage Sessions" saw.dll?sessions. Thanks, Nathan  

    Version:
    oracle cloud application 19B(11.13.19.04.0) with oracle business intelligence 11g (11.1.1.9.0)
    Image:
    Code Snippet:
  • Stephanie Gott
    Published Report Schedule - showing message if attachment...
    Topic posted March 5, 2019 by Stephanie GottSilver Medal: 2,000+ Points, tagged BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Report Delivery, Report Output, Reports, Scheduling or Agents 
    Title:
    Published Report Schedule - showing message if attachment has nothing
    Summary:
    If the published report attachment has no data, can we put that in the body of the message?
    Content:

    Hello,

    For a personal BIP report schedule, if the attachment has no data on it, is there a way to call that out in the body of the email message to the user? We find that users are opening reports that have no data unnecessarily. Some days the report will have data, sometimes it might not and that could be valid. If there is a way to show the user that they don't need to open the attachment because it doesn't contain data, that would be great. Any thoughts? 

    Thanks,

    Stephanie

  • Senthilrajan Vaithianathan
    Oracle Fusion OTBI Direct Database Query/Report95.0
    Topic posted February 4, 2019 by Senthilrajan VaithianathanBronze Trophy: 5,000+ Points, tagged Analyses, BI Publisher Data Models, Customizing Reports, Data Models, Discussion Forums, Fusion, OBI Answers, OTBI, Report Output, Reports, Setup/Administration, SQL 
    Title:
    Oracle Fusion OTBI Direct Database Query/Report
    Summary:
    Querying Oracle Fusion OTBI feature is being deprecated for CLOUD environment from 19A releases
    Content:

    Creating Reports with Direct Database Query in Oracle Fusion OTBI is being deprecated for CLOUD environment from 19A releases.

    Refer Doc ID 2141412.1

    Regards

    Senthil

    Image:
    Code Snippet:
  • Kingsley
    OTBI: OTBI Agent with SFTP Destination35.0
    Topic posted December 27, 2018 by KingsleyRed Ribbon: 250+ Points, tagged Analyses, BI Publisher, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Output, Reports, Scheduling or Agents, Setup/Administration, Tip 
    Title:
    OTBI: OTBI Agent with SFTP Destination
    Summary:
    How to Setup OTBI Agent to export report results to SFTP Server
    Content:

    Hello All,

    I have a request to export the result output of an OTBI report to an SFTP server on a daily basis. Unfortunately the delivery Agent for scheduling OTBI reports does not have the FTP as a Destination option. Has anyone some Ideas on how I can go about this? your contributions are highly appreciated.

     

    Regards

     

    Kingsley

  • Srinivas Challa
    OTBI: Diff of Two dates to get Age is rounded to next...25.0
    Topic posted December 21, 2018 by Srinivas Challa, tagged Analyses, Core HR, Fusion, OBI Answers, OBIEE Answers, OTBI, Report Output 
    Title:
    OTBI: Diff of Two dates to get Age is rounded to next highest value
    Summary:
    OTBI: Diff of Two dates to get Age is rounded to next highest value
    Content:

    OTBI: Diff of Two dates to get Age is rounded to next highest value

    Example: If difference of Age is 48.8 Its displayed as 49 instead of 48 even after using FLOOR or TRUNCATE.

    Below is the formula I used still unable to succeed.

    FLOOR(TimeStampDiff(SQL_TSI_YEAR, "Dependent Data"."Dependent Date Of Birth", Current_Date))

    Your help is highly appreciated.

  • Shalindra Singh
    Is Orders data available through the OTBI layer in Order...15.0
    Topic posted November 20, 2018 by Shalindra SinghBlue Ribbon: 750+ Points, tagged BI Publisher, OBIEE Answers, OTBI, Report Output, Setup/Administration, SQL 
    Title:
    Is Orders data available through the OTBI layer in Order Management / SCM?
    Summary:
    Is Orders data available through the OTBI layer in Order Management / SCM?
    Content:

    Is Orders data available through the OTBI layer in Order Management / SCM?

    Reason I am asking because when I querying direct table (doo_header_all) via BI Publisher, I get the data from this table.

    But when I use 'Issue SQL' on OTBI Administration section and write following query - 

    select_physical

    headerId, OrderNumber

    from "FscmTopModelAM.DooTopAM.Header"

    I don't get any records. 

    I need your help as I was asked not to use BI Publisher for data extraction (where I want order and line data to be extracted in every 10 minutes) hence evaluating data sync tool but I do not get any data when I used above query.

  • Kevin Lee Choon
    Deferred Termination field in OTBI25.0
    Topic posted September 17, 2018 by Kevin Lee ChoonGreen Ribbon: 100+ Points, tagged Analyses, Core HR, Customizing Reports, Data Models, Discussion Forums, Global HR, OBI Answers, OBIEE Answers, OTBI, Report Output, Reports 
    Title:
    Deferred Termination field in OTBI
    Summary:
    looking on how to determine a deferred termination
    Content:

    Hello,

    I have been asked to create a report showing the associates with a deferred termination. When they do a termination transaction, a selection box showing the processing options pop up on the interface with the choice of Immediate or Deferred.

    I tried to look but could not find the field in OTBI related to it. Anyone knows which field to use of if there is another way to determine this type of termination?

    thank you!

  • Kingsley
    List of OTBI inefficient Reports55.0
    Topic posted September 7, 2018 by KingsleyRed Ribbon: 250+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates, Customizing Reports, Data Models, Fusion, Fusion Performance Mgmt, OBI Answers, OBIEE Answers, OTBI, Report Delivery, Report Layouts, Report Output, Reports, Sample Reports, Scheduling or Agents, SQL 
    Title:
    List of OTBI inefficient Reports
    Summary:
    looking for was to monitor OTBI reports performance and Frequency of use
    Content:

    Hi All,

    I am looking for ways to monitor the performance of OTBI Reports in fussion cloud environment. We have BIP and OTBI reports that are running poorly and I wish to find out how I can do that. Admin session mager provides the cursor cache where I can see the OTBI report run-time, logs and path but this information is only held for a very short time in the production environment. 

    Has anyone an idea on how i can get this information for a time period of over a month?

    - Report name with path

    - Runtime

    - Execution time and date

     

    Thanks

     

    Kingsley

    Version:
    R13 - 18B