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
  • 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
  • Ujas Bhatt
    Number of record (data) limit in FBDI v/s ADFDi105.0
    Topic posted May 16, 2019 by Ujas BhattSilver Trophy: 7,500+ Points, tagged Financials, Fusion, Manage Procurement Catalog, Public Sector, Tip, White Paper 
    Title:
    Number of record (data) limit in FBDI v/s ADFDi
    Summary:
    Is there a predefined limit for number of records that can go to system while we upload data using FBDI or ADFDi ?
    Content:

    Hi Experts,

    This questions is precisely from Procurement and Finance FBDI  and ADDFi prospective.

    Is there a predefined limit for number of records (data) that we can use in FBDI and ADFDi while we upload the data using spreadsheet?  If yes, do we have any standard oracle document around this indicates this information?

    Also, is there a setup hosted by Oracle that we can increase or decrease this limit ?

    Appreciate your help !!!

    Regards,

    Ujas

  • Harshith E S
    Need the concept/logic behind why Retroactive pricing is...1
    Topic posted March 29, 2019 by Harshith E SRed Ribbon: 250+ 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, Payables, Public Sector, Requisition Processing, Security, Setup, Supplier Communication, Supply & Distribution Planning Cloud, Tip, Web Services, White Paper 
    Title:
    Need the concept/logic behind why Retroactive pricing is viable only with Non-Cumulative Price Break and not with Cumulative Price Break in BPA on Procurement Cloud ?
    Summary:
    We have a request from our client to have Retroactive pricing under Cumulative Price break in Blanket Purchase Agreement.
    Content:

    Hi all,

    Based on my research,

    For a retroactive pricing to reflect, it is suggested to choose price break type as Non-Cumulative.

    Need to understand the relation between Price Break and Retroactive Pricing, an explanation with a Business example would help.

    Please refer this document ID in My Oracle Support - (Doc ID 2259539.1) 

    Thank you,

    Harshith E S

     

     

    Version:
    19A (11.13.19.01.0)
  • 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:
  • 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
  • Daniel Clancy
    NIGP category code map set and Amazon15.0
    Topic posted February 12, 2019 by Daniel ClancyGreen Ribbon: 100+ Points, tagged How-To, Manage Procurement Catalog, Public Sector 
    Title:
    NIGP category code map set and Amazon
    Summary:
    Amazon product codes conversion to NIGP
    Content:

    I'm setting up punch-out capability for Amazon for our City.   Issue is we use NIGP category codes and Amazon used UNSPC.

    Has anyone run into how to set up Amazon and converting the category codes?

     

  • Daniel Clancy
    Non-Catalog Requisition with no reference to a Contract...25.0
    Topic posted February 1, 2019 by Daniel ClancyGreen Ribbon: 100+ Points, tagged Agreements, Create Requisition, Orders, Public Sector, Requisition Processing 
    Title:
    Non-Catalog Requisition with no reference to a Contract Purchase Agreement
    Summary:
    CPA is being auto-filled without entering the Agreement in the Source Agreement field
    Content:

    Hi.  I discovered an issue involving a Contract Purchase Agreement I have set up.  The CPA is for one department in our City. (Parks).  For one supplier.  Different departments also use the supplier and need purchase orders, but not tied to the CPA.

    What I'm seeing now is any requisition that comes through it automatically tied to the CPA, somehow Oracle is assigning the CPA Agreement.  Is it because I have "enable automatic sourcing"?

     

  • Ramesh Radhakrishnan
    January Maintenance Pack for Fusion Applications 18C and a...Answered45.0
    Topic posted January 8, 2019 by Ramesh RadhakrishnanBlack Diamond: 60,000+ Points, tagged Orders, Public Sector 
    Title:
    January Maintenance Pack for Fusion Applications 18C and a Fix for tax issue for purchase order
    Content:

    We had  January Maintenance Pack for Fusion Applications 18C and a Fix for tax issue for purchase order and we need to know the details of the fix. I refered to the doc Oracle Procurement Cloud, Release 13 (update 18C), January Maintenance Pack (Doc ID 2483644.1)

    and this doc did not mention any details on the tax issue for PO. Any insights on the fix?

     

     

    Version:
    R13-18C
  • Atul Kumar
    Purchasing: Create Order Page Customization25.0
    Topic posted October 30, 2018 by Atul KumarBronze Medal: 1,250+ Points, tagged Approvals, Approvals/Notification, Approved Supplier List, BI Publisher Reports, FAQ, Fusion, How-To, Notifications, Orders, Public Sector, Requisition Processing, Security, Setup, Supplier Communication, Supply & Distribution Planning Cloud, Tip, Web Services, White Paper 
    Title:
    Purchasing: Create Order Page Customization
    Summary:
    Create Order Page Customization
    Content:

    We have a requirement to customize below 2 fields on Create Order pop up Page(attached screen shot): 

    1. Supplier Contact - Want to hide this field on Create Order page 
    2. Default Ship-to Location - Want to make it mandatory on Create Order Page 

    How to solve?