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 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

  • Tony Roff
    Supplier Portal - Invoices Awaiting Approval25.0
    Topic posted October 17, 2019 by Tony Roff, tagged FAQ, How-To, OTBI, Tip in Procurement > Supplier Management public
    Title:
    Supplier Portal - Invoices Awaiting Approval
    Summary:
    I need a report that can track outstanding "Invoice Requests" rather than established "Invoices"
    Content:

    Hi all

    My team and I are looking to fully utilise the Supplier Portal however, we're currently unable to maintain oversight of the invoices as (to our knowledge) there are no "out of the box" reports that are available to track these Invoice Requests or Approved by requester (and ready to be edited by Accounts Payable).

    For further detail, when the supplier submits an invoice via the portal, it's not classified as an invoice until it is approved by the Requester.

    (Requester is determined upon the email input at point of issuing the invoice).

    When the Supplier submits an Invoice it's actually classified as an Invoice Request instead until the Requester approves and then it turns into an invoice but then Accounts Payable is not made aware of it being approved by the requester.

    If anyone has a report as a solution to this or maybe some extra knowledge on how we can workaround this, it'd be great if you could share!

    Thanks

    Tony

     

     

     

     

    Version:
    R13 - 19C
  • Jennifer Wolfe
    Expenses Overview Real Time subject area1
    Topic posted October 16, 2019 by Jennifer WolfeRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    Expenses Overview Real Time subject area
    Summary:
    A summarization program needs to be run to gather information before data is available in this area.
    Content:

    We are creating some test reports from the Expenses Overview Real Time subject area.  There is basically no data there and I expected to see some as I know multiple claims have been entered in the system.

    In doing some research on this, I found this in Oracle's documentation:

    This subject area enables summarized, metric-based reporting. Use this subject area to analyze expenses across cost centers, compare current and previous period expenses, identify top spenders and cost centers, and spend by merchants  A summarization program needs to be run to gather information before data is available in this area.

    Can you help me to identify what this process might be?

    Thanks in advance,

    Jennifer

  • Sathya Kannan
    Procurement - Procure to Pay Real TimeAnswered4
    Topic posted October 16, 2019 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

  • 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