Posts

Posts

  • 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.
  • Pavan Kasetty
    Identify OTBI / BIP reports using a particular column5
    Topic posted December 12, 2019 by Pavan Kasetty, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Identify OTBI / BIP reports using a particular column
    Summary:
    Identify OTBI / BIP reports using a particular column
    Content:

    Hi All,

    Is there a way to identify OTBI report and BI Publisher reports that are using a particular column, for example department_name.

    Regards,

    Pavan.

  • 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 in General OBIEE public
    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:
  • Senthilrajan Vaithianathan
    ESS Print Job Queue - Oracle Fusion Cloud
    Topic posted December 5, 2019 by Senthilrajan VaithianathanBronze Trophy: 5,000+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    ESS Print Job Queue - Oracle Fusion Cloud
    Summary:
    Accessing the ESS Print Job Queue from Oracle Fusion Cloud.
    Content:

    Hi, As part of performance testing we ran Invoice Print Program for a wide range of dates, customers, etc...

    The print job is still running and it keeps printing the physical paper at the printer at our office, i have two questions.

    1. Where can we see the list of Print requests from cloud to our On-Premise printer.

    2. How can abort the pending requests on cloud as our IT Operations team has confirmed that they don't see the queue in the local printer.

  • Senthilrajan Vaithianathan
    Instance details for BI Publisher Report Template - Fusion...2
    Topic posted December 4, 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, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Instance details for BI Publisher Report Template - Fusion ERP/SCM
    Summary:
    Water marking Instance details on BI Publisher Report and Emailing
    Content:

    We have a requirement to display the Instance name as watermark in some of the BI Publisher report, (i.e) DEV, TEST etc... based on the instance name/URL. And also change the email/print logic based on the instance name (Prod vs Non-Prod)

    We have some details in SYS_CONTEXT, what is the best way to get this information...

     

    Version:
    19D
  • Rajanikanth Mohanraju
    Combing OTBI Output in one row1
    Topic posted November 25, 2019 by Rajanikanth Mohanraju, tagged BI Publisher, Fusion Project reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Combing OTBI Output in one row
    Summary:
    Combing OTBI Output in one row
    Content:

    I'm using the subject area "Project Costing - Actual Real Time" to result Debits and Credits of Project Cost Expenditure Lines. The trouble is DRs are CRs are resulted in 2 separate rows. I wonder if anyone have attempted to result the data in a single row albeit in separate columns? 

    The below is the SQL issued for this OTBI Report. Concatenated Segments field hols Accounting KFF values.

    If so please advise.

    --------------------------------

    SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
       0 s_0,
       "Project Costing - Actual Costs Real Time"."Expenditure Item and Cost Distribution Details"."Apps Document Currency Code" s_1,
       "Project Costing - Actual Costs Real Time"."Expenditure Item and Cost Distribution Details"."Expenditure Comment" s_2,
       "Project Costing - Actual Costs Real Time"."Expenditure Item and Cost Distribution Details"."Expenditure Item Date" s_3,
       "Project Costing - Actual Costs Real Time"."Expenditure Item"."Expenditure Item" s_4,
       "Project Costing - Actual Costs Real Time"."Expenditure Type"."Resource Type Name" s_5,
       "Project Costing - Actual Costs Real Time"."General Ledger Account"."Account Type" s_6,
       "Project Costing - Actual Costs Real Time"."General Ledger Account"."Concatenated Segments" s_7,
       "Project Costing - Actual Costs Real Time"."Original Source References"."Transaction Source Name" s_8,
       "Project Costing - Actual Costs Real Time"."Processing Details"."Expenditure Item Expenditure Group Name" s_9,
       "Project Costing - Actual Costs Real Time"."Project"."Project Name" s_10,
       "Project Costing - Actual Costs Real Time"."Project"."Project Number" s_11,
       "Project Costing - Actual Costs Real Time"."Task"."Task Name" s_12,
       "Project Costing - Actual Costs Real Time"."Task"."Task Number" s_13,
       DESCRIPTOR_IDOF("Project Costing - Actual Costs Real Time"."General Ledger Account"."Account Type") s_14,
       DESCRIPTOR_IDOF("Project Costing - Actual Costs Real Time"."Task"."Task Name") s_15,
       "Project Costing - Actual Costs Real Time"."- Expenditure Item and Cost Distribution Measures"."Raw Cost in Transaction Currency" s_16
    FROM "Project Costing - Actual Costs Real Time"
    ORDER BY 1, 10 ASC NULLS LAST, 9 ASC NULLS LAST, 5 ASC NULLS LAST, 12 ASC NULLS LAST, 11 ASC NULLS LAST, 14 ASC NULLS LAST, 16 ASC NULLS LAST, 13 ASC NULLS LAST, 6 ASC NULLS LAST, 4 ASC NULLS LAST, 2 ASC NULLS LAST, 3 ASC NULLS LAST, 7 ASC NULLS LAST, 15 ASC NULLS LAST, 8 ASC NULLS LAST
    FETCH FIRST 500001 ROWS ONLY

    -----------------------------------------------

  • Mahgoub Salaheldien
    BICS migration to OAC7
    Topic posted November 25, 2019 by Mahgoub SalaheldienBronze Medal: 1,250+ Points, tagged OBI Answers in Reporting and Analytics for ERP public
    Title:
    BICS migration to OAC
    Summary:
    BICS migration to OAC
    Content:

    Hi All

    we have BICS on Paas which is not implemented yet and Oracle recommend to migrate to OAC. We need to know do we really need to migrate to OAC or we can use existing Fusion Saas reporting tools like OTBI, financial studio, publisher,.. to develop all needed role based dashboards and reports. Please advise as we need to decide on this asap

    Thanks

    Mahgoub

  • nathan morgan (at Client)
    What is catalog folder Extension?5.0
    Topic posted November 20, 2019 by nathan morgan (at Client)Silver Medal: 2,000+ 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 in General OBIEE public
    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:
  • Ling Xiang
    Please Save BI Answers Direct Database Query SQL Definition...2.0
    Topic posted November 18, 2019 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Please Save BI Answers Direct Database Query SQL Definition before 19D Upgrade
    Summary:
    Please save your BI Answers Direct Database Query SQL definition before 19D Upgrade
    Content:

    Please Note: This notice does not affect BI Publisher SQL data models and reports.

    Customers are strongly advised to save BI Answers Direct Database Query SQL definition before 19D Upgrade

    After 19D upgrade, you can continue to execute existing BI Answers Direct Database Query reports but you can no longer create, edit new reports or view report criteria.  You are strongly advised to review existing BI Answers Direct Database Query reports and save SQL definition for reports that need to be recreated in OTBI or BIP before 19D upgrade.

    Before 19D upgrade, you are strongly advised to save Direct Database Query SQL by using the following methods:

    • Open the report in Edit model, copy the SQL definition in the Criteria tab and paste the SQL statement in a text file and save the file.

    After 19D upgrade, you can no longer open Direct Database Query report criteria and can retrieve SQL from the report log file by using the following methods:

    • A user with BI Administrator privilege runs a Direct Database Query report. 
    • After the report runs, BI Administrator user clicks on Administration link, clicks on Manage Session, and clicks View Log for the executed report.  After log file opens, user copies and pastes the SQL statement in a text file and save the file.

    You must use this method to save BI Answers direct database query report definition before 20A upgrade as you will no longer be able to run BI Answers Direct Database Query after 20A upgrade. 

    If you have comments and concerns, please provide your feedback on this short OTBI customer survey.  Thank you for your time!

    Ling Xiang

    Oracle OTBI Product Management

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