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
  • Leigh Holling
    Attachments to Purchase Order5
    Topic posted December 2, 2019 by Leigh HollingRed Ribbon: 250+ Points, tagged Orders, Public Sector, Setup 
    Title:
    Attachments to Purchase Order
    Content:

    When Purchase orders are been created on the system it is attaching any attachment that is atttached to the site of the supplier the Order is raised for.

     

    How do we disable attaching anything from Suppliers to Purchase Orders.


    Thank you

    Version:
    19C
  • Dev Thota
    BPM Worklist: How long will the Approval History store in...2
    Topic posted August 29, 2018 by Dev ThotaGold Trophy: 10,000+ Points, tagged Approvals, Approvals/Notification, Approved Supplier List, BI Publisher Reports, Business Intelligence, Public Sector, Requisition Processing, Security, Setup 
    Title:
    BPM Worklist: How long will the Approval History store in the system?
    Summary:
    BPM Worklist: How long will the Approval History store in the system?
    Content:

    BPM Worklist: How long will the Approval History store in the system?

  • William McLarty
    Can a Punchout be configured to use a Contract Purchase...Answered6
    Topic posted May 23, 2019 by William McLartyGold Medal: 3,500+ Points, tagged Agreements, Public Sector, Requisition Processing 
    Title:
    Can a Punchout be configured to use a Contract Purchase Agreement?
    Summary:
    Can a Punchout be configured to use a Contract Purchase Agreement?
    Content:

    Here is the situation.  The client is a large School District.  The board approves a contract Purchase Agreement for $3MM with Office Depot - who is a punch out partner. Ideally for each Office Depot punch out PO created it will consume the $3MM contract.  

    Has anyone tried this and been successful?  My initial thought is that we could ask Office Depot to provide the Contract PA in a field that is mapped to agreement - does this exist?

    Any thoughts or suggestions will be greatly appreciated...

    Thanks,

    Bill

    Version:
    R13 19A
  • Chetan Ullal
    Create Catalog with Items that carry Negative Pricing for...1
    Topic posted May 29, 2018 by Chetan UllalGreen Ribbon: 100+ Points, tagged Agreements, How-To, Public Sector 
    Summary:
    Create Catalog with Items that carry Negative Pricing for options
    Content:

    Hi,

    We have a business scenario where we have contracts with items that have options that have negative pricing. This allows a requester to substitute an option with a lower priced one and effectively change the price of the item to be purchased. We have tried to use the CTO Blanket Agreement to define the configuration and the options with negative prices. But we are not able to generate the requisition of this CTO BPA and select the options required. How can this scenario be acheived using Self Service Procurement and Purchasing? Below is the business case of a contract with pricing we are trying to model.

    VEH-001   TANDEM AXLE CHASSIS, Minimum 60,000 GVWR with 14' Dump Body Hydraulics,                                    $120,000

    VEH-OPT001A DEDUCT:  Fuller 13 Speed Model RTLO-12913A OR RTLO-14913A In lieu of Allison Automatic             -$7000

    VEH-OPT001B DEDUCT: manual transmission in lieu of Allison Automatic                                                                         -$6500

    VEH-OPT001C  Parts CD-ROM For Chassis and Engine                                                                                                      $300

    Chetan Ullal

  • Daniel Clancy
    Create new contract clause version - delete version?1
    Topic posted March 28, 2019 by Daniel ClancyGreen Ribbon: 100+ Points, tagged Public Sector 
    Title:
    Create new contract clause version - delete version?
    Content:

    I made an edit to the terms and conditions of my PO’s yesterday 3/27.  Edited again same day around 9 pm and didn’t realize Oracle assigns the start date to the day after your first edit.  Perhaps it’s the time difference Oracle is EST not PST.

    I processed a few PO’s; saw the terms were not updated, edited again, the start date moved, edited again, start date moved. I investigated and realized the start date was wrong.  

    I tried to edit the start date back to 3/27 on a new version.  Oracle won’t allow for that. 

    I tried to create a new version, with a newer start date, Oracle won’t allow editing start dates to before the latest start date.  

    Is there a way to get around this?

     

     

    Version:
    NetSuite
    Image:
  • Jesus Nolasco
    Delete Procurement Agent2
    Topic posted October 16, 2019 by Jesus NolascoRed Ribbon: 250+ Points, tagged How-To, Public Sector, Setup 
    Title:
    Delete Procurement Agent
    Summary:
    How can I delete procurement agent that has only been used to view Procurement information?
    Content:

    We have created a few Job Roles that include access to just view Purchase Order information. However, as we add more people to Manage Procurement Agents it looks like there is no way to delete them, only inactive them, is that the case? Or is there a way to delete them?


    We reference the attached article to create View Roles for procurement. 

     

    Version:
    19C
  • Mary King
    Edit an existing descriptive flexfield13.0
    Topic posted August 14, 2019 by Mary KingBronze Medal: 1,250+ Points, tagged Public Sector 
    Title:
    Edit an existing descriptive flexfield
    Summary:
    Change existing flexfield from global to context sensitive
    Content:

    During implementation our consultant set up all our dff's as global.  Is it possible to change some of them to context sensitive to better suit our needs and give us more segments to use?  I understand that this will affect data already stored but I would like to know if it is an option.

     

    Thank you

    Version:
    19B Cloud
  • Dev Thota
    How to write approval rules for “Outside Processing P...25.0
    Topic posted July 30, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Agreements, Approvals, Approvals/Notification, Approved Supplier List, BI Publisher Reports, Business Intelligence, Create Requisition, FAQ, Financials, Fusion, General Ledger, How-To, Manage Procurement Catalog, Notifications, Orders, OTBI, Payables, Public Sector, Requisition Processing, Security, Setup, Supplier Communication, Supply & Distribution Planning Cloud, Web Services, White Paper 
    Title:
    How to write approval rules for “Outside Processing Purchase Order” through BPM?
    Summary:
    How to write approval rules for “Outside Processing Purchase Order” through BPM?
    Content:

    Hi all,

    When we are releasing the work order our requisitions are auto approving and POs are getting created automatically. As per the Oracle, we can't control the approvals of PR so we want to enable the approval flow for the purchase orders(OSP orders). If anyone has any idea on how to create a BPM rule for these kinds of POs please let me know.

    Version:
    19B
  • Ramesh Radhakrishnan
    Inactivate Supplier Site - Implications on Open PO/ InvoicesAnswered4
    Topic posted February 15, 2019 by Ramesh RadhakrishnanBlack Diamond: 60,000+ Points, tagged Orders, Payables, Public Sector, Setup 
    Title:
    Inactivate Supplier Site - Implications on Open PO/ Invoices
    Content:

    Inactivate Supplier Site - Implications on Open PO/ Invoices

    Need to know what will be the implications when Supplier site is inactivated.

    1. What will happen to the open PO's and Invoices that are in process?

    2. Will system allow to inactivate sites when there are open PO's and Invoices? is there an validation by the system?

    3. Will allow to create a new invoice with the inactivated supplier site that is on PO?

    Thanks

    Ramesh

    Version:
    R13-18C