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

  • 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

  • Sathya Kannan
    Procurement - Procure to Pay Real TimeAnswered5
    Topic posted October 16, 2019 by Sathya KannanBlue Ribbon: 750+ Points, tagged Business Intelligence, Create Requisition, How-To, Orders, OTBI, Payables, Requisition Processing, Setup, White Paper 
    Title:
    Procurement - Procure to Pay Real Time
    Summary:
    Procurement - Procure to Pay Real Time not displaying the Receipt Numbers created against the POs
    Content:

    Hi,

    We would like to create an OTBI report using the Procurement - Procure to Pay Real Time analysis, but the receipt number (available under Invoice column) created for the Purchase orders is not displayed.

    Does anyone know the solution for this?

     

    Regards,

    Sathya Kannan

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

  • 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
  • Sabarish Ganda
    How to Reassign or add two approvers at a time for a BIP...Answered45.0
    Topic posted April 16, 2019 by Sabarish GandaGold Medal: 3,500+ Points, tagged Approvals, Approvals/Notification, Business Intelligence, FAQ, Fusion, How-To, Notifications, Setup 
    Title:
    How to Reassign or add two approvers at a time for a BIP Approvals
    Content:

    Recently, we updated our Purchase Order Approvals and Requisition Approvals from ADF to BIP notifications. 

    In older approval notifications we use to have a option for AdHoc add participant, where we can have series of Approvers.

    But with the update, I dont see Adhoc Option and I dont see any option to add two approvers in Serial.

    Please check the attached image.

    Version:
    Oracle Fusion R13
    Image:
  • 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 
    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?

  • Deepak Padhy
    Query to See the Approver Name on Whom a PO is Pending For...45.0
    Topic posted August 24, 2018 by Deepak PadhySilver Medal: 2,000+ Points, tagged Approvals, BI Publisher Reports, Business Intelligence, How-To, Notifications 
    Title:
    Query to See the Approver Name on Whom a PO is Pending For Approval
    Summary:
    Query to See the Approver Name on Whom a PO is Pending For Approval
    Content:

    Most of the time we get an SR with requirement to see or extract on which approval level a PO is pending currently for approval. And customer wants a Query for this. Below is the Query we have prepared which will give on whom the PO is currently pending for approval. You can prepare an OTBI report to get the extract of all open POs and you can modify the query as per what column you need.

     

    SELECT poh.segment1
    ,approval_instance_id, assignees, wf.outcome, wf.state ,wf.workflowpattern, wf.title, wf.componentname, wf.compositename, pov.change_order_status
    FROM
    fusion.po_versions pov, fusion.po_headers_all poh  , fa_fusion_soainfra.wftask wf
    WHERE pov.po_header_id = poh.po_header_id
    and pov.change_order_status = 'PENDING APPROVAL'
    and pov.approval_instance_id=wf.compositeinstanceid
    and poh.segment1=  '1004752' -- PO Number
    and state='ASSIGNED'
    and assignees is not null
    and workflowpattern not in ('AGGREGATION', 'FYI')
    and componentname='DocumentApproval'

     

    Thanks

    Deepak.

  • Boyuan Zhu
    Updated Navigate to Purchasing Transactions from Reports...35.0
    Topic posted May 31, 2019 by Boyuan ZhuGold Medal: 3,500+ Points, tagged BI Publisher Reports, Business Intelligence, How-To, White Paper 
    Title:
    Updated Navigate to Purchasing Transactions from Reports Whitepaper
    Content:

    You can construct and include links to purchasing documents in your reports using the Navigate to Purchasing Transactions from Reports feature. The whitepaper for the feature has been updated with new instructions on how to add links to Oracle Fusion Transactional Business Intelligence reports. 

    Please find the whitepaper on My Oracle Support: Navigate to Purchasing Transactions from Reports (note 2444555.1).