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.
  • OSC User
    how to customize buyers negotiation PDF?Answered19
    Topic posted July 21, 2019 by OSC UserRed Ribbon: 250+ Points, tagged BI Publisher Reports, Customization, How-To, Negotiation Creation, Negotiation Management, Procurement Contracts, Setup in Procurement > Sourcing public
    Title:
    how to customize buyers negotiation PDF?
    Summary:
    customize contracts section of Buyers negotiation PDF
    Content:

    Hi,

    i am new to Fusion customizations and would like to customize Buyers negotiation PDF.

    I have downloaded template 'NegotiationPDFGenerateReport.rtf' but not finding contract section there.Maybe i need to customize 'ContractTermsPlusAmendmendsProcurement' rtf. where can i find it?

    Any help greately appreciated

    Regards,

     

     

     

    Version:
    19B (11.13.19.04.0)
  • Amar
    Unable to select Data Source from Data Model85.0
    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.?

     

     

  • Annette Massie
    Approved requisitions not generating PO'sAnswered8
    Topic posted July 26, 2019 by Annette MassieRed Ribbon: 250+ Points, tagged BI Publisher Reports, Business Intelligence, Public Sector in Procurement > Purchasing public
    Title:
    Approved requisitions not generating PO's
    Content:

    We are finding that some of our requisitions are still in process status because it requires a negotiation to turn into a PO. Oracle support supplied a sql query to create a BI report, however I can't seem to make it work. Has anyone created an analysis to help with this that they would be willing to share? The query that was supplied looked like this:

    SELECT prh.requisition_number
    ,prl.line_number
    ,prl.line_status
    ,prl.req_po_instance_id
    ,prl.reqs_in_pool_flag
    ,ph.segment1 AS po_number
    ,prh.emergency_po_number
    ,prl.reqtopo_automation_failed
    ,prl.reqtopo_auto_failed_reason
    ,msg.context AS failed_reason_text
    ,DECODE(NVL2(prh.EMERGENCY_PO_NUMBER, 1, - 1), 1, prh.SOLDTO_LE_ID, - 1,
    NULL) AS SOLDTO_LE_ID
    ,prh.pcard_id
    ,prl.line_type_id
    ,prl.pcard_flag
    ,prl.requisition_header_id
    ,prl.requisition_line_id
    ,prl.prc_bu_id AS req_line_prc_bu
    ,prh.prc_bu_id AS req_header_prc_bu
    ,prl.req_bu_id
    ,prl.assigned_buyer_id
    ,prl.negotiated_by_preparer_flag
    ,prl.negotiation_required_flag
    ,prl.source_document_type
    ,prl.source_doc_header_id
    ,prl.vendor_id
    ,prl.vendor_site_id
    ,prl.line_location_id
    ,prl.item_id
    ,prl.category_id
    ,prl.amount
    ,prl.quantity
    ,prl.unit_price
    ,ph.document_creation_method
    ,ph.prc_bu_id AS po_prc_bu
    ,ph.document_status
    ,ph.po_header_id
    FROM po_headers_all ph
    ,po_lines_draft_all pl
    ,por_requisition_lines_all prl
    ,por_requisition_headers_all prh
    ,fnd_messages_b msg
    WHERE ph.po_header_id(+) = pl.po_header_id
    AND prl.po_line_id = pl.po_line_id(+)
    AND prl.requisition_header_id = prh.requisition_header_id
    AND prh.requisition_number IN ('RQ17135')
    AND prl.reqtopo_auto_failed_reason = msg.message_name(+)
    ORDER BY prl.requisition_header_id, prl.line_number; 

    Version:
    19B
  • Max Basandrai
    PO Email Sent to Supplier85.0
    Topic posted January 30, 2019 by Max BasandraiBlue Ribbon: 750+ Points, tagged BI Publisher Reports, Fusion, How-To, Notifications, Orders in Procurement > Purchasing public
    Title:
    PO Email Sent to Supplier
    Summary:
    PO Email Sent to Supplier
    Content:

    How can we add some test to the PO Email that is automatically sent to suppliers.

    Also how do we prevent it being in a zip format but in PDF instead.

    Version:
    R13 19A
  • 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

  • OSC User
    Print DFFs on buyers PDF6
    Topic posted July 28, 2019 by OSC UserRed Ribbon: 250+ Points, tagged BI Publisher Reports, Customization, Negotiation Creation, Negotiation Management in Procurement > Sourcing public
    Title:
    Print DFFs on buyers PDF
    Summary:
    Printing descriptive flex fields on buyers PDF
    Content:

    Hi,

    We would like to print DFFs on the cluses part of the byuers PDF.

    Is it possible?

  • Nishanth B Jain
    Purchase Order PDF report64.0
    Topic posted September 22, 2018 by Nishanth B JainBronze Crown: 15,000+ Points, tagged Agreements, BI Publisher Reports, Orders, Setup in Procurement > Purchasing public
    Title:
    Purchase Order PDF report
    Summary:
    Auto genarated page number
    Content:

    Hello People,

    We are facing issue with PO PDF/ BPA PDF templates, where we are getting page numbers at bottom footer.

    We already have page number @ the top right of the page, but internally in application PO PDF is getting page numbering @ bottom right of the footer.

    We found BUG ID for this Bug 18472064.

    Any alternative solution for this to avoid page numbering?

    Thanks,

    NJ

    Version:
    RE 13.18.02
  • Varshinee Veerasamy
    PO Amount is empty65.0
    Topic posted May 24, 2018 by Varshinee Veerasamy, tagged BI Publisher Reports, Business Intelligence, How-To in Procurement > Purchasing public
    Title:
    PO Amount is empty
    Summary:
    PO Amount is empty in my Procurement Analytics
    Content:

    Hi,

    I am a business user of the "Purchasing module" and OTBI

    I have noticed that the PO amount is empty. Grateful if someone  can help me on this.

    I am fairly new to OBI and trying to find my way.

    Many thanks,

    Varshinee

  • Muhammad Bilal
    PO Received and Remaining Quantity report55.0
    Topic posted June 27, 2019 by Muhammad BilalBronze Medal: 1,250+ Points, tagged BI Publisher Reports, Business Intelligence in Inventory and Logistics > Inventory public
    Title:
    PO Received and Remaining Quantity report
    Summary:
    Is there any standard report for PO Received and Remaining Quantity report
    Content:

    Looking for Purchasing PO PO Received and Remaining Quantity report 

    Version:
    19B