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 Cloud 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.
  • rady Kotb
    maintenance roadMap
    Topic posted 2:01 AM by rady Kotb, tagged Asset Master Data Management, Maintenance Analytics, OTBI, Preventive Maintenance, Public Sector, Safety Management, Tip, White Paper in Manufacturing & Maintenance > Maintenance public
    Title:
    maintenance roadMap
    Summary:
    maintenance roadMap
    Content:

    Kindly inform me if you have these information regarding roadmap and newfeature for the Maintenance in 19D and 20A

  • Kranthi Bharadwaj Achanta
    19B Feature - Compare Different Revisions of the Same Item...
    Topic posted July 17, 2019 by Kranthi Bharadwaj AchantaRed Ribbon: 250+ Points, tagged OTBI, Product Development, Product Hub, SCM in Product Lifecycle Management > Product Development public
    Title:
    19B Feature - Compare Different Revisions of the Same Item Structure with OTBI
    Summary:
    Latest revision LOV does not contain any values.
    Content:

    Hi All,

    We are trying to use the new 19B feature that Oracle has introduced to Compare different revisions of the same item structure. Below is the link to the release readiness doc.

    https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/pm/releases/19B/19B-scm-pm-wn.htm#F7393

    While trying to run "Expand Structure for Business Intelligence", i don't get any values in LOV in the field "Latest Revision".Attached the screenshot.

    Also we have added the "FBI_PRODUCT_TRANSACTION_ANALYSIS_DUTY" duty to the BI Consumer role...

    Could you please provide your inputs on this please.

     

    Regards,

    Kranthi Bharadwaj.

    Version:
    19B
    Image:
  • Amar
    SQL script for Roles , Privileges, Inherit roles & Data...Answered3
    Topic posted July 15, 2019 by AmarRed Ribbon: 250+ Points, tagged BI Publisher, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    SQL script for Roles , Privileges, Inherit roles & Data Security Policies
    Summary:
    SQL script for Roles , Privileges, Inherit roles & Data Security Policies
    Content:

    Trying to built a query to fetch Application Roles, Privileges, Data Security & Role Hierarchies, where i am able to get roles and their privileges but could not able to fetch the data security policies & roles inherited.

    I have tried using the application security tables ASE_ROLES_V, ASE_ROLE_ROLE_MBR, ASE_PRIV_ROLE_MBR, ASE_PRIVILEGE_VL, also not able to view data from data model.

     

    regards,

    Amar.

  • Usman Haq
    How to have dashboard at My dashboard specific to user3
    Topic posted July 15, 2019 by Usman Haq, tagged Fusion Financial reporting, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    How to have dashboard at My dashboard specific to user
    Summary:
    How to have dashboard at My dashboard specific to user
    Content:

    Users can be from different departments, we want to have user specific dashboard at My dashboard link. For example if procurement user click at My dashboard page, he has his dashboard and likewise. We are Oracle fusion SAAS user.

     

     

  • Senthilrajan Vaithianathan
    Adding extra filters to Infolets (Order Management -...1
    Topic posted July 12, 2019 by Senthilrajan VaithianathanBronze Medal: 1,250+ Points, tagged Fusion Procurement reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Adding extra filters to Infolets (Order Management - Seeded Infolets)
    Summary:
    Customization of Order Management landing page to filter the Infolets data along with default filter of 'Source System'
    Content:

    Currently the system allow users to filter and view Infolet data based on the values you can select in 'View By' prompt (Source System) in Order Management landing page, we want to add additional filter criteria's like Buyer, Business Unit, Supplier, Sales Channel etc...

    Navigation

    Oracle Fusion --> Spring Board --> Order Management --> Order Management --> Filter data in Infolets by selecting 'View By' prompt.

    • How to add a new filter in the Order Management landing page to filter the existing infolet data based on 'Sales Channel' similarly like existing filter 'Source System' under 'View By' filter tab?
    • Do we have any other option to filter the Infolet data with these additional filters?
    • Where the Infolets are stored and can we edit those Infolets ?
    Version:
    Oracle Cloud Application 19B (11.13.19.04.0)
    Image:
  • Koteswararao Yenikepalli
    Looking for the ESS JO History Report Or Avilable ESS Job...
    Topic posted July 12, 2019 by Koteswararao YenikepalliBronze Medal: 1,250+ Points, tagged Fusion, OTBI, White Paper in Logistics > Costing public
    Title:
    Looking for the ESS JO History Report Or Avilable ESS Job tables
    Summary:
    Looking for the ESS JO History Report Or Avilable ESS Job tables
    Content:

    Looking for the ESS JO History Report Or Avilable ESS Job tables

    Version:
    19 B
  • absalvi
    MOAC in BIP ReportsAnswered8
    Topic posted July 11, 2019 by absalvi Green Ribbon: 100+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Supply Chain Management reporting, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    MOAC in BIP Reports
    Summary:
    Implementing MOAC in BIP Reports
    Content:

    Hello,Trying to implement security based on the role assigned to a user. Following below note, however, have not been able to implement the same.

    Fusion Applications BI Publisher : Implementing FINS Security in SQL-based BI Publisher reports using Multi-Organization Access Control (MOAC) (Doc ID 1984271.1)

    We have used the synonym ap_invoices instead of ap_invoices_all, however, the data is not restricted. Still all rows are returned.

    Are there any pre-requisites to this? or the way in which a user is setup?

     

    -- Abhishek

  • Sivakumar Jayaraman
    Video : How to use OTBI to extract data from Manufacturing...
    Topic posted July 11, 2019 by Sivakumar JayaramanRed Ribbon: 250+ Points, tagged OTBI, Production Execution, Production Scheduling, Work Execution in Manufacturing & Maintenance > Manufacturing public
    Title:
    Video : How to use OTBI to extract data from Manufacturing Cloud to export to a third party production scheduling system