Posts

Posts

  • 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 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.
  • Jennifer Allen
    VIZIYA MAINTENANCE SUMMIT & USER GROUP 20191
    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

  • Veronica Dumitriu
    Drill Down To Fusion Financial Applications from OTBI ERP...754.9
    Topic posted May 3, 2018 by Veronica DumitriuSilver Medal: 2,000+ Points, tagged Fusion Financial reporting, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Drill Down To Fusion Financial Applications from OTBI ERP Reports
    Summary:
    The purpose of this White Paper is to demonstrate how users can drill from Oracle Transactional Business Intelligence (OTBI) adhoc reports to transaction details in Oracle Fusion Applications
  • Richard Beet
    Adding and embedding BI content into Fusion Cloud...315.0
    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

  • Ling Xiang
    R13 Financials OTBI subject area to database lineage mapping...244.8
    Topic posted August 4, 2017 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    R13 Financials OTBI subject area to database lineage mapping spreadsheet
    Summary:
    This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security.
    Content:

    This spreadsheet is published by Oracle OTBI Development.  This spreadsheet documents Fusion Financials OTBI subject areas, the corresponding View Objects and database tables and columns.  Customers can use this spreadsheet to search for reporting fields in OTBI subject areas or trace the lineage from subject area to database tables, columns and view objects or vice versa.  

    This spreadsheet also documents subject area security duty roles and job roles.

    The spreadsheet applies to Financials R13. 

  • Atul Kumar
    Invoice getting rejected with Invalid PO Number error215.0
    Topic posted December 20, 2018 by Atul KumarBronze Medal: 1,250+ Points, tagged Accounting Hub Cloud Service, Assets, Budgetary control, Cash Management, Collections, Configuration, Discussion Forums, Expenses, Financials, Fusion, General Ledger, Help Center, Intercompany, Invoice Imaging, OTBI, Payables, Period Close / Reconciliation, Public Sector, Receivables, Reports, Revenue Management, Search, Setup, Setup / Administration, Subledger Accounting, Subscriptions, Tip in Core Financials > Payables & Cash Management public
    Title:
    Invoice getting rejected with Invalid PO Number error
    Summary:
    Invoice getting rejected in Inteface with Invalid PO Number error
    Content:

    We are trying to create invoice in oracle using EDI and we have noticed that for particular LE/BU the invoice is getting processed and for other LE/BU, the invoices are getting rejected with Invalid PO Number, please let me know if we can overcome this issue, i have raised SR as well on the same...

     

    Thanks,

    Atul Kumar

  • Lakmal Somasiri
    Budget balances not available in General Ledger subject...Answered18
    Topic posted June 30, 2018 by Lakmal SomasiriBlue Ribbon: 750+ Points, tagged Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Budget balances not available in General Ledger subject areas
    Summary:
    Can we query budget balances in General Ledger subject areas?
    Content:
    Budget balances not available in General Ledger subject areas like 'General Ledger - Balances Real Time' or 'General Ledger - Transactional Real Time. Only the 'Actual' balances are there. Is this the intended behaviour or am I facing some issue. SR raised but it's not going anywhere. Please help. Thanks
  • Soumya Parhi
    Supplier Audit ReportAnswered175.0
    Topic posted April 13, 2018 by Soumya ParhiGold Trophy: 10,000+ Points, tagged BI Publisher, OTBI, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    Supplier Audit Report
    Summary:
    Supplier Audit Report
    Content:

    Good People,

    Anyone create supplier Audit Report as a custom one apart from the one available ?

    Thanks,

    Soumya

  • Tim Welsh
    Setting relative dates in a filter for an OTBI AnalysisAnswered173.0
    Topic posted April 28, 2017 by Tim WelshBlue Ribbon: 750+ Points, tagged Analyses, OBIEE Answers, OTBI, Reports, SQL in General OBIEE public
    Title:
    Setting relative dates in a filter for an OTBI Analysis
    Summary:
    In an OTBI Analysis is there a way to add into a relative date range into a filter?
    Content:

    I need an Analysis with a filter to pick up dates within the last week.  I don't see a way to do this in the normal filter properties and I'm getting errors when i add the below code into "Convert this filter to SQL"  Is there a way to do this either with the regular filter or with the Advanced SQL filter?  

     BETWEEN (SYSDATE - 7) AND SYSDATE