Posts

Posts

  • Ling Xiang
    R13.18A OTBI BI Catalog Lockdown44.6
    Topic last edited June 15, 2018 by Bernice LamBronze Crown: 15,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.
  • Richard Beet
    Adding and embedding BI content into Fusion Cloud...28
    Topic posted August 15, 2017 by Richard BeetRed Ribbon: 250+ Points, tagged Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Adding and embedding BI content into Fusion Cloud Applications
    Summary:
    Looking for guidelines on which Fusion Cloud Applications pages we can add or embed BI content into
    Content:

    Hi All,

    Our client wants to be able to add some BI content to the Payables > Invoices page in Oracle Fusion Financials Cloud. Ideally they would like to add their own custom Infolet-like report to this page, but I am not sure this is possible...

    I was thinking that a potential option would be to use the Page Integration wizard to add a new tab to the Payables > Invoices page and include a custom BI report that displays the desired information.

    I have setup the tab in the Page Integration wizard and have confirmed that the new icon appears to the left of the Payables > Invoices page. However, when I go to Customize Page and select 'Add Content', it is not providing me with the option to select a report from the Oracle BI Presentation Catalog.

    - Does anyone know if we can embed BI content on this page?

    - Does anyone have any guidelines on exactly which pages we can add/embed BI content to in Fusion Cloud Applications?

    Thanks,

    Richard

  • Praveen Kumar
    OTBI/BIP Reporting Gap Analysis2
    Topic posted June 13, 2019 by Praveen Kumar, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    OTBI/BIP Reporting Gap Analysis
    Summary:
    Implementing Oracle ERP in all 3 modules ( HCM,SCM & Finance)
    Content:

    Hi,

    In the process of implementing Oracle ERP modules, there are many custom reports to be built using either OTBI and BIP.

    We wanted to know on how to do the gap analysis for identifying the reporting requirements in terms of either using out of the box reports provided by oracle versus customizing the out the box reports and building  new reports all together based on the customer report requirements

    Need details on how to get started on performing gap analysis on reporting part and get the reporting work started.

    Need details on whether to use OTBI versus BIP? Which one is feasible option to implement?

    Any insight will be helpful.

    Below are our the versions of the Oracle products that we are using.


    Oracle Cloud Application 19B (11.13.19.04.0) 
    Oracle Cloud Integration Version: 19.2.3.0.0 (190518.1400.28490)

     

    Thanks

    Praveen

    Version:
    Oracle Business Intelligence 11.1.1.9.0
  • Michelle Haynes
    Deep Link to open Payment info in view mode?2
    Topic posted May 24, 2019 by Michelle Haynes, tagged BI Publisher, Fusion Financial reporting, OBIEE Answers, OTBI in Reporting and Analytics for ERP public
    Title:
    Deep Link to open Payment info in view mode?
    Summary:
    Deep Link to open Payment info in view mode?
    Content:

    Hi,

    The deep links page in Fusion cloud show the following for the link to the payment https://<instance>.oraclecloud.com/fscmUI/faces/deeplink?objType=AP_VIEWPAYMENT&action=VIEW

    When I've used ap invoice and purchase order there is a unique identifier on the end (invoice id and po header id). Is there a way to find that value for the payment somewhere? 

    Examples of ap invoice and PO: 

    https://<instance>/fscmUI/faces/deeplink?objType=AP_VIEWINVOICE&action=VIEW&objKey=InvoiceId=300000047829672 
    https:/<instance>/fscmUI/faces/deeplink?objType=PURCHASE_ORDER&action=VIEW&objKey=poHeaderId=5036

  • Brian Burns
    Does Oracle Fusion Allow a Link to Microsoft Power BI?25.0
    Topic posted May 7, 2019 by Brian BurnsGold Crown: 30,000+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Does Oracle Fusion Allow a Link to Microsoft Power BI?
    Summary:
    I'm looking to see if Fusion would allow Microsoft Power BI to link to the Servers In Order to Build Reports
    Content:

    My company uses Microsoft Power BI for alot of their other internal reports. Is it possible to create a link from Microsoft Power BI to the Fusion SQL servers to build out reports using that program?

     

    Thank you,

    Brian

  • Amar
    'Payables Invoices - Holds Real Time' subject area...1
    Topic posted May 25, 2019 by AmarGreen Ribbon: 100+ Points, tagged BI Publisher, OBI Answers, OBIEE Answers, OTBI in Reporting and Analytics for ERP public
    Title:
    'Payables Invoices - Holds Real Time' subject area has been obsoleted from 19b
    Summary:
    Payables Invoices Holds Information Reorganized in the Oracle Transactional Business Intelligence Subject Areas
    Content:

    Hi All--> Payables Invoices Holds Information Reorganized in the Oracle Transactional Business Intelligence Subject Areas.

    Oracle Transactional Business Intelligence 'Payables Invoices - Holds Real Time' subject area has been obsoleted and both header and line level hold information is now included in Payables Invoices - Transactions Real Time subject area.

    ? --> Have anyone been worked/developed on building a new OTBI report after 'Payables Invoices - Holds Real Time' subject area has been obsoleted and have included those information in "Payables Invoices - Transactions Real Time" subject area.

    Thanks

  • Dev Thota
    How to add Reports to Task Menu (Reports and...55.0
    Topic posted September 24, 2018 by Dev ThotaBronze 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, Public Sector, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    How to add Reports to Task Menu (Reports and Analytics) in UI?
    Summary:
    How to add Reports to Task Menu (Reports and Analytics) in UI?
    Content:

    Hi

    How to add Reports to Task Menu (Reports and Analytics) in UI?

    We have requirement like in front end application we need to display reports(Shortcut)

    Please review the attached image.

    Image:
  • Stephanie Golly
    Subtract resulting values of CASE function3
    Topic posted May 3, 2019 by Stephanie Golly, tagged Analyses, OBIEE Answers, OTBI in General OBIEE public
    Title:
    Subtract resulting values of CASE function
    Summary:
    Need to subtract two values that are first derived using the CASE function
    Content:

    I have created two measure columns that use a CASE function. I am trying to subtract the resulting values. I can get it to work when I subtract a constant such as the number 1 below:

    (CASE  WHEN "Assessment Details"."Assessment Result Entry Start Date" = date '2019-05-01' AND "Assessment Result Details"."Activity Name" = 'Audit Test' THEN COUNT(DISTINCT "Control Details"."Control Name") END) - 1

    But when I try to subtract the values that would result from two CASE statements nothing returns:

    (CASE  WHEN "Assessment Details"."Assessment Result Entry Start Date" = date '2019-05-01' AND "Assessment Result Details"."Activity Name" = 'Audit Test' THEN COUNT(DISTINCT "Control Details"."Control Name") END) - (CASE  WHEN "Assessment Details"."Assessment Result Entry Start Date" = date '2019-05-03' AND "Assessment Result Details"."Activity Name" = 'Audit Test' THEN COUNT(DISTINCT "Control Details"."Control Name") END)

    Thoughts?

    Thanks!

  • Amarnath Govindu
    XML file for Disbursement Payment FormatsAnswered44.0
    Topic posted April 19, 2019 by Amarnath GovinduBronze Medal: 1,250+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers in Reporting and Analytics for ERP public
    Title:
    XML file for Disbursement Payment Formats
    Summary:
    XML file for Disbursement Payment Formats
    Content:

    All, I cannot see any Data model attached to disburse payment templates. how to get XML file for them if we need to modify the templates?

  • Juan Miguel Isip
    Use ESS to run a BI Publisher job that transmits reports via...15.0
    Topic posted September 5, 2018 by Juan Miguel IsipBronze Medal: 1,250+ Points, tagged BI Publisher, Discussion Forums, Fusion, OBI Answers, OBIEE Answers, Report Delivery, Scheduling or Agents, Setup, Setup/Administration in General OBIEE public
    Title:
    Use ESS to run a BI Publisher job that transmits reports via SFTP
    Summary:
    Is it possible to use ESS execute a BI Publisher job will transmits reports via SFTP?
    Content:

    We have built some Custom Reports in BI Publisher that extract data to a CSV file using a simple SQL script.
    This is scheduled running every hour and automatically transmits the file to a vendor's SFTP Server.

    However, I'm wondering if its possible to call these jobs from the Enterprise Scheduler (ESS) so that we can maintain it from there?
    Is this possible? I don't see any option for ESS jobs to transmit reports to a external SFTP server.

    Please advise.

    Version:
    Oracle Business Intelligence Publisher Enterprise