Get Involved. Join the Conversation.


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

    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

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

    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?

  • Leigh Holling
    Attachments to Purchase Order5
    Topic posted December 2, 2019 by Leigh HollingRed Ribbon: 250+ Points, tagged Orders, Public Sector, Setup 
    Attachments to Purchase Order

    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

  • Daniel Clancy
    Rolling over open purchase orders fiscal year end process2
    Topic posted November 27, 2019 by Daniel ClancyGreen Ribbon: 100+ Points, tagged How-To, Public Sector 
    Rolling over open purchase orders fiscal year end process
    Looking for a step by step guide to rolling over open purchase orders from one fiscal year into the next

    Hi, we've attempted to roll over the purchase orders, but are receiving this error message "The funds reserved on this purchase order cannot be released. Contact the procurement application administrator"

    Does procurement have to manually change the budget dates on all open POs?


  • 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 
    Requisition to PO Automation not working any longer
    Requisition was created and approved, but the PO's are no longer getting generated

    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

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

    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. 


  • 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 
    Approved requisitions not generating PO's

    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
    ,ph.segment1 AS po_number
    ,msg.context AS failed_reason_text
    ,DECODE(NVL2(prh.EMERGENCY_PO_NUMBER, 1, - 1), 1, prh.SOLDTO_LE_ID, - 1,
    ,prl.prc_bu_id AS req_line_prc_bu
    ,prh.prc_bu_id AS req_header_prc_bu
    ,ph.prc_bu_id AS po_prc_bu
    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; 

  • 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 
    Can a Punchout be configured to use a Contract Purchase Agreement?
    Can a Punchout be configured to use a Contract Purchase Agreement?

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



    R13 19A
  • 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 
    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 ?
    We have a request from our client to have Retroactive pricing under Cumulative Price break in Blanket Purchase Agreement.

    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



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

    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?