Supplier Management

Get Involved. Join the Conversation.


  • Piyush Singh

    Hi Dave,

    Use #Null to update a value to null.



  • Bas van Gameren

    Ramesh, great question!

    I really don't know.. would indeed be great to have a supplier portal capability that allows for online, collaborative authoring of procurement contracts.
    You could make an idea for this in the "Idea Labs" section of customer connect, how do you feel about this?


  • Ramesh Radhakrishnan

    Hi Bas,

    Thanks for the details. So online redlining is not an option for the contracts that are worked between buyers and suppliers in R12. Buyer will have to send the redlining doc in trandtional email and supplier will have to send it back after accepting or rejection. Is this feature planned in any future releases?



  • Bas van Gameren

    No, this feature is not supporten in R12 (in R13).

    When procurement contracts and sourcing are both deployed, the supplier may review the negotiation T&C's, maybe enter variables and accept them - as part of their negotiation response. No actual co-authoring on contract terms thru supplier portal. 

  • Jim Van Tongerloo

    Hi Virginia,

    I stumbled upon this post, by accident I must admit, and strangely enough I had the same question about a year ago. Without anything useful I could pull or get from the communities, I decided to log an SR. After much waiting (it got bounced around to a lot of different engineers), I finally got the following response. I didn't chase it further, to be honest. Hope it can help a bit with the first part of your question.

    Hi Jim,
    as a former consultant ;) i'll try to imagine how I would proceed in this situation:

    1. PO Matched Invoice entered by Supplier in ISP.

    2. Schedule "Import Invoices" with Source = "Internet Supplier Portal" to run at appropriate interval

    3. Schedule Validate Invoices (probably you have both 2 and 3 already scheduled).

    When this runs, system will place Matching Holds as per your matching Level (2, 3, 4 way) and tolerances.

    4. From this point forward, you should use your current strategy for approving Invoices that were placed on matching hold (the ones that are not placed on hold do not need any approvals, at least this is my opinion - since you already approved the PO previously).

    pls let me know if the above makes sense


  • Alan Ng

    Supplier business classifications stored in POZ_BUS_CLASSIFICATIONS are used to track supplier certifications such as minority owned or woman owned.

    Are the business classifications in the UK Pro-Class supplier classification system more similar to products and services categories supplied by companies?  If so, you can use the 'Manage Supplier Products and Services Category Hierarchy' setup task to upload them using a spreadsheet.

  • Hong Gao

    Your understanding is right.  There is no mechanism to bulk upload lookup codes like POZ_BUS_CLASSIFICATIONS.



  • Dave Dengate

    Thanks for both the posts, however it is the External Bank Account that our AP manager needs to view Unmasked.



  • Janardhana Kondaveeti

    Hi Dave,

    The issue is caused by the following set-up:Manage Cash Management Profile Options

    For Internal Bank accounts, the profile option  quoted below is correct. It only has one option.  On View pages, Bank account numbers are always masked.
    If you want to see the unmasked number, you can do it from the below steps

    Login to Application->Navigator->setup and maintenance->search "Manage Cash Management Profile Options"
    and select Profile option code: "CE_MASK_INTERNAL_BANK_ACCT_NUM" and search

    1. We currently only have one security option set in Functional Set up Manager  : "Manage Cash Management Profile Options"
    Profile option code: CE_MASK_INTERNAL_BANK_ACCT_NUM

    The profile option : CE_MASK_INTERNAL_BANK_ACCT_NUM: Profile Values is "No Masking" and save and close the application

    reset the issue.!


  • Iliyas Syed


    Please refer this document "Oracle Fusion Applications Credit Card and Bank Account Encryption (Doc ID 1504285.1)"


    Iliyas Syed

  • Piyush Singh


    Yes, you can use supplier de-duplication feature to create a party relationship for the existing party/customer rather than creating a new party which is created when you directly create a supplier.

    The supplier de-duplication feature requires EDQ implementation and it functions by suggesting users for possible matches of the supplier being creaed against existing parties (based on configuration/setup). Users are then allowed to establish a supplier relationship with any matched/suggested party. Creation of a new relationship (supplier relationship) for the existing party ensures data sharing and therefore does not result in duplicate check. The process creates a supplier but in DB it is a new relationship for an existing party rather than creating a new party which happens when a supplier is directly created.

    You can refer to Supplier Data Quality Management TOI to implement this feature.

    Hope this helps.



  • Jeff Glanville

    There are no legacy ERP SQL scripts (to extract supplier master data) provided with Oracle Procurement Cloud.  

  • Jeroen Sprangers

    Okay, thanks for your answer and help.

  • Piyush Singh

    We do not have explicit reasons documented. The rule of thumb is to reject, if during the approval flow, application fails to find approvers to route the request for next approval action.

    Cases like DUNS number duplicate etc. do not lead to the rejection of request upfront. For such cases, supplier creation fails which happens after the registration request is approved.

    Hope this helps.

  • Jeroen Sprangers

    Okay, thanks we will check our approval rules configuration.


    Are the limited number of reason for approval failure leading to auto rejection documented somewhere? 

    I can imagine for instance that if the tax payer id or DUNS number is duplicate it errors out. But in the documentation I cannot find what the exact checks are that are being performed and when the result is an error.