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.
  • Senthilrajan Vaithianathan
    BI Publisher Output File Name115.0
    Topic last edited December 12, 2019 by Senthilrajan VaithianathanBronze Trophy: 5,000+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    BI Publisher Output File Name
    Summary:
    BI Publisher output file name Suffixes Template/Layout Name
    Content:

    BI Publisher report output file from Oracle Fusion cloud suffixes the Template/Layout name at the end.

    How can we restrict the Template name being suffixed?

    Test Report 1_Layout1.PDF

    Here we have "Test Report 1" as the report name and "Layout1" as the template name.

     

    Image:
  • Dev Thota
    How PO requested delivery derived while creating OSP PO?1
    Topic posted December 13, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Electronic Records and Signatures, Manufacturing MDM, Manufacturing Analytics, OTBI, Production Execution, Production Scheduling, Public Sector, Tip, White Paper, Work Execution, Work Request Management in Manufacturing & Maintenance > Manufacturing public
    Title:
    How PO requested delivery derived while creating OSP PO?
    Summary:
    How PO requested delivery derived while creating OSP PO?
    Content:

    Hi,

    Currently when we are creating an OSP PO the requested delivery date on the PO is current date. We would like to know how it is derived and can we have future date as the requested delivery date?

    Version:
    19D
  • Pavan Kasetty
    Identify OTBI / BIP reports using a particular column5
    Topic posted December 12, 2019 by Pavan Kasetty, tagged BI Publisher, Fusion Financial reporting, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    Identify OTBI / BIP reports using a particular column
    Summary:
    Identify OTBI / BIP reports using a particular column
    Content:

    Hi All,

    Is there a way to identify OTBI report and BI Publisher reports that are using a particular column, for example department_name.

    Regards,

    Pavan.

  • angela ahrens
    otbi reports - how do i find out you last modified report?35.0
    Topic posted December 11, 2019 by angela ahrensRed Ribbon: 250+ Points, tagged OTBI in Reporting and Analytics for ERP public
    Title:
    otbi reports - how do i find out you last modified report?
    Summary:
    otbi reports - how do i find out you last modified report?
    Content:

    otbi reports - how do i find out you last modified report?   

    i only see owner and that is person that originally created folder.  I want to know who last modified a report.

     

    Image:
  • Sujan Gutha
    OTBI Reports Migration11
    Topic posted December 10, 2019 by Sujan GuthaGreen Ribbon: 100+ Points, tagged OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    OTBI Reports Migration
    Summary:
    OTBI Reports Migration Strategy
    Content:

    Hi,

    Do we have any DevOps approach in migrating OTBI Reports like catalog,datamodel and template from one environment to the other rather than a manual approach.

    if we have , can you paste a sample code snippet how this is achieved.

    Thank You!

    Version:
    19C (11.13.19.07.0)
  • Ling Xiang
    R13 Financials OTBI subject area to database lineage mapping...344.8
    Topic last edited October 31, 2019 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. 

  • Bradley Quangson
    SCM Item PVOs2
    Topic posted December 11, 2019 by Bradley QuangsonRed Ribbon: 250+ Points, tagged BI Cloud Connector, Business Intelligence, Inventory, OTBI, SCM in Reporting and Analytics for SCM public
    Title:
    SCM Item PVOs
    Summary:
    SCM Item PVOs Definition or explanation
    Content:

    Hi,

    I am using BICC to extract data from ERP Cloud for downstream integration with a client's data lake. We are in a process of discovering PVOs that are appropriate for reporting requirements. To help the discovery process, I am using the BICC Data Lineage file and also the OTBI Data Lineage.

    Currently, I have identified 3 PVOs that are strikingly similar and the client would like to know what the difference between them are.

    The obvious answer is that here are some columns not available one or the other, but they all seem to focus on items so there's are many shared columns. Is there any documentation to explain or describe each PVO?

    The three PVO in questions are:

    1. FscmTopModelAM.EgpItemsPublicModelAM.Item

    2. FscmTopModelAM.EgpItemsPublicModelAM.InventoryItemRef

    3. FscmTopModelAM.EgpItemsPublicModelAM.InventoryItem

    Thanks,

    Bradley

  • Janko Jovicic
    ORA-03113: end-of-file on communication channel error -...35.0
    Topic posted November 28, 2019 by Janko JovicicBronze Medal: 1,250+ Points, tagged OBIEE Answers, OTBI, Report Output, Reports in General OBIEE public
    Title:
    ORA-03113: end-of-file on communication channel error - Please Help
    Content:

    Hi All,


    In last few months, for the second time we are facing one quite strange issue. Random users, with random reports (or some user with all reports) are facing following error message and code:

    We had technical SR (3-20715306161) where we bounce the server at one point of time which still didnt fix the issue. Issue was gone after 3,4 days.

    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)

    State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)

    State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)

    State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 3113, message: ORA-03113: end-of-file on communication channel Process ID: 246507 Session ID: 6224 Serial number: 29851 at OCI call OCIStmtExecute: BEGIN fnd_session_mgmt.attach_session('9861821953AF9216E0534C8D630A8F6D'); END;. (HY000)

    State: HY000. Code: 17011. [nQSError: 17011] SQL statement execution failed. (HY000)

     

    Now we are having the same problem, it does impact less people  accross the globe (Germany, UK, Singapore) than the previous time, but at still reports are erroring quite randomley and also some users cannot run any. Clearing cache/ logging in out does not solve a problem.


    Users on the front end are just sseeing error - Please contact your system Adminsitrator where back in the logs we are seeing the error from above.

    Did anyone face similar issue in the past or at the moment and are there are any recommendation/ ideas how to solve it and what could be the rootcause?


    Regards,
    Janko