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.
  • Ling Xiang
    R13.18A OTBI BI Catalog Lockdown5.0
    Topic last edited June 15, 2018 by Bernice LamBronze Crown: 15,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.
  • Sujan Gutha
    OTBI Reports Migration9
    Topic posted 7:30 AM by Sujan GuthaGreen Ribbon: 100+ Points, tagged OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    OTBI Reports Migration
    Summary:
    OTBI Reports Migration Strategy
    Content:

    Hi,

    Do we have any DevOps approach in migrating OTBI Reports like catalog,datamodel and template from one environment to the other rather than a manual approach.

    if we have , can you paste a sample code snippet how this is achieved.

    Thank You!

    Version:
    19C (11.13.19.07.0)
  • Veth Aven Espanol
    Calculate Tax at SO level1
    Topic posted November 26, 2019 by Veth Aven EspanolGreen Ribbon: 100+ Points, tagged Global Order Promising, Order Management, Order Management Analytics, OTBI, Public Sector, SCM, Supply Chain Financial Orchestration, Supply Chain Orchestration, Tip, White Paper in Order Management > Order Management public
    Title:
    Calculate Tax at SO level
    Summary:
    Tax is not calculated when order is saved, price or submitted even though tax code is set on customer and item. Is there any additional set-up needed in order to enable tax calculation at OM level?
    Content:

    Tax is not calculated when order is saved, price or submitted even though tax code is set on customer and item. Is there any additional set-up needed in order to enable tax calculation at OM level?

  • Phil Nibert
    Need an OTBI report/ field that shows PO AP Accrual Account25.0
    Topic posted December 6, 2019 by Phil NibertRed Ribbon: 250+ Points, tagged Business Intelligence, Financials, OTBI, Payables in Procurement > Purchasing public
    Title:
    Need an OTBI report/ field that shows PO AP Accrual Account
    Summary:
    Need an OTBI report/ field that shows PO AP Accrual Account
    Content:

    Hi would like to see if any of the OTBI subject areas for Procurement have a field that shows the PO AP liability account for the Purchase Order.  I can find OTBI fields in the Procurement - Procure to Pay Real Time and Procurement - Purchasing Real Time OTBI subject areas for the PO charge account but not the PO liability account.

    Version:
    Oracle Cloud Financials 19C
  • Neha Takkar
    Reports Run Count25.0
    Topic posted December 5, 2019 by Neha TakkarSilver Trophy: 7,500+ Points, tagged OBIEE Answers, OTBI, Reports in General OBIEE public
    Title:
    Reports Run Count
    Content:

    Is there a way to find out how many times a report was run and who ran it? Like we may have 10 reports and want to find out which is the report that is used the most and how many people have used it. Thank you!

  • Dev Thota
    How to add Reports to Task Menu (Reports and...65.0
    Topic posted September 24, 2018 by Dev ThotaGold 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, 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:
  • Vitor Lima
    OTBI how to list repeated values3
    Topic posted December 4, 2019 by Vitor Lima, tagged Business Intelligence, Order Management, OTBI, SCM, SQL in Reporting and Analytics for SCM public
    Title:
    OTBI how to list repeated values
    Summary:
    how to use list component to repeat values
    Content:

    Hello, I've created a customized report in OTBI and it i'm using the list component to present the data retrieved from the data model but, the list component is only presenting unique values within the results... much like a "Select Distinct" and for this particular report i need it to show all values regardless if they are repeating or not...

    Thanks a bunch,

    Vitor

     

    in the picture attached the report should show another number 2 in the fourth column 

    Image:
  • 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.

  • Tony Roff
    Report that tracks receipted PO's5
    Topic posted October 23, 2019 by Tony RoffBlue Ribbon: 750+ Points, tagged BI Cloud Connector, BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Report that tracks receipted PO's
    Summary:
    Does anybody have a report that tracks receipted PO's?
    Content:

    Hi all

     

    Just wondering with the accruals of receipted items each month, which reports are being run to track these amounts and therefore used to reconcile back to their reports?

     

    Thanks

     

    Tony

     

    Version:
    R13 - 19C