Posts

Posts

  • Ling Xiang
    R13.18A OTBI BI Catalog Lockdown5.0
    Topic posted June 15, 2018 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, BI Publisher Reports, OTBI, Reporting and Analytics, Sample Reports in Reporting and Analytics for SCM public
    Title:
    R13.18A OTBI BI Catalog Lockdown
    Summary:
    With 13.18A release customers will no longer be able to modify the shipped BI catalog content.
    Content:

    R13.18A OTBI Product Alert

    This product alert is published by Oracle OTBI Product Development.

    Release 13.18A Factory BI Catalog Lockdown

    To minimize upgrade regression, an enhancement has been introduced in the 13.18A release to permanently make the shipped BI catalog content read-only.  If users attempt to modify the shipped BI catalog content including folder permissions, they will receive an alert "You are not allowed to modify factory content. Save your own content in /Shared/Custom."  Customers that upgrade from R12 to R13 will no longer be able to make changes to the delivered BI catalog even with BI Administrator role. Starting with R13.18A, BI catalog folders will behave as follows:

    • Customers must save all custom content in /Shared/Custom folder or create new sub-folders under /Shared to maintain custom content.
    • Except for /Shared/Custom folder, customers can no longer make any modifications to the delivered BI catalog. If a user attempts to add, change or remove any object including permission list in the delivered catalog folder, he/she will get an error "You are not allowed to modify factory content. Save your own content in /Shared/Custom."
    • Customers are permitted to retain EXISTING custom top-level folders under Shared. All existing content in those top-level custom folders will be preserved.
    • Customers cannot add, remove or change permissions on the shipped folders, e.g. /Shared/ Human Capital Management
    • Customers cannot modify the folder permissions to 'hide' the shipped factory catalog folder, e.g. hide /Shared/Marketing.
    Impact on R12 upgrade customers:
    • For customers upgrading from R12, all existing custom content in /Shared/Custom or custom folders under /Shared and their sub-folders will remain as they are.  However, if customers have modified the content in the delivered BI catalog folders, e.g. added custom reports, modified delivered reports, modified folder or report permission, all changes to this content will be lost after the R13 upgrade.  Customers are advised to archive their custom BI catalog to a file prior to R13 upgrade; and after R13 upgrade customers can unarchive the custom projects in the /Shared/Custom folder.  

     

    • Fusion application users are auto-provisioned with BI Consumer role, which allows them to read and traverse the BI catalog folders. This access is for folder viewing and navigation only and doesn't give the user the privilege to view, open, edit and execute BI reports, for which the user has no security authorization. An enhancement is in development to restrict access to BI catalog folders such that a user will no longer be able to see and traverse BI catalog folders that he or she has no security authorization to access.
  • Ling Xiang
    R13.18A OTBI BI Catalog Lockdown24.7
    Topic posted June 15, 2018 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, Reporting and Analytics in Sales > Reporting and Analytics for Sales public
    Title:
    R13.18A OTBI BI Catalog Lockdown
    Summary:
    With 13.18A release customers will no longer be able to modify the shipped BI catalog content.
    Content:

    R13.18A OTBI Product Alert

    This product alert is published by Oracle OTBI Product Development.

    Release 13.18A Factory BI Catalog Lockdown

    To minimize upgrade regression, an enhancement has been introduced in the 13.18A release to permanently make the shipped BI catalog content read-only.  If users attempt to modify the shipped BI catalog content including folder permissions, they will receive an alert "You are not allowed to modify factory content. Save your own content in /Shared/Custom."  Customers that upgrade from R12 to R13 will no longer be able to make changes to the delivered BI catalog even with BI Administrator role. Starting with R13.18A, BI catalog folders will behave as follows:

    • Customers must save all custom content in /Shared/Custom folder or create new sub-folders under /Shared to maintain custom content.
    • Except for /Shared/Custom folder, customers can no longer make any modifications to the delivered BI catalog. If a user attempts to add, change or remove any object including permission list in the delivered catalog folder, he/she will get an error "You are not allowed to modify factory content. Save your own content in /Shared/Custom."
    • Customers are permitted to retain EXISTING custom top-level folders under Shared. All existing content in those top-level custom folders will be preserved.
    • Customers cannot add, remove or change permissions on the shipped folders, e.g. /Shared/ Human Capital Management
    • Customers cannot modify the folder permissions to 'hide' the shipped factory catalog folder, e.g. hide /Shared/Marketing.
    Impact on R12 upgrade customers:
    • For customers upgrading from R12, all existing custom content in /Shared/Custom or custom folders under /Shared and their sub-folders will remain as they are.  However, if customers have modified the content in the delivered BI catalog folders, e.g. added custom reports, modified delivered reports, modified folder or report permission, all changes to this content will be lost after the R13 upgrade.  Customers are advised to archive their custom BI catalog to a file prior to R13 upgrade; and after R13 upgrade customers can unarchive the custom projects in the /Shared/Custom folder.  

     

    • Fusion application users are auto-provisioned with BI Consumer role, which allows them to read and traverse the BI catalog folders. This access is for folder viewing and navigation only and doesn't give the user the privilege to view, open, edit and execute BI reports, for which the user has no security authorization. An enhancement is in development to restrict access to BI catalog folders such that a user will no longer be able to see and traverse BI catalog folders that he or she has no security authorization to access.
  • Ling Xiang
    R13.18A OTBI BI Catalog Lockdown44.6
    Topic posted June 15, 2018 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    R13.18A OTBI BI Catalog Lockdown
    Summary:
    With 13.18A release customers will no longer be able to modify the shipped BI catalog content.
    Content:

    R13.18A OTBI Product Alert

    This product alert is published by Oracle OTBI Product Development.

    Release 13.18A Factory BI Catalog Lockdown

    To minimize upgrade regression, an enhancement has been introduced in the 13.18A release to permanently make the shipped BI catalog content read-only.  If users attempt to modify the shipped BI catalog content including folder permissions, they will receive an alert "You are not allowed to modify factory content. Save your own content in /Shared/Custom."  Customers that upgrade from R12 to R13 will no longer be able to make changes to the delivered BI catalog even with BI Administrator role. Starting with R13.18A, BI catalog folders will behave as follows:

    • Customers must save all custom content in /Shared/Custom folder or create new sub-folders under /Shared to maintain custom content.
    • Except for /Shared/Custom folder, customers can no longer make any modifications to the delivered BI catalog. If a user attempts to add, change or remove any object including permission list in the delivered catalog folder, he/she will get an error "You are not allowed to modify factory content. Save your own content in /Shared/Custom."
    • Customers are permitted to retain EXISTING custom top-level folders under Shared. All existing content in those top-level custom folders will be preserved.
    • Customers cannot add, remove or change permissions on the shipped folders, e.g. /Shared/ Human Capital Management
    • Customers cannot modify the folder permissions to 'hide' the shipped factory catalog folder, e.g. hide /Shared/Marketing.
    Impact on R12 upgrade customers:
    • For customers upgrading from R12, all existing custom content in /Shared/Custom or custom folders under /Shared and their sub-folders will remain as they are.  However, if customers have modified the content in the delivered BI catalog folders, e.g. added custom reports, modified delivered reports, modified folder or report permission, all changes to this content will be lost after the R13 upgrade.  Customers are advised to archive their custom BI catalog to a file prior to R13 upgrade; and after R13 upgrade customers can unarchive the custom projects in the /Shared/Custom folder.  

     

    • Fusion application users are auto-provisioned with BI Consumer role, which allows them to read and traverse the BI catalog folders. This access is for folder viewing and navigation only and doesn't give the user the privilege to view, open, edit and execute BI reports, for which the user has no security authorization. An enhancement is in development to restrict access to BI catalog folders such that a user will no longer be able to see and traverse BI catalog folders that he or she has no security authorization to access.
  • Donald Ferreira
    Java.sql.SQLException: Invalid column index1
    Topic posted November 15, 2019 by Donald FerreiraGreen Ribbon: 100+ 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

  • Scott Madole
    Custom ESS Job Parameters Display Issues on Submission Form
    Topic posted November 14, 2019 by Scott Madole, tagged BI Publisher in Reporting and Analytics for ERP public
    Title:
    Custom ESS Job Parameters Display Issues on Submission Form
    Summary:
    Custom ESS Job Parameters with Custom LOVs do not display correctly on ESS Job Submission Screen
    Content:

    I have created a custom ESS job from a Bi Publisher report.

    I have three parameters. When running the report, I have a couple of issues that I’m hoping you can help me with

    1. The length of the parameter field are too long, it goes off the screen. How do I shorten them?
    2. Each parameter has a custom LOV created for them. When you enter a partial value and tab out of the field, the search automatically pulls all values starting with what was entered. However when you enter the exact value and tab out of the field, the search does not find that value in the LOV.

    See attached file with screen prints of the setup.

     

    Version:
    19C
  • Sarah Munro
    How can I find all reports using the same BI Publisher Data...2
    Topic posted November 14, 2019 by Sarah MunroRed Ribbon: 250+ Points, tagged BI Publisher, BI Publisher Data Models, Public Sector in General OBIEE public
    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
  • Senthilrajan Vaithianathan
    Deprecating BI Publisher connectivity to the Oracle Fusion...75.0
    Topic posted November 13, 2019 by Senthilrajan VaithianathanBronze Trophy: 5,000+ Points, tagged BI Cloud Connector, BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Deprecating BI Publisher connectivity to the Oracle Fusion Tables
    Summary:
    Restricting access to Fusion Cloud database via BI Publisher Data Model
    Content:

    Heard that Oracle is planning is to restrict the access to Oracle Fusion cloud tables via BI Publisher data models? If that is true we will not be able to perform direct query on the SaaS Tables. Already OTBI Direct query access has been revoked.

    Has anyone got this news?  If this is true, what options we will have to perform any query on the Transactional tables for data validations and how can we create a custom reports and what will happen to existing custom BI Publisher reports that are built on custom data models?

  • 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 in General OBIEE public
    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:
  • Srekan
    is there any way where i can display more than 10 records...Answered2
    Topic posted November 11, 2019 by Srekan Red Ribbon: 250+ Points, tagged BI Publisher, Business Intelligence, Tip in Business Analytics > Business Intelligence public
    Title:
    is there any way where i can display more than 10 records default in interactive mode.
    Summary:
    is there any way where i can display more than 10 records default in interactive mode.
    Content:

    Hello All,

    i have created report in bi publisher 12c, when viewing report in interactive mode it displaying only 10 records default mode. need to scroll down for further records.

    is there any way where i can display more than 10 records default in interactive mode?

     

    regards

    joes

  • 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 in General OBIEE public
    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