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.
  • Ling Xiang
    R13.18A OTBI BI Catalog Lockdown24.7
    Topic posted June 15, 2018 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, Reporting and Analytics in Sales > Reporting and Analytics for Sales 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.
  • 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

  • Kimberly N.
    A report that tracks user access activity history13
    Topic posted October 2, 2019 by Kimberly N.Red Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    A report that tracks user access activity history
    Summary:
    A report for security that tracks user login history what data or module was touched
    Content:

    Does anyone know how/where I can get this information together?  This is for security audit and we need to be able to see the /what/when data attributes.  Who login and what data or module this user accessed with history logging.  I'm only able pull the User and Roles data but not at the what data accessed during the logged in session. 

    Version:
    18C
  • Andy French
    Able to change "Searching..." text?
    Topic posted July 13, 2016 by Andy FrenchGold Medal: 3,500+ Points, tagged Analyses, BI Publisher, Customizing Layout, Customizing Reports, OBI Answers, OBIEE Answers, Report Layouts, Reports in General OBIEE public
    Title:
    Able to change "Searching..." text?
    Summary:
    Able to change "Searching..." text?
    Content:

    Are we able to change the text on the "Searching..." pop up that appears when an analysis is loading? See attached. We have some reports that are very large and take several minutes to load. Ideally, I'd like the message to say "Running. Report may take a few minutes to load."

     

     

     

     

     

    Image:
  • Abul Khair
    Access Denied for user to path..1
    Topic posted August 30, 2017 by Abul KhairBlack Diamond: 60,000+ Points, tagged Analyses, BI Publisher, BI Publisher Data Models, BI Publisher Report Templates in General OBIEE public
    Title:
    Access Denied for user to path..
    Summary:
    Access Denied for user to path..
    Content:

    Hi, 

    I'm a super user and have high level of security, but in the Report when I select Admin View and look at specific user's folder. I get the access denied error. Is there a role I am missing? 

    Image:
  • Kamran Butt
    Access for General Ledger DashboardsAnswered4
    Topic posted September 23, 2019 by Kamran ButtRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Public Sector, Reports in Reporting and Analytics for ERP public
    Title:
    Access for General Ledger Dashboards
    Summary:
    Cannot view data for seeded GL Analytics Dashboards
    Content:

    Hello,

    What security role do I need to access the General Ledger Dashboards: Account Analysis, General Journals, Trial Balance, etc?

    At the moment, I am a super-user, I can see and edit all the objects, but I see no data in any of the reports.

    These are the reports I am trying to access: https://docs.oracle.com/cd/E51367_01/financialsop_gs/OCUAR/F1550150AN11FF9.htm#F716749AN122F4. The BI Publisher reports work without any issues, but the Analytics reports do not show any data.

    Any thoughts would be appreciated.

    Thanks!

    Version:
    Oracle Cloud 19C (11.13.19.07.0)
    Image:
  • Elliot Hall-Walker
    Accounts Receivable Reconciliation Report3
    Topic posted August 20, 2019 by Elliot Hall-WalkerGreen Ribbon: 100+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Accounts Receivable Reconciliation Report
    Content:

    Hello,

    I am looking to build a reconciliation focusing on the Accounts receivable transactions, I want to show the number of Accounts Receivable transactions that are currently unreconcilled:

    1. Does anyone know if this can be done in OTBI or is it a BI Publisher report?

    2. Has anyone built one successfully 

    Version:
    OTBI on Cloud
  • DeeDee Forwood
    Accounts Receivable Report (transactions and...5
    Topic posted April 5, 2019 by DeeDee ForwoodGreen Ribbon: 100+ Points, tagged BI Publisher, Fusion Financial reporting, Reports in Reporting and Analytics for ERP public
    Title:
    Accounts Receivable Report (transactions and receipts)
    Summary:
    Need ad-hoc AR report identifying customer billing and receivable transactions (including accounting information)
    Content:

    Boise State has a requirement to provide campus end-users with a report  that will allow them to search for an Accounts Receivable customer and have all their billing and receivable transactions (including accounting information) displayed.    The requirement is to allow the end-user to enter a customer number, a customer account description, an accounting segment and/or an accounting date range.    

    Has anyone had similar requirement and developed a report or SQL that we could model?