Purchasing

Get Involved. Join the Conversation.

Posts

  • Anand Kand
    Requisition to PO Automation not working any longerAnswered20
    Topic posted November 5, 2019 by Anand KandRed Ribbon: 250+ Points, tagged Public Sector, Requisition Processing 
    Title:
    Requisition to PO Automation not working any longer
    Summary:
    Requisition was created and approved, but the PO's are no longer getting generated
    Content:

    When we created the requisitions with the 'Negotiated' box checked, backed by Buyer Assignment Rules for the category, the PO was automatically generated till we had the 19C. We are not able to see this happen automatically since the last day or so.

    The requisition is picking up the buyer name correctly, but not progressing to the Purchase Order. Upon navigating to the 'Process Requisitions' task, the Requisition is not available for processing into the PO, nor do we see any incomplete PO's created for the requisition in question.

    I ran the diagnostic for the Touchless PO Creation, and see the following:

    "Prc_bu_id is stamped and item_source is not req_import or req_service. So this reqline should have been eligible for Touchless PO Creation."

    There are no error codes showin in the 'Req to PO Automation Failed" column.

    I then ran the 'Requisition Not Present in Process Requisitions' diagnostic, hoping to create the PO manually, but I do not see any requisition to process there either.

    "reqs_in_pool_flag is N. Req to PO automation did not start for this reqLine"

    We therefore cannot process these approved requisitions to PO's.

    Any thoughts would be greatly appreciated.

    Kindest Regards

     

    Anand Kand
     

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

  • 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
  • Dev Thota
    Where can we set po accural account default85.0
    Topic posted October 12, 2018 by Dev ThotaGold Trophy: 10,000+ Points, tagged Approvals, Approvals/Notification, Create Requisition, FAQ, How-To, Manage Procurement Catalog, Public Sector, Requisition Processing, Setup, Tip, White Paper 
    Title:
    Where can we set po accural account default
    Summary:
    Where can we set po accural account default
    Content:
    Where can we set po accural account default
    Version:
    R13
  • 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
  • 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
  • Dawn Cawston
    Isolate location to Procurement so not used in HCM55.0
    Topic posted August 14, 2019 by Dawn CawstonBronze Medal: 1,250+ Points, tagged Financials, Public Sector 
    Title:
    Isolate location to Procurement so not used in HCM
    Summary:
    Does anyone know how to do the above
    Content:

    We have persons who work in a location that requires delivery but it is not their official work location.

    Does anyone know how to isolate a location so that it can only be used by procurement and is not selectable by HCM?

    Version:
    19B
  • Ramesh Radhakrishnan
    Purchasing documents - ADA Compliance4
    Topic posted December 3, 2019 by Ramesh RadhakrishnanBlack Diamond: 60,000+ Points, tagged FAQ, Public Sector 
    Title:
    Purchasing documents - ADA Compliance
    Summary:
    Purchasing documents - ADA Compliance
    Content:

    We have a public sector client that has a requirement where all the purchasing documents generated out of the Oracle cloud purchasing modules - PO PDF reports are ADA  compliant  (Americans with Disabilities Act (ADA) Standards for Accessible Design).

    Any insights if it is ADA compliant?

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