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.
  • Phil Nibert
    Need an OTBI report/ field that shows PO AP Accrual Account5.0
    Topic posted December 6, 2019 by Phil NibertRed Ribbon: 250+ Points, tagged Business Intelligence, Financials, OTBI, Payables in Procurement > Purchasing public
    Title:
    Need an OTBI report/ field that shows PO AP Accrual Account
    Summary:
    Need an OTBI report/ field that shows PO AP Accrual Account
    Content:

    Hi would like to see if any of the OTBI subject areas for Procurement have a field that shows the PO AP liability account for the Purchase Order.  I can find OTBI fields in the Procurement - Procure to Pay Real Time and Procurement - Purchasing Real Time OTBI subject areas for the PO charge account but not the PO liability account.

    Version:
    Oracle Cloud Financials 19C
  • 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
  • Stephanie Golly
    Risk Managment Global Conditions Report
    Topic posted December 4, 2019 by Stephanie GollyGreen Ribbon: 100+ Points, tagged OTBI, Sample Reports in Reporting and Analytics for ERP public
    Title:
    Risk Managment Global Conditions Report
    Summary:
    A listing of global conditions including the filter definitions.
    Content:
    1. Download the zip file attached to this post
    2. Unzip and you'll find a catalog file and pdf example of the report output
    3. Within the BI Catalog, locate the folder where you want to locate the content, e.g. Shared Folders>Custom
    4. Unarchive the catalog file and you will see the new content
    Version:
    R13 19C
    Image:
  • Vitor Lima
    OTBI how to list repeated values3
    Topic posted December 4, 2019 by Vitor Lima, tagged Business Intelligence, Order Management, OTBI, SCM, SQL in Reporting and Analytics for SCM public
    Title:
    OTBI how to list repeated values
    Summary:
    how to use list component to repeat values
    Content:

    Hello, I've created a customized report in OTBI and it i'm using the list component to present the data retrieved from the data model but, the list component is only presenting unique values within the results... much like a "Select Distinct" and for this particular report i need it to show all values regardless if they are repeating or not...

    Thanks a bunch,

    Vitor

     

    in the picture attached the report should show another number 2 in the fourth column 

    Image:
  • Mahgoub Salaheldien
    GlTrialBalanceReport is not work2
    Topic posted December 2, 2019 by Mahgoub SalaheldienBronze Medal: 1,250+ Points, tagged BI Publisher, OTBI in Reporting and Analytics for ERP public
    Title:
    GlTrialBalanceReport is not work
    Summary:
    Standard report General ledger trial balance report giv error file
    Content:

    Hi

    when start run General ledger trial balance report from schadenfreude process error log is showing

    see in attached file .

    please advice

    Thanks

    Mahgoub

    Document:
    770129.log (713 Bytes)
  • Sian Summers
    Custom BI Webcat Reporting Duty5
    Topic posted November 29, 2019 by Sian SummersRed Ribbon: 250+ Points, tagged Fusion, OTBI, Public Sector, Report Delivery, Reports, Setup, Setup/Administration, Tip in General OBIEE public
    Title:
    Custom BI Webcat Reporting Duty
    Summary:
    Trying to hide seeded reporting folders and understand the updated options within 19D
    Content:

    We are keen to have the option to hide seeded folders from users. Changing permissions on seeded report folders comes up with the following error:

    "In-place customizations are not allowed on factory delivered content. Save your customizations in /shared/custom"

    ***

    We were really pleased therefore to see the following release notes for 19D:

    https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/common/releases/19D/19D-common-wn.htm#F10098

    However, I am trying to understand how it works. Has anyone used these roles yet?

    The BI Consumer role still has traverse permissions to these seeded folders, therefore struggling to understand how assigning another role counters this. 

    Also - the Custom BI Webcat Reporting Duty, which is the Duty Role that it is advised we edit put into a role and assign, is unable to be copied. Is this what people would expect?

    If anyone can give any further detail on how this works, it would be much appreciate. Keen to lock down some of these seeded reporting folders.

    Kind regards,

    Sian.

     

     

    Version:
    19D
  • Janko Jovicic
    ORA-03113: end-of-file on communication channel error -...15.0
    Topic posted November 28, 2019 by Janko JovicicBlue Ribbon: 750+ 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