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.
  • Veronica Dumitriu
    Drill Down To Fusion Financial Applications from OTBI ERP...804.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
  • Ling Xiang
    R13 Financials OTBI subject area to database lineage mapping...334.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. 

  • Andy Gough
    OTBI Dashboard and Reports for Expenses155.0
    Topic posted December 23, 2016 by Andy GoughBronze Medal: 1,250+ Points, tagged Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    OTBI Dashboard and Reports for Expenses
    Summary:
    An OTBI dashboard with a series of drillable reports for Expenses
    Content:

    The attached catalog files can be imported into an ERP Cloud instance to create a dashboard with a series of drillable reports for expenses. Please see screenshot and attached files for details on how to use the dashboard, and how to import it into your environment.

    Enjoy!

    Andy

    Image:
  • Ling Xiang
    R12 ERP OTBI subject areas to database tables mapping...104.9
    Topic posted March 30, 2017 by Ling XiangGold 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, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    R12 ERP OTBI subject areas to database tables mapping spreadsheets
    Summary:
    R12 Financial and Supply Chain Management OTBI subject areas to database tables mapping spreadsheets
    Content:

    These spreadsheets are published by Oracle OTBI Development.  These spreadsheets document Fusion Financial and Supply Chain Management OTBI subject areas and the corresponding View Objects and database tables and columns.  Customers can use these spreadsheets to search for reporting fields in OTBI subject areas or trace the lineage from subject areas to database tables, columns and view objects or vice versa.  

    The spreadsheets apply to Fusion ERP and SCM Release 12.

    Please note In R12 users can search for a field in a subject area in OTBI.

  • Andy Gough
    OTBI Report for AP Invoice Holds94.9
    Topic posted August 16, 2016 by Andy GoughBronze Medal: 1,250+ Points, tagged Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    OTBI Report for AP Invoice Holds
    Summary:
    Sample OTBI report for ERP Cloud providing a list of AP Invoices on Hold
    Content:

    Sample OTBI Report for ERP Cloud: AP Invoices on Hold

    This report provides a list of AP Invoices currently on hold, as per the screenshot below.

     

    Instructions to Deploy in Your Environment:

    1. Create a new empty OTBI report, using any Subject Area – don’t bother to add any columns to your report
    2. In the Report Editor, go to the “Advanced” tab
    3. Clear the text from the “Analysis XML” box
    4. Paste the contents of the attached file “AP Holds Report.txt” into the “Analysis XML” box and click the “Apply XML” button
    5. Go back to the “Results” tab and you should see the report
    6. Save the report
    Image:
    Document:
  • Manavalan Ethirajan
    Report Using Procure to Pay Subject Area54.8
    Topic posted October 24, 2017 by Manavalan EthirajanSilver Medal: 2,000+ Points, tagged Fusion Procurement reporting, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Report Using Procure to Pay Subject Area
    Summary:
    A new subject area called “Procure to Pay Real Time” has been added to Procurement’s Oracle Transactional Business Intelligence or OTBI. You can use this subject area to create your own ad-hoc report.
    Content:

    Report on spend for purchase orders and their associated requisitions, invoices, receipts, and accounts using a new Procure to Pay Real Time subject area in Oracle Transactional Business Intelligence(OTBI). It allows Procure to Pay reporting using metrics, attributes and dimensions for requisitions, purchase orders, invoices and receipts. This helps the organization to slice and dice the Procure to Pay data.With single subject area, buying organizations can now analyze data patterns and trends which can be used to drive decisions to monitor and improve the procurement process.

     

    Image:
    Document:
    Document:
  • Alan Shepherd
    Procurement OTBI Dashboards105.0
    Topic posted May 17, 2018 by Alan ShepherdRed Ribbon: 250+ Points, tagged Fusion Financial reporting, Fusion Procurement reporting, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Procurement OTBI Dashboards
    Summary:
    ERP Procurement OTBI Reports and Dashboards uploaded for the Community
    Content:

    Sharing a procurement to pay dashboard with multiple tabs containing example reports displaying typical areas of interest within the procurement arena.

    Reports include the following:

    General procurement spend data

    Procurement performance reports

    Example of drivers for Sourcing

    Inflight Sourcing activity monitoring

    Example of a Transactional Contract Register, with parameters

    Enterprise Contracts Register

    Then a couple for showing requisition activity, open purchase orders and retrospective purchase orders.

    A dashboard for supplier invoicing

    Supplier performance, focusing on transactional elements

    Supplier qualification management subject areas are used to surface a view of supplier data and activities.

     

    I have attached an MP4 to show the reports in operation  Please see link:  

    https://vimeo.com/271128781

    Enjoy Alan

     

    Image:
    Document:
    Video:
  • Hemant Gupta
    R13 SCM and Procurement OTBI subject areas to database...44.9
    Topic posted October 9, 2018 by Hemant GuptaRed Ribbon: 250+ Points, tagged Business Intelligence, Costing, Innovation Management, Installed Base, Inventory, Maintenance, Manufacturing, Order Management, OTBI, Pricing, Procurement, Product Development, Product Information Management-PIM, Quality – Inspections, Reporting and Analytics, SCM, Supply Chain Collaboration, Supply Chain Financial Orchestration-SFO, Supply Chain Planning in Reporting and Analytics for SCM public
    Title:
    R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet
    Summary:
    R13 SCM and Procurement OTBI subject areas to database lineage mapping spreadsheet
    Content:

    This spreadsheet is published by Oracle OTBI Development. 

    Release: R13.19A, R13.19B, R13.19C, R13.19D

    Information Covered:

    - Documents Fusion SCM and Procurement 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.