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 Cloud 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.
  • Amar
    SQL script for Roles , Privileges, Inherit roles & Data...Answered2
    Topic posted 6:10 AM by AmarRed Ribbon: 250+ Points, tagged BI Publisher, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    SQL script for Roles , Privileges, Inherit roles & Data Security Policies
    Summary:
    SQL script for Roles , Privileges, Inherit roles & Data Security Policies
    Content:

    Trying to built a query to fetch Application Roles, Privileges, Data Security & Role Hierarchies, where i am able to get roles and their privileges but could not able to fetch the data security policies & roles inherited.

    I have tried using the application security tables ASE_ROLES_V, ASE_ROLE_ROLE_MBR, ASE_PRIV_ROLE_MBR, ASE_PRIVILEGE_VL, also not able to view data from data model.

     

    regards,

    Amar.

  • absalvi
    MOAC in BIP Reports2
    Topic posted July 11, 2019 by absalvi Green Ribbon: 100+ Points, tagged BI Publisher, Fusion Financial reporting, Fusion Supply Chain Management reporting, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    MOAC in BIP Reports
    Summary:
    Implementing MOAC in BIP Reports
    Content:

    Hello,Trying to implement security based on the role assigned to a user. Following below note, however, have not been able to implement the same.

    Fusion Applications BI Publisher : Implementing FINS Security in SQL-based BI Publisher reports using Multi-Organization Access Control (MOAC) (Doc ID 1984271.1)

    We have used the synonym ap_invoices instead of ap_invoices_all, however, the data is not restricted. Still all rows are returned.

    Are there any pre-requisites to this? or the way in which a user is setup?

     

    -- Abhishek

  • Rinku Gautam
    Customer hierarchy using BI Analysis (or OTBI)65.0
    Topic posted June 18, 2019 by Rinku GautamRed Ribbon: 250+ Points, tagged Analyses, Fusion, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports, Tip in General OBIEE public
    Title:
    Customer hierarchy using BI Analysis (or OTBI)
    Content:

    Hi All,

    I need to build a customer hierarchy report using BI Analysis (or OTBI).

    It should display Party Name, Party Usage and Primary Address.

    Can anyone help me in achieving above.

     

    Thanks,

    Rinku

  • Praveen Kumar
    OTBI/BIP Reporting Gap Analysis5
    Topic posted June 13, 2019 by Praveen Kumar, tagged BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    OTBI/BIP Reporting Gap Analysis
    Summary:
    Implementing Oracle ERP in all 3 modules ( HCM,SCM & Finance)
    Content:

    Hi,

    In the process of implementing Oracle ERP modules, there are many custom reports to be built using either OTBI and BIP.

    We wanted to know on how to do the gap analysis for identifying the reporting requirements in terms of either using out of the box reports provided by oracle versus customizing the out the box reports and building  new reports all together based on the customer report requirements

    Need details on how to get started on performing gap analysis on reporting part and get the reporting work started.

    Need details on whether to use OTBI versus BIP? Which one is feasible option to implement?

    Any insight will be helpful.

    Below are our the versions of the Oracle products that we are using.


    Oracle Cloud Application 19B (11.13.19.04.0) 
    Oracle Cloud Integration Version: 19.2.3.0.0 (190518.1400.28490)

     

    Thanks

    Praveen

    Version:
    Oracle Business Intelligence 11.1.1.9.0
  • Kalyan Amaravathi
    BI Publisher - Adding Pivots with specific formatting on...5.0
    Topic posted June 13, 2019 by Kalyan AmaravathiGreen Ribbon: 100+ Points, tagged BI Publisher, Reports, Sample Reports in General OBIEE public
    Title:
    BI Publisher - Adding Pivots with specific formatting on Head Count Reports
    Summary:
    Approach to use/add Pivots based on some Head count Reports built using BI Publisher
    Content:

    Hi All,

    We have requirement to generate Pivot tables/Charts (Pie/Bar etc.) automatically based on the Head Count Data reported using a BI Publisher report (with Excel template). Using 97-2003 Excel Workbook template type (having one sample row with Repeating Group), we are able to achieve the auto generation of these Pivots based on various categories but the requirement is to have specific colour coding of the Pivot Chart elements based on the category. However, since BIP Excel template type is of 97-2003 Excel Workbook type (.xls not .xlsx), it is assigning some auto-colours to those chart elements once we run the BIP Report. I learnt that such specific colour coding options (Design and Layout tabs i.e.) are only available in the latest versions of MS Excel. So, can you please advise on the below?

    1. Is it possible to use a .xlsx template in BI Publisher currently?

    2. If not, then is there any possibility of achieving specific colour coding/formatting on the Pivot Chart elements?

    Appreciate any responses.

     

    Thanks,

    Kalyan

  • Rinku Gautam
    Data restriction on Data Model in Fusion Cloud65.0
    Topic posted June 11, 2019 by Rinku GautamRed Ribbon: 250+ Points, tagged BI Publisher, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    Data restriction on Data Model in Fusion Cloud
    Content:

    Hi,

    I am trying to restrict data to users having privilege to create Data Model wrt business unit

    e.g:  There are 2 business units BU_1 and BU_2. If a user logs in fusion application and proceeds ahead to create Data Model.

    Then he should only be able to access data related to BU_1 and not BU_2. By this, I mean across tables. Not using only secured view.

    Thanks,

    Rinku

  • Koteswararao Yenikepalli
    Sql Script to get the invoices status from the invoice...15.0
    Topic posted June 11, 2019 by Koteswararao YenikepalliBronze Medal: 1,250+ Points, tagged Financials, Help Center, Invoice Imaging, Payables, Reports, Sample Reports, Subscriptions, Tip in Financials > Financials — General public
    Title:
    Sql Script to get the invoices status from the invoice validation hyperlink
    Summary:
    Sql Script to get the invoices status from the invoice validation hyperlink
    Content:

    We have written the SQL query(Seeded Means package) to get the status of the invoice either it is accounted or unaccounted or paid or unpaid or approved or workflow approval but some time that package is not giving the correct results 

    Anyone come across this kind of situation please guide me to get the correct values here I have attached the screen to what are the fields I am looking for 

     

    Thanks,

    Koteswararao.

    Version:
    19A
    Image:
  • Rinku Gautam
    Rtf Template : Print specific texts on specific pages4
    Topic posted May 30, 2019 by Rinku GautamRed Ribbon: 250+ Points, tagged BI Publisher, Fusion Financial reporting, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    Rtf Template : Print specific texts on specific pages
    Summary:
    Oracle Fusion BIP
    Content:

    Hi All,

     

    In Oracle Fusion BI Publisher, I need to print certain texts on specific pages depends on how many pages gets printed in Customer Invoice:

    e.g.

    1) If the report is generating 5 pages, then 1st page should print "ABC", Intermediary pages (2-4) prints "PQR" and last page prints "XYZ".

    2) If the report is generating 2 pages, then 1st page should print "ABC", and last page prints "XYZ".

    3) If the report is generating 1 page, then it should print "XYZ". 

     

    Any help would be appreciative.

     

     

    Thanks,

    Rinku