Purchasing

Get Involved. Join the Conversation.

Posts

  • Alan Rowland
    19B Procurement Known Issues55.0
    Topic posted May 20, 2019 by Alan RowlandBronze Trophy: 5,000+ Points, tagged Approvals, Requisition Processing 
    Title:
    19B Procurement Known Issues
    Summary:
    Updated 5/17/19 - PRC:19B Procurement Known Issues (Doc ID 2542766.1)
    Content:

    Just saw this.  We had the patch applied this weekend.

    PRC:19B Procurement Known Issues

    Oracle Procurement Cloud 19B May Maintenance Pack (Doc ID 2531572.1)

    Oracle Fusion Self-Service Procurement Cloud Service

    PRC:SSP:19B- No Longer Have The Ability To Ad Hoc Route To Chain Of Single Approvers (Doc ID 2542344.1)

    19B Punchout Supplier, An Error Occurred In Communicating To The Punchout Site Defined In The Catalog Punchout (Doc ID 2543606.1)

    Navigational Change In Punchout, Click On Supplier Logo/Link And Taken To Shop By Category (Doc ID 2543641.1)

    Oracle Fusion Purchasing Cloud Service

    Note Autocreated PO Has Incorrect Charge Account (Doc ID 2541590.1)

    Oracle Fusion Sourcing Cloud Service

    None Currently will add if we have any known issues

    Oracle Fusion Supplier Model Cloud Service

    None Currently will add if we have any known issues

     

     

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

  • Rain Tsui
    How to enable requested delivery date validation against...45.0
    Topic posted March 28, 2019 by Rain TsuiRed Ribbon: 250+ Points, tagged Agreements, Approvals, How-To, Orders 
    Title:
    How to enable requested delivery date validation against agreement's effective dates
    Content:

    Business Case

    You want to enforce the agreement's start/end dates for any purchases made against those agreements.

    Solution

    You can use the profile option "PO_REQUESTED_DELIVERY_DATE_VALIDATION" to validate that the requested delivery date is within the source agreement's effective dates. This applies to both contract purchase agreements (CPA) and blanket purchase agreements (BPA).

    With this option enabled, you can prevent submission of POs whose requested delivery date falls outside the agreement's start and end date. 

    Example

    You have created the  following agreements for the same supplier, item, and UOM:

    Agreement Number
    Start Date
    End Date
    123 01-JAN-2019 30-JUN-2019
    456 01-JUL-2019 31-DEC-2019

    A PO with requested delivery date of 01-AUG-2019 will fail submission validation if agreement 123 is referenced, regardless of the profile option setting.

    A PO with requested delivery date of 01-MAY-2019 will fail submission validation if agreement  456 is referenced and the profile option is enabled, but will pass submission validation if the option is disabled. 

    How to set up

    You can go to Manage Purchasing Profile Options and search by PO_REQUESTED_DELIVERY_DATE_VALIDATION.

    Screen%20Shot%202019-03-18%20at%202.32.51%20PM.png?version=1&modificationDate=1552944882000&api=v2

     
  • Mohammad Arif Zaffar
    Approval Rules enhancements54.8
    Topic posted July 14, 2019 by Mohammad Arif ZaffarBronze Medal: 1,250+ Points, tagged Approvals, Approvals/Notification 
    Title:
    Approval Rules enhancements
    Summary:
    Approval Rules enhancements
    Content:

    Hello, 

    I am looking for an intelligent solution which should minimize the number of approval rules for PO. We have around 4000 approval rules based on a very complex 'Delegation of Authority'. 

    Scenario:

    There is one condition 'material type', for example which contains 5 values  say A, B, C, D, E

    when it is ' A' it should go to for approval to  'Person AA'

    'B' it should go to for approval to  'Person BB'

    'C' it should go to for approval to  'Person CC'

    'D' it should go to for approval to  'Person DD'

    'E' it should go to for approval to  'Person EE'

    We have 5 amounts slabs   >1M   >5M   >10M    > 15M   >above 15M    

    so techincally I have to create   5*5=25 approval rules 

     

    Correct me if I am wrong but I believe cloud Saas does not support dynamic approval group which could be useful as per my scenario. 

    Looking forward for any out of the box solution. 

    Thanks

     

  • Thu Truong
    Error in approval using Position Hierarchy44.5
    Topic posted August 15, 2019 by Thu TruongRed Ribbon: 250+ Points, tagged Approvals, Approvals/Notification, Setup 
    Title:
    Error in approval using Position Hierarchy
    Summary:
    Error in approval using Position Hierarchy
    Content:

    I am trying to set approval rule using position hierarchy. But when approval PO, it throw an error: "Error occurred while displaying History tree table. Error in evaluating routing slip. Check the underlying exception and correct the error in the routing slip.".

    I already configured Position Tree, assign each user to each position in the position tree.

    I also looked for the error, there is a note: Position Hierarchy Is Not Working For Purchase Requisition (Doc ID 2225794.1). The document said that: "Set the Effective start date to a past date, before last server restart". But I don't know what the last server restart date is. 

    Can any experts help me to clear this point and setup my approval rule?

    Thank you.

     

    Version:
    11.13.19.07.0
    Image:
  • 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
  • Mohammad Arif Zaffar
    Approval Rules Report/Query25.0
    Topic posted July 17, 2019 by Mohammad Arif ZaffarBronze Medal: 1,250+ Points, tagged Approvals, Approvals/Notification 
    Title:
    Approval Rules Report/Query
    Summary:
    Approval Rules Report/Query
    Content:

    Hello, 

    I believe till 19B, we do not have any report to show the details of PO Approval rules. 

    Appreciate if someone can share a query to extract the rules information along with conditions and actions. 

    One a separate note, do we have any excel upload option for PO approval rules. 

    Thanks

  • Kelly Cooper
    ERP – Recommendations for Modeling Procurement Operations i...25.0
    Topic posted June 3, 2019 by Kelly CooperGold Trophy: 10,000+ Points, tagged Approvals, Fusion, General Ledger, How-To, Manage Procurement Catalog, Requisition Processing, Tip 
    Title:
    ERP – Recommendations for Modeling Procurement Operations in Oracle Cloud Purchasing, 20 June 2019, 9.a.m. PT - Submit Questions
    Content:

    Submit your questions for the SCM – Recommendations for Modeling Procurement Operations in Oracle Cloud Purchasing session to have them answered during the live event. Post your questions by posting a new comment to this topic.

    Please submit your questions by Wednesday, 19 June 2019.

  • Siva Kumar
    Auto Approval not happening for purchase order sourced from...34.3
    Topic posted January 23, 2019 by Siva KumarGold Trophy: 10,000+ Points, tagged Agreements, Approvals, Approvals/Notification 
    Title:
    Auto Approval not happening for purchase order sourced from BPA
    Summary:
    Auto Approval not happening for purchase order sourced from BPA
    Content:

    Hello,

    We created a purchase order from a blanket and submitted it. The status is Pending Approval instead of Open . PO should have been  Auto Approved as all lines are negotiated. 

    Earlier the functionality was working fine.  Please help to resolve this issue.

    Thanks

    Siva.

    Version:
    18 C
  • Dev Thota
    Terminated users are getting removed on requisition even...25.0
    Topic posted September 25, 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, Tip, Web Services 
    Title:
    Terminated users are getting removed on requisition even though the user is PO requester and the user is on inactive state
    Summary:
    Terminated users are getting removed on requisition even though the user is PO requester and the user is on inactive state
    Content:

    Hi all,

    Terminated users are getting removed on requisition even though the user is PO requester and the user is on the inactive state.

    Report Subject Area: Procurement - Purchasing Real Time.

    Thanks,

    Dev Thota.

    Version:
    19C