General OBIEE

Get Involved. Join the Conversation.

Posts

  • Silvia Guido
    Suspended job report
    Topic posted 6:12 AM 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
  • Ashish Harbhajanka
    Feasibility of having SQL Developer Connection to Oracle HCM...45.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
  • 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 
    Title:
    BI Publisher, First Time Setup, Report Server
    Summary:
    I cannot find a clear guide to where I get the report server URL.
    Content:

    The URL I tried it with is: https://podurl.fa.us2.oraclecloud.com:9704/xmlpserver/

    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

    Version:
    19D
    Image:
  • Harish Kumar
    Is it possible to get the Report Job History Output &...1
    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

  • nathan morgan (at Client)
    What is catalog folder Extension?5.0
    Topic posted November 20, 2019 by nathan morgan (at Client)Bronze Medal: 1,250+ 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 
    Title:
    What is catalog folder Extension?
    Summary:
    Does anyone know the purpose of the empty shared folder Extension in the catalog?
    Content:

    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

    CONFIGURE NEW BI REPORTING DUTY ROLES TO HIDE THE FACTORY CATALOG FOLDERS

    Cloud Readiness Common Technologies and User Experience
    https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/common/releases/19D/19D-common-wn.htm#F10098

    Nathan

    Version:
    19C (11.13.19.07.0)
    Image:
    Code Snippet:
  • Prudence Kruchten
    Custom Sort - BIP Pivot1
    Topic posted November 15, 2019 by Prudence KruchtenSilver Crown: 22,500+ Points, tagged BI Publisher, Reports 
    Title:
    Custom Sort - BIP Pivot
    Content:

    Hi - I have a pivot table I am using through BIP and I need to apply a custom sort to it.  I added an Order By to the DM, but it's not applying that to the pivot, maybe because I don't have that field displayed in the pivot?  

    Any help on this would be appreciated, thank you!

    Image:
  • Donald Ferreira
    Java.sql.SQLException: Invalid column indexAnswered12
    Topic posted November 15, 2019 by Donald FerreiraRed Ribbon: 250+ Points, tagged BI Publisher, BI Publisher Data Models 
    Title:
    Java.sql.SQLException: Invalid column index
    Summary:
    Errors out with the mesaage
    Content:

    Hello There,

    We are using Oracle Financials Cloud and BI Publisher. I have a simple WITH Clause sql construct. On execution it gives the below error. .

    Could you please advise on what needs to be corrected?


    oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: java.sql.SQLException: Invalid column index
     

    Database Version:
    Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
    PL/SQL Release 12.1.0.2.0 - Production
    CORE 12.1.0.2.0 Production
    TNS for Linux: Version 12.1.0.2.0 - Production
    NLSRTL Version 12.1.0.2.0 - Production

    SQL Query:

    WITH  FUNCTION GetValue1 (p_value VARCHAR2) Return VARCHAR2 IS
                      CURSOR c1 IS
                           SELECT 'aa' aa FROM dual WHERE p_value = 'ABC';
          
                  cc VARCHAR2(100);
                BEGIN
                     FOR x IN c1
                     LOOP
                          cc := x.aa;
                     END LOOP;
                     RETURN cc;
                EXCEPTION
                      WHEN OTHERS
                      THEN
                          RETURN 'Error GetValue1: '|| p_value;
                END GetValue1;
    ------------
         PO AS
         (SELECT * FROM po_headers_all)
    ------------
    ,    POLines AS
         (SELECT * FROM po_lines_all)
    ------------
    --Main Query
    ------------
    SELECT po.segment1, polines.po_header_id , GetValue1('ABC') GetValue
    FROM   PO, POLines
    WHERE  polines.po_header_id = po.po_header_id

     

     

    Thank you.

    Look forward to hearing from you.

    Regards,

    Don

  • Sarah Munro
    How can I find all reports using the same BI Publisher Data...4
    Topic posted November 14, 2019 by Sarah MunroRed Ribbon: 250+ Points, tagged BI Publisher, BI Publisher Data Models, Public Sector 
    Title:
    How can I find all reports using the same BI Publisher Data Model
    Summary:
    I need to be able to identify all the reports that are using a Data Model before I make changes to the DM.
    Content:

    Bi Publisher Data Model has been created, I now need to know all the reports that are using this DM. Is this possible?

    Version:
    Oracle BI EE 11.1.1.9.0
  • Stephanie Burghardt
    Excel report is grey and no data is visible4
    Topic posted November 13, 2019 by Stephanie Burghardt, tagged BI Publisher, BI Publisher Report Templates 
    Title:
    Excel report is grey and no data is visible
    Summary:
    When generating an Excel with BI Publisher the file is grey and no data is visible.
    Content:

    After generating an Excel file with the BI Publisher the sheet is grey and the data is not visible. But the data is there and can be seen in the small field in the header. After saving and reopening the file the sheet looks normal.

    What is wrong here?

    Version:
    Oracle BI Publisher 12.2.1.1.0 (build:20160526.2332)
    Image:
  • Shashi Kiran Vishwamurthy
    Can Oracle supports the subdomain email option (using...15.0
    Topic posted November 11, 2019 by Shashi Kiran Vishwamurthy, tagged BI Publisher, Report Delivery, Reports 
    Title:
    Can Oracle supports the subdomain email option (using custom mailfrom)?
    Summary:
    Can Oracle supports the subdomain email option (using custom mailfrom)?
    Content:

    Hi,

    we are getting undelivery notifications when we are using company domain email address in from email.
    Ex: abcd@company.com

    in Sr suggested that add oracle.com in company email domain server. we have conclusion from network team that we don't touch the SPF record of company domain email server as suggested in the SRs .

    So we are trying to use email address which is subdomain of company.
    Ex:Example email: infmhcm@hcm.company.com

    Our network team need confirmation about below points.

    • Whether Oracle supports the subdomain option (using custom mailfrom)
    • Are these mails purely inbound ?

    Please let us know if anyone knows about above two points.

    Regards
    Shashi Kiran