Posts

Posts

  • 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.
  • Nidhi Chhajed
    Supplier Registration or Profile Change Approval Details
    Topic posted Yesterday by Nidhi ChhajedBlue Ribbon: 750+ Points, tagged BI Publisher Reports in Reporting and Analytics for SCM public
    Title:
    Supplier Registration or Profile Change Approval Details
    Content:

    Hi ,

    I want to prepare a SQL which will have supplier and approver details.

    I know we have below workflow and supplier tables:

    fa_fusion_soainfra.wftask

    fa_fusion_soainfra.wftaskhistory

    POZ_SUPPLIER_REGISTRATIONS

    POZ_SUPPLIERS

    But I am struggling to find correct details.

    Can someone please help me here.

    Regards

    Nidhi...

  • Koteswararao Yenikepalli
    How to print the amount in words in the etext template
    Topic posted September 17, 2019 by Koteswararao YenikepalliBronze Medal: 1,250+ Points, tagged BI Publisher, BI Publisher Reports, BICS, Business Intelligence, Dashboards, OTBI, SQL, Supply Chain Planning, Tip, Upgrades, White Paper in Reporting and Analytics for SCM public
    Title:
    How to print the amount in words in the etext template
    Summary:
    How to print the amount in words in the etext template
    Content:

    How to print the amount in words in the etext template 

    we have used the below syntax  in the etext template 

    <?xdofx:to_check_number(12345.67, 'EUR', 'CASE_LOWER', 'DECIMAL_STYLE_WORDS')?>

     

    But it is not giving the expected output and at this moment we have the only XML we cont have the data model access for this

     

    Please suggest the possible ways to achieve this requirement

     

    Thank You.

    Version:
    19C
  • Koteswararao Yenikepalli
    Is it possible to send two attachments in single bursting?3
    Topic posted September 14, 2019 by Koteswararao YenikepalliBronze Medal: 1,250+ Points, tagged BI Publisher, BI Publisher Reports, Business Intelligence, Report Scheduling, Reporting and Analytics, SQL, Tip, White Paper in Reporting and Analytics for SCM public
    Title:
    Is it possible to send two attachments in single bursting?
    Summary:
    Is it possible to send two attachments in single bursting?
    Content:

    We had a requirement to send same output with two different formats (Ex: Excel and PDF). we need to send two different formats in single email not different emails..

     

    Please suggest, is there any possibility to achieve it.

    Version:
    19C
  • Harshal Agrawal
    Reports needed as per the customer language4
    Topic posted September 10, 2019 by Harshal Agrawal, tagged BI Publisher Reports, OTBI in Reporting and Analytics for SCM public
    Title:
    Reports needed as per the customer language
    Summary:
    Manual reports need to be generated in customer language
    Content:

    Hi All,

    We are facing requirement from customer side that they want reports need to be generated in there language.
    For eg : We are creating custom reports in English language, but some of the customer are using swedish language so we need report in Swedish language for Swedish customer, and other reports in there language.
    So how and what setups are needed to achieve this ?

    Thanks,
    Harshal

  • Amar
    Unable to select Data Source from Data Model8
    Topic posted September 13, 2019 by AmarBlue Ribbon: 750+ Points, tagged BI Publisher, BI Publisher Reports, Business Intelligence, White Paper in Reporting and Analytics for SCM public
    Title:
    Unable to select Data Source from Data Model
    Summary:
    Unable to select Data Source from Data Model
    Content:

    All --> I am facing issue with OTM BIP cloud Catalog.

    Issue: Not able to choose/select Data source from Data Model.Is this due to Role?

    Also can anyone provide Shipment Manifest tables.?

     

     

  • Harshith Eshwar Shaila
    How Purchasing Module interacts with other Oracle modules.25.0
    Topic last edited September 4, 2019 by Harshith Eshwar ShailaBlue Ribbon: 750+ Points, tagged Agreements, Approvals, BI Publisher Reports, Business Intelligence, Create Requisition, Financials, General Ledger, Orders, Payables, Requisition Processing, Setup, Tip, Web Services, White Paper in Procurement > Purchasing public
    Title:
    How Purchasing Module interacts with other Oracle modules.
    Content:

    Hi all, 

    Is there any Doc IDs/Link/ whitepapers or any other Detailed Documentation on understanding how Purchasing Module interacts with other Oracle modules in Procurement, SCM, Financials..etc, from data flow perspective.

    Regards,

    Harshith E S

  • Renan Robles
    Need a Purchase Order Revision History Report45.0
    Topic posted March 12, 2019 by Renan RoblesBronze Medal: 1,250+ Points, tagged BI Publisher Reports, Business Intelligence, Orders in Procurement > Purchasing public
    Title:
    Need a Purchase Order Revision History Report
    Summary:
    We need to see amounts changed in our purchase orders
    Content:

    We cannot find a report that shows details of change order amounts. We would like to see the details found on the PO when you go to Revision History. Here you can see amount changed, date, initiator and more. I would even like to see cost center and more details if possible. I believe there should be a standard report showing Revision History. Change History could also work. Can anyone help?

  • OSC User
    changing the print order in Buyers PDF3
    Topic posted August 2, 2019 by OSC UserRed Ribbon: 250+ Points, tagged BI Publisher Reports, Customization, FAQ, How-To, OTBI, Sourcing Programs in Procurement > Sourcing public
    Title:
    changing the print order in Buyers PDF
    Summary:
    is it possible to change print order contents on buyers pdf
    Content:

    Hi,

    When we print pdf now, it prints in following order

    overview

    cover page

    requirements

    lines

    contract terms

    suppliers

    Is it possible to print contract terms, right after cover page?

     

  • chetan kumar
    Receipt Number field blank on OTBI report from Procure to...Answered7
    Topic posted March 25, 2019 by chetan kumarBronze Medal: 1,250+ Points, tagged BI Publisher Reports, Business Intelligence, Security in Procurement > Purchasing public
    Title:
    Receipt Number field blank on OTBI report from Procure to Pay Subject Area
    Summary:
    Receipt Number field blank on OTBI report from Procure to Pay Subject Area
    Content:

    Hi All,

    we built a OTBI report based on "Procure to Pay" subject area, receipt number field is blank,Could anyone check what would be the reason.

    Regards,

    Chetan