Posts

Posts

  • Ling Xiang
    R13.18A OTBI BI Catalog Lockdown44.6
    Topic last edited June 15, 2018 by Bernice LamBronze Crown: 15,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 last edited June 15, 2018 by Bernice LamBronze Crown: 15,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 last edited September 4, 2019 by Kelly CooperGold Trophy: 10,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

  • Sathya Kannan
    Procurement - Procure to Pay Real Time1
    Topic posted 4:37 AM by Sathya KannanBlue Ribbon: 750+ Points, tagged Business Intelligence, Create Requisition, How-To, Orders, OTBI, Payables, Requisition Processing, Setup, White Paper in Procurement > Purchasing public
    Title:
    Procurement - Procure to Pay Real Time
    Summary:
    Procurement - Procure to Pay Real Time not displaying the Receipt Numbers created against the POs
    Content:

    Hi,

    We would like to create an OTBI report using the Procurement - Procure to Pay Real Time analysis, but the receipt number (available under Invoice column) created for the Purchase orders is not displayed.

    Does anyone know the solution for this?

     

    Regards,

    Sathya Kannan

  • Hemant Kasibhotla
    OTBI Report on Cross subject areas35.0
    Topic posted October 9, 2019 by Hemant KasibhotlaRed Ribbon: 250+ Points, tagged OTBI in Reporting and Analytics for ERP public
    Title:
    OTBI Report on Cross subject areas
    Summary:
    PPM-AP Cross subject area report
    Content:

    We are implementing fusion Financials and PPM. The current practice is, project managers in PPM get to know the details of invoices and payments made to the subcon they engage with.

    To achieve this, I have created a custom role that only has "Payables Invoice Transaction Duty Role" and assigned it to one of the project managers.

    Tried to create an OTBI report with 2 subject areas:

    1. Payables Invoice Transactions  - Real Time

    2. Projects - Cross Subject Area Analysis - Real Time.

    The only common dimension that matches in these 2 subject areas is 'YEAR'. I am not able to get a report after performing necessary steps.

    Also, since I have give a financials duty role to the project manager, does it mean, 1 Financials license is consumed?

     

     

    Version:
    19C
  • Hari Thyagaraj
    Inventory Reconciliation with GL - Report
    Topic posted October 14, 2019 by Hari ThyagarajRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Supply Chain Management reporting, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Inventory Reconciliation with GL - Report
    Content:

    All - I have a requirement to show the Inventory Reconciliation with GL and I see two OOB reports (Costing balances and Inventory Valuation) to satisfy the requirement? Is that the only solution in Oracle? Can we create a custom OTBI analysis for this using the Subledger SA? Can you throw some light on this? 

  • Farooq Haider Syed, PMP
    How to restrict User to see own PRs data in OTBI Analysis
    Topic posted October 14, 2019 by Farooq Haider Syed, PMPBlack Diamond: 60,000+ Points, tagged OTBI, Procurement in Reporting and Analytics for SCM public
    Title:
    How to restrict User to see own PRs data in OTBI Analysis
    Summary:
    OTBI Purchasing Analysis Required to restrict user Created PR
    Content:

    Hi,

     

    I have created the analysis based on the requisition subject area and this analysis is accessible for all the user who are creating Purchase Requisition (PRs).

    How can I restrict the users to view their created PRs.

    Like USER A can view the requisition created by USER A.

    Thanks

     

  • Hussain Shaik
    "Supplier - Supplier Real Time"."-...2
    Topic posted October 11, 2019 by Hussain Shaik, tagged Fusion Financial reporting, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    "Supplier - Supplier Real Time"."- General"."Alternate Site Name" with Error: 14025
    Summary:
    While developing an OTBI Report using two Subject Areas ( "Payables Invoices - Transactions Real Time" and "Supplier - Supplier Real Time"), "Supplier - Supplier Real Time"."- General"."Alternate Site
    Content:

    When I create a OTBI Report with only "Supplier - Supplier Real Time", it works fine and generates the results.

    when I am creating OTBI report with below two subject areas
    1) "Payables Invoices - Transactions Real Time"
    2) "Supplier - Supplier Real Time"

    and use few columns as provided in "OTBI Report Query.txt", it works fine till for the rest of the columns from "Supplier - Supplier Real Time" except "Supplier - Supplier Real Time"."- General"."Alternate Site Name".

    If the report is developed with out all conditions then any column from "Supplier - Supplier Real Time" should fail, but it is not the case here.

    below columns are added and report generates fine.

    "Supplier - Supplier Real Time"."- Income Tax"."Federal Reportable" s_24,
    "Supplier - Supplier Real Time"."- Income Tax"."Supplier Income Tax type" s_25,
    "Supplier - Supplier Real Time"."- Income Tax"."Tax Payer ID" s_26,
    "Supplier - Supplier Real Time"."- Supplier Profile"."Alternate Name" s_27,
    "Supplier - Supplier Real Time"."- Supplier Profile"."Supplier Type" s_28,
    "Supplier - Supplier Real Time"."- Supplier Site Details"."Supplier Account State" s_29,
    DESCRIPTOR_IDOF("Supplier - Supplier Real Time"."- Supplier Profile"."Supplier Type") s_31,

    The error comes only for "Supplier - Supplier Real Time"."- General"."Alternate Site Name".

    Request you to please review and provide the way forward, as this is important for generating my OTBI report.

    Regards,
    Hussain.

    Document:
    Document:
  • Shakera Harriott-Livingston
    Spend Data1
    Topic posted October 10, 2019 by Shakera Harriott-Livingston, tagged BI Publisher Reports, Fusion, OTBI in Procurement > Purchasing public
    Title:
    Spend Data
    Summary:
    Most accurate way to pull spend data
    Content:

    What is the best and most accurate way to pull a spend data from Oracle Fusion; we want to pull the overall spend using invoices and possible the committed amount from POs

  • Veronica Dumitriu
    Drill Down To Fusion Financial Applications from OTBI ERP...754.8
    Topic last edited July 15, 2019 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