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 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.
  • Jennifer Allen
    VIZIYA MAINTENANCE SUMMIT & USER GROUP 2019
    Topic posted August 22, 2019 by Jennifer AllenSilver Medal: 2,000+ Points, tagged Asset Master Data Management, Maintenance Analytics, OTBI, Preventive Maintenance, Public Sector, Safety Management, Tip in Manufacturing & Maintenance > Maintenance public
    Title:
    VIZIYA MAINTENANCE SUMMIT & USER GROUP 2019
    Summary:
    Join us in Music City in November for our MAINTENANCE (only!) Summit - Oracle eAM & Maintenance Cloud together again!
    Content:

    VIZIYA MAINTENANCE SUMMIT & USER GROUP 2019

    Oracle and The Wonderful Company (among others!) are speaking at VIZIYA’s summit on November 4 - 8, 2019 in Nashville, TN

    VIZIYA is hosting a full week of engaging workshops, user presentations, product training, deep-dives into asset management best practices, networking events and more. Invite your prospects to join Oracle’s Maintenance Track and hear how Oracle Maintenance Cloud has made The Wonderful Company more efficient, by eliminating many manual processes, standardizing and automating processes and supporting their position as leaders in their industry. This is an unique MAINTENANCE only event with content for BOTH Maintenance Cloud and Oracle eAM!

    Be sure to join us!  Early Bird Registration of 20% discount : Oracle20AUG (expires at the end of September).

    Registration

  • Amar
    'Payables Invoices - Holds Real Time' subject area...1
    Topic posted May 25, 2019 by AmarBlue Ribbon: 750+ 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

  • Linda Stelling
    'Publish for Subscription' in OTBI Agent4
    Topic posted February 27, 2019 by Linda StellingSilver Medal: 2,000+ Points, tagged OBI Answers, OBIEE Answers, OTBI, Report Delivery in General OBIEE public
    Title:
    'Publish for Subscription' in OTBI Agent
    Content:

    Hi, can anyone point me to any information on how to best utilise this feature within OTBI agents. Ideally I am looking to establish a way to set an agent to notify recipients when an analysis has been run and data produced but not physically send it as an attachment (due to the inability to password protect the file).  I wondered if the Subscription functionality is the way to do this but I haven't really used it before so am a little unsure of what it's meant to do

    Apologies if this is documented somewhere obvious, I just can't seem to find anything. 

    Many thanks

    Linda

  • 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:
  • Clifford-Barrington Trett
    Absence Leave Amount & Payroll Element Name1
    Topic posted February 10, 2017 by Clifford-Barrington TrettBlue Ribbon: 750+ Points, tagged Analyses, Core HR, OTBI, Reports in General OBIEE public
    Title:
    Absence Leave Amount & Payroll Element Name
    Content:

    Good Day,

    We have been tasked to create a report where anyone who has booked less than a full days leave is highlighted.   This in its self is very easy and achievable.
    But there is a second requirement, the requesting team then want this/these people to only be highlighted if they have a Recurring Element in the "Payroll" - "Element Name" field.

     

    We have tried various different computations and realignments, also going onto Advanced Tab and then to apply sql after the relevant marker has been ticked.   And still no joy.   There are a minimum of 6 subfolders that match the SA's together as well.

     

    It always errors with this "No fact table exists at the requested level of detail"

     

    Any advice please,

    Thank you

  • Ravikiran K P
    Access OTBI Data without Job Roles3
    Topic posted January 9, 2018 by Ravikiran K P, tagged 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:
    Access OTBI Data without Job Roles
    Summary:
    For OTBI Administrators - Is there a way to access Data as a Super User without getting a specific Job Role assigned?
    Content:

    Hey Guys,

    We were checking to see if there is a way for OTBI Admins to access the reports/data as a Super User without having the Specific Job roles (like Inventory Manager, Warehouse Manager etc) assigned.

    We tried assigning all the %TRANSACTION_ANALYSIS_DUTY roles, but aren't able to access the data without Job Roles assigned. Any thoughts?

    Thanks,

  • Piyush Bihany
    Access to Procurement/Purchasing Subject Area & Purchasing...45.0
    Topic posted July 30, 2019 by Piyush BihanyGold Medal: 3,500+ Points, tagged BI Publisher Reports, Fusion, How-To, Orders, OTBI in Procurement > Purchasing public
    Title:
    Access to Procurement/Purchasing Subject Area & Purchasing Related Reports
    Summary:
    User without Buyer role are unable to Access Procurement Subject Area and Procurement Related Reports, Also they are unable to Create New Analysis
    Content:

    Client is live with Oracle Purchasing cloud and users have been creating PO on the Prod Instance.

    However there are few users who doesn't have the Buyer License (Buyer Role is not assigned) and don't have access to create and manage Purchase Order but still wants to review (view only access) for the Purchase order Data via Reports. 
     

    Client has additionally procured license for B84576 - Oracle Fusion Transactional Business Intelligence Cloud Service - Hosted Name, with an understanding that this will grant access to the users for BI Reports. 

    We have created a custom BI Role, and have added the following Privileges to the same: 
    BI Consumer Role 
    And have assigned the custom role to above listed users. 

    These users are unable to create a New Analysis (OTBI report) under the BI Page.

     
    Also for any existing OTBI Report, when the open the same, they are getting error as: 
    No Results 
    The specified criteria didn't result in any data. 

    However the same report is fetch data for other users, who are having Buyer role assigned. 

    Please advice, if in addition to creation of Custom Role for Oracle Fusion Transactional Business Intelligence Cloud Service, any other steps needs to be performed. 

    --

    PB

    Image:
  • Tausif Mulla
    Account value description in multi language25.0
    Topic posted January 28, 2019 by Tausif MullaBronze Medal: 1,250+ Points, tagged Accounting Hub Cloud Service, Assets, Budgetary control, Cash Management, Collections, Compliance, Configuration, Discussion Forums, Expenses, Financials, Fusion, General Ledger, Help Center, Intercompany, Invoice Imaging, OTBI, Payables, Period Close / Reconciliation, Public Sector, Receivables, Reports, Revenue Management, Security, Setup, Setup / Administration, Subledger Accounting in Core Financials > Financials – General public
    Title:
    Account value description in multi language
    Summary:
    Account value description in multi language
    Content:

    Hi,

    We have a requirement for a global project that the value set values (Descriptions) we have in "English" should be in multi language depending upon the user location. 

    For example, during configuration we will update all the description in "English" for value set values, however when a china user logins, he / she should be able to see the value description in Mandarian language. Similarly for other users across the globe.

    Please suggest if this is achievable in oracle cloud ERP.

    Thanks !