Posts

Posts

  • Animesh Agrawal
    CSV output Date FormatAnswered145.0
    Topic posted March 25, 2019 by Animesh AgrawalBlue Ribbon: 750+ Points, tagged BI Publisher, OBIEE Answers, Reports, Tip in Reporting and Analytics for ERP public
    Title:
    CSV output Date Format
    Summary:
    CSV output Date Format
    Content:

    Hello all,

    I have created one Report using new data model (OBIEE data source) and an Subject Area Analysis based query. I have created layout using inbuilt step by step report wizard.

    I need report output of CSV in particular date format.

    Can anyone help in this regards.

  • Virginia Baez-Ponce
    Need report that shows all approval assignees who have NOT...Answered145.0
    Topic posted October 17, 2017 by Virginia Baez-PonceBronze Medal: 1,250+ Points, tagged BI Publisher, Fusion Financial reporting, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Need report that shows all approval assignees who have NOT approved invoice
    Summary:
    We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet)
    Content:

    We are trying to build a report that provides only “open/incomplete” invoice approvals (i.e. only those approval assignees who have NOT approved yet).  Unfortunately the report we built shows all past and present “assignees” rather than just providing the “open/incomplete” approvals.  I’ve attached some screenshots as well as an archive of the analysis we built.

    I am no OBTI/SQL expert but is there a quick a simple way to return only the “most recent” assigned value in the data set for a particular invoice?  Interestingly enough if we go to BPM, look up the invoice and sort by “Assigned” it correctly returns only the INCOMPLETE (unapproved) pending approvals which is out desired result.

    Image:
  • Ling Xiang
    R11 ERP OTBI Subject Area Mapping to Fusion Database Tables144.9
    Topic posted June 6, 2016 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI in Reporting and Analytics for ERP public
    Title:
    R11 ERP OTBI Subject Area Mapping to Fusion Database Tables
    Summary:
    Release 11 ERP OTBI subject area database table mapping spreadsheet
    Content:

    This spreadsheet is published by Oracle OTBI Development.  This spreadsheet documents Fusion ERP OTBI subject areas, columns and the corresponding HCM database tables and columns.  Customers can use this spreadsheet to search for subject area reporting content or trace the corresponding database table and column for a subject area reporting field.

    The spreadsheet applies to Fusion ERP Release 11.

     

  • Kimberly N.
    A report that tracks user access activity history13
    Topic posted October 2, 2019 by Kimberly N.Red Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    A report that tracks user access activity history
    Summary:
    A report for security that tracks user login history what data or module was touched
    Content:

    Does anyone know how/where I can get this information together?  This is for security audit and we need to be able to see the /what/when data attributes.  Who login and what data or module this user accessed with history logging.  I'm only able pull the User and Roles data but not at the what data accessed during the logged in session. 

    Version:
    18C
  • Wendy Ware
    SQL to Report on List of User Logins Per DayAnswered135.0
    Topic posted January 28, 2019 by Wendy WareBronze Crown: 15,000+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    SQL to Report on List of User Logins Per Day
    Summary:
    seeking a listing of unique user logins
    Content:

    Can anyone provide SQL, or perhaps just table name, to get a list of unique user logins into Fusion?  Thanks, Wendy

  • Donald Ferreira
    Java.sql.SQLException: Invalid column indexAnswered125.0
    Topic posted November 15, 2019 by Donald FerreiraRed Ribbon: 250+ Points, tagged BI Publisher, BI Publisher Data Models in General OBIEE public
    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

  • Dilip Kuchipudi
    Policy Predicate ErrorAnswered125.0
    Topic posted October 25, 2019 by Dilip KuchipudiRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Procurement reporting, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Policy Predicate Error
    Summary:
    When querying some tables and views we are getting Policy Predicate Error
    Content:

    Selecting data from per_person_names_f or hz_parties is giving a policy predicate error and so the data model is erring out.  Any suggestions please provide how to overcome this.

    Version:
    19C
  • Rinku Gautam
    rtf template - display constant text on every page125.0
    Topic posted July 28, 2019 by Rinku GautamRed Ribbon: 250+ Points, tagged BI Publisher, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    rtf template - display constant text on every page
    Content:

    Hi All,  

    I have a rtf template which contains nothing but a (row*column) table.  

    I need to display a constant text like "Hello" at the bottom of every pageother than footer or header.  

    Request the experts to pls share their invaluable inputs.

     

    Thanks,

    Rinku

  • Prudence Kruchten
    BIP OptionsAnswered124.8
    Topic posted May 15, 2018 by Prudence KruchtenSilver Crown: 22,500+ Points, tagged BI Publisher, BI Publisher Data Models in General OBIEE public
    Title:
    BIP Options
    Content:

    Hi experts - I need some assistance with some options within BI Publisher reporting, hoping you can help!

    1) Is it possible to allow users to type into a parameter field their choices, rather than having to choose from a drop down menu?  It appears that with the menu option selected, users can select multiple options, but is it possible for them to paste into that field vs having to sort through the full menu list to find their options.  EX: Business Unit = Human Resources;Information Technology.  Can I just copy/paste those two choices in?

    EDIT: See chosen best answer

    2) Is it possible to set the default report output options?  Right now, I see that the default is always Interactive; HTML; RTF; PDF; Excel (*.xlsx); PowerPoint (*.pptx).  I would like to change those defaults but cannot find where to do that.  I know I can do it at the report level, but I have to change it every single time I create a report, and I'd like to change that.

    EDIT: Appears there is no global setting for this

    Thank you all!

    EDIT 17MAY2018: As I asked two questions, updated with answers for others to view

  • Sudhir K
    Filtering Issue on Data Model125.0
    Topic posted May 19, 2017 by Sudhir KRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Filtering Issue on Data Model
    Summary:
    The results of the data model are not being filtered
    Content:

    we are trying to create a simple data model with a variable. But the data is not being filtered as per the value chosen. attached screen shot has all the detailed steps.