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 Lockdown24.7
    Topic posted June 15, 2018 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, Reporting and Analytics in Sales > Reporting and Analytics for Sales 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.
  • Pavan Kasetty
    Identify OTBI / BIP reports using a particular column2
    Topic posted 3:39 AM 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.

  • Saurabh Sharma
    Period Name- In OTBI report
    Topic posted Yesterday by Saurabh SharmaGreen Ribbon: 100+ Points, tagged BI Publisher, Fusion Supply Chain Management reporting, OTBI, Reports, Sample Reports, Tip in Reporting and Analytics for ERP public
    Title:
    Period Name- In OTBI report
    Summary:
    Need perod name should populate like DEC-FY-20 (DDDFFYY)
    Content:

    Hello Team,

    We want to have the Period name in our OTBI report in the format 'DEC-FY-20', 'SEP-FY-20'. We build our report with the help of following subject areas

    • Inventory- Inventory Transactions real time
    • Inventory- Inventory Balance Real time

    Report is fine however we cant see the column which we require to have the perod name as mentioned above, we checked the 'Time' folder but that folder dosent have column related to perod name. As you know we create inventory or accounting periods, exactly in the same manner we want the perod year with FY...show in the report.

    Please advice if we have to consider any other subject area or we need to modify the format of the date. Please suggest.

    For your reference I have attached the screen shot of the Perod name we created in the sytem and in the same way we need them to reflect in the report.

     

    Regards,

    Saurabh Sharma

     

    Version:
    R13- 19D
    Document:
  • Silvia Guido
    Suspended job report5.0
    Topic posted December 9, 2019 by Silvia GuidoBronze Medal: 1,250+ Points, tagged BI Publisher, Report Delivery in General OBIEE public
    Title:
    Suspended job report
    Summary:
    Suspended job report
    Content:

    Hi,

    I have a question about using a BIP job report: I have a job report that is scheduled to be sent every night if the day before some users have been registered to a learning element, like a course. Now, I want to suspend this job only for one night, in order for it to not be executed tonight even if today some learners have been registered to a learning course. My question is: if I suspend it, and then reactivate it on Wednesday, it will start to work again on thursday night, referring only to the learners that have been registered on wednesday, is it right? Or there is the risk that the notification that is not sent tonight will be sent later, when the job is reactivated?

    Thank you

    Silvia

    Version:
    19C
  • Ashish Harbhajanka
    Feasibility of having SQL Developer Connection to Oracle HCM...55.0
    Topic posted December 5, 2019 by Ashish HarbhajankaGold Crown: 30,000+ Points, tagged BI Publisher, SQL in General OBIEE public
    Title:
    Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment?
    Summary:
    Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment?
    Content:

    Hi Experts,

     

    I hope that most of you who have worked on an On-Premise system must be well versed with using SQL Developer to run/execute a query and get raw data.

     

    But in Oracle HCM Cloud or rather Oracle ERP Cloud enviornment one had to use Oracle BI Data Model or OTBI SQL Option (now not supported from 19D)

     

    So wondering won't it would be great to be able to connect to Oracle ERP Cloud database using SQL Developer. (could be a nice enhancement in product)

     

    I do heard about some paid tools developed by some organization but still not sure will individuals / orgs pay for the tool on a per user per month

    (Details about tools can be found here: https://oraclecloudtools.com/sql-connect/ )

     

    I personally feel that the tool is good but only if free , else am happy to take the pain of creating Data Model to run my SQL).

     

    What do you guys think, having a SQL developer like interface to execute queries in cloud helps and if it does shall it be paid or free (embedded within project or additional bolt on).

     

    Would love to hear both the pros and cons for it.

     

    Do let-me know your views?

     

    Kind Regards

    Ashish

    Version:
    Release 13 19D
  • Senthilrajan Vaithianathan
    ESS Print Job Queue - Oracle Fusion Cloud
    Topic posted December 5, 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, OBI Answers, OBIEE Answers, OTBI, Reports in Reporting and Analytics for ERP public
    Title:
    ESS Print Job Queue - Oracle Fusion Cloud
    Summary:
    Accessing the ESS Print Job Queue from Oracle Fusion Cloud.
    Content:

    Hi, As part of performance testing we ran Invoice Print Program for a wide range of dates, customers, etc...

    The print job is still running and it keeps printing the physical paper at the printer at our office, i have two questions.

    1. Where can we see the list of Print requests from cloud to our On-Premise printer.

    2. How can abort the pending requests on cloud as our IT Operations team has confirmed that they don't see the queue in the local printer.

  • Senthilrajan Vaithianathan
    Instance details for BI Publisher Report Template - Fusion...2
    Topic posted December 4, 2019 by Senthilrajan VaithianathanBronze Trophy: 5,000+ Points, tagged BI Cloud Connector, BI Publisher, Fusion Financial reporting, Fusion Procurement reporting, Fusion Project reporting, Fusion Supply Chain Management reporting, OBI Answers, OBIEE Answers, OTBI, Reports, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Instance details for BI Publisher Report Template - Fusion ERP/SCM
    Summary:
    Water marking Instance details on BI Publisher Report and Emailing
    Content:

    We have a requirement to display the Instance name as watermark in some of the BI Publisher report, (i.e) DEV, TEST etc... based on the instance name/URL. And also change the email/print logic based on the instance name (Prod vs Non-Prod)

    We have some details in SYS_CONTEXT, what is the best way to get this information...

     

    Version:
    19D
  • Ashish Gupta
    Generate file name at runtime in BI publisher6
    Topic posted December 4, 2019 by Ashish GuptaRed Ribbon: 250+ Points, tagged BI Publisher in Reporting and Analytics for ERP public
    Title:
    Generate file name at runtime in BI publisher
    Summary:
    Generate file name at runtime in BI publisher
    Content:

    Hi

    We have a requirement to generate the output file name with some custom name appended with timestamp in BI publisher. Please advise if this is feasible.

     

    Regards

    Ashish

    Version:
    19c