Purchasing

Get Involved. Join the Conversation.

Posts

  • 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 
    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 
    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 
    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

  • Nishanth B Jain
    Purchase Order PDF report64.0
    Topic posted September 22, 2018 by Nishanth B JainSilver Crown: 22,500+ Points, tagged Agreements, BI Publisher Reports, Orders, Setup 
    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 
    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

  • Sachin Mistry
    R13 UPGRADE - After R13 upgrade Ship to Address is not...55.0
    Topic posted September 5, 2018 by Sachin MistryGold Medal: 3,500+ Points, tagged Agreements, BI Publisher Reports, Business Intelligence 
    Title:
    R13 UPGRADE - After R13 upgrade Ship to Address is not printing on PO PDF Template
    Summary:
    R13 UPGRADE - After R13 upgrade Ship to Address is not printing on PO PDF Template
    Content:

    Curious if you have run into this issue. Our PO pdf template is no longer printing ship to address. We have logged SR however if anyone has run into similar issue and found a resolution. We will appreciate your feedback.

  • Balakrishna Chaturvedula
    Audit Report for Purchase Order ApprovalsAnswered5
    Topic posted December 16, 2017 by Balakrishna ChaturvedulaBronze Trophy: 5,000+ Points, tagged Approvals, BI Publisher Reports, How-To, Orders 
    Title:
    Audit Report for Purchase Order Approvals
    Summary:
    We are looking for a report which would show approval history for purchase orders
    Content:

    Hi All,

    We have built approval rules which span 2 to 10 levels. As part of audit, we need a report that would display approvers for every purchase order. I am looking for a standard report or a subject area which would fetch such details. Appreciate any pointers / suggestions. Thanks.

    Regards, Bala.

  • Piyush Bihany
    Access to Procurement/Purchasing Subject Area & Purchasing...45.0
    Topic posted July 30, 2019 by Piyush BihanyGold Medal: 3,500+ Points, tagged BI Publisher Reports, Fusion, How-To, Orders, OTBI 
    Title:
    Access to Procurement/Purchasing Subject Area & Purchasing Related Reports
    Summary:
    User without Buyer role are unable to Access Procurement Subject Area and Procurement Related Reports, Also they are unable to Create New Analysis
    Content:

    Client is live with Oracle Purchasing cloud and users have been creating PO on the Prod Instance.

    However there are few users who doesn't have the Buyer License (Buyer Role is not assigned) and don't have access to create and manage Purchase Order but still wants to review (view only access) for the Purchase order Data via Reports. 
     

    Client has additionally procured license for B84576 - Oracle Fusion Transactional Business Intelligence Cloud Service - Hosted Name, with an understanding that this will grant access to the users for BI Reports. 

    We have created a custom BI Role, and have added the following Privileges to the same: 
    BI Consumer Role 
    And have assigned the custom role to above listed users. 

    These users are unable to create a New Analysis (OTBI report) under the BI Page.

     
    Also for any existing OTBI Report, when the open the same, they are getting error as: 
    No Results 
    The specified criteria didn't result in any data. 

    However the same report is fetch data for other users, who are having Buyer role assigned. 

    Please advice, if in addition to creation of Custom Role for Oracle Fusion Transactional Business Intelligence Cloud Service, any other steps needs to be performed. 

    --

    PB

    Image:
  • Jim Van Tongerloo
    PO PDF in Language of SupplierAnswered45.0
    Topic posted July 26, 2019 by Jim Van TongerlooGold Trophy: 10,000+ Points, tagged BI Publisher Reports, Business Intelligence, Fusion, Orders 
    Title:
    PO PDF in Language of Supplier
    Summary:
    PO PDF in Language of Supplier
    Content:

    Hi,

    I'm looking for the functionality to have the PO PDF print depending on the Supplier (address) language.

    Currently I've made a default template in French under the locale 'English', a template in Dutch under locale 'Dutch' and a template in French under the locale 'French'.

    The Supplier address language is Dutch.

    When viewing the PDF on a PO for this supplier, it keeps taking a French version, because the user preference language is in French?

    Is it not supported to have PO PDF based on Supplier language?

    Thanks.

    Version:
    R13 19B
  • chetan kumar
    Purchase order approval email notification includes taxs...4
    Topic posted July 24, 2019 by chetan kumarBronze Medal: 1,250+ Points, tagged Approvals, Approvals/Notification, BI Publisher Reports, How-To, Notifications, Orders 
    Title:
    Purchase order approval email notification includes taxs amount in headers amount
    Summary:
    Purchase order approval email notification includes taxs amount in headers amount
    Content:

    Purchase Order approval email notification has header order amount with the tax amount, Earlier before Upgrade 19B the notification use to include only Ordered amount excluding Tax amount, Could any one help on this.

    Kindly let me in case of any Information required.

    Image: