Posts

Posts

  • Aishwarya Pawar
    Suppliers on Purchasing Hold by Supplier Type Report24.5
    Topic posted April 16, 2018 by Aishwarya PawarGold Medal: 3,500+ Points, tagged Business Intelligence, How-To, Supplier Profile Management in Procurement > Supplier Management public
    Title:
    Suppliers on Purchasing Hold by Supplier Type Report
    Summary:
    Dashboard Displaying Active Suppliers On Purchasing Hold By Supplier Type
    Content:

    This dashboard will allow you to retrieve a list of your active suppliers that have one or more sites on Purchasing Hold.

    It consists of a summary view that provides a count of such suppliers by Supplier Type, and a detailed view that provides relevant information such as the Site Name, Procurement BU and Hold Reason for each supplier. In addition, results can be filtered by the supplier's creation date.

    The attached Deployment Instructions.pdf contains steps for importing the dashboard to your instance.  The attached Suppliers On Purchasing Hold.catalog file can be used to import the dashboard on your instance.

    Image:
  • Ujas Bhatt
    Oracle Cloud Supplier Portal Integration Capabilities1
    Topic posted March 30, 2018 by Ujas BhattSilver Trophy: 7,500+ Points, tagged How-To, Setup, Supplier Profile Management, Supplier User Account, Web Services in Procurement > Supplier Management public
    Title:
    Oracle Cloud Supplier Portal Integration Capabilities
    Summary:
    Oracle Cloud Supplier Portal Integration Capabilities
    Content:

    We want to build a solution wherein we implement Oracle Cloud Supplier Portal and have integrations between Oracle cloud supplier portal and Oracle EBS. The solution should allow suppliers to access the purchase orders, purchase agreements and invoices status created in EBS using Oracle Cloud Supplier portal. Similarly, the suppliers should be able to acknowledge purchase documents, create Shipment notices and create invoices in Oracle cloud supplier portal and these transactions should be interfaced to Oracle EBS. 

    Can Oracle Cloud Supplier Portal be configured as a standalone offering and can we create integrations to and from Oracle Cloud Supplier Portal?

  • Hong Gao
    Country Defaulting in Supplier Address Creation14.5
    Topic posted March 27, 2018 by Hong GaoGold Medal: 3,500+ Points, tagged Supplier Creation, Supplier Profile Management, Supplier Registration, Tip in Procurement > Supplier Management public
    Title:
    Country Defaulting in Supplier Address Creation
    Summary:
    Defaulting logic in supplier address creation for different supplier management flows
    Content:

    When a supplier address is created in various supplier management flows such as registration and profile management, the application will derive and default a country based on the following logic.

    A. External/Supplier Self Service Registration:

    1. If the parameter "countryCode" and a value is provided in the registration URL, it will be used to derive the country. For example, if user appends "&countryCode=FR" at the end of the external registration URL, country will be defaulted to France when user is creating address during the registration.
    2. If the parameter "countryCode" is not provided or it does not resolve to a country, the application will derive the country using the location assigned to the inviting Procurement BU that is associated with the registration URL.  To set the location of the Procurement BU:
      • Go to Setup and Maintenance work area and go to the Manage Business Unit setup page
      • Search for the Procurement BU, set the location and click Save
    3. If no country information can be obtained from the aforementioned, no default country will be populated.

    B. Internal Supplier Registration/Create or Edit Supplier/Register Supplier in Sourcing/Request New Supplier in Self Service Procurement:

    1. If a Procurement BU is provided in any of these cases, the application will use the location assigned to the Procurement BU to obtain a country.
      • For Internal Supplier Registration flow, Procurement BU is optional.
      • For Create Supplier or Edit Supplier flow, there is no Procurement BU context for address creation.
      • For Register Supplier flow in Sourcing, the Procurement BU is the one defined in the negotiation.
      • For Request New Supplier flow in Self Service Procurement, the application will first obtain the Requisitioning BU from the Requisitioning Preferences page in the Purchase Requisitions work area. It will then use the Requisitioning BU to derive a default Procurement BU from the Configure Requisitioning Business Function setup page.
    2. If a Procurement BU is not provided or if the Procurement BU does not carry a location assignment, the application will obtain the country from the job assignment location for the current user's employee record in HCM.  To set or change user's job assignment location on the employee record:
      • Go to Person Management work area and search for the person that the user is associated with
      • Take Manage Employment action, click Edit and then Update
      • Select Action: Location Change and click OK
      • Set the location for the job assignment and click Save
    3. If no country information can be obtained from the aforementioned, no default country will be populated.

    C. Edit Profile in Supplier Portal:

         When a supplier user creates a new address, if all active supplier addresses have the same country information, the application will use that country for defaulting. Otherwise, no country defaulting is supported.

  • Prasad Deshpande
    How to export diversity data3
    Topic posted March 27, 2018 by Prasad DeshpandeRed Ribbon: 250+ Points, tagged How-To, Supplier Profile Management in Procurement > Supplier Management public
    Title:
    How to export diversity data
    Summary:
    How to export diversity data in various formats like pdf, excel, text etc?
    Content:

    Is there a way to export diversity data in various formats like pdf, excel, text etc? 

  • Hamish Gifford-Moore
    Approve supplier bank account changes4
    Topic posted March 27, 2018 by Hamish Gifford-MooreRed Ribbon: 250+ Points, tagged Approvals/Notifications, Audit, Security, Setup, Supplier Creation, Supplier Profile Management, Supplier Registration, Supplier User Account in Procurement > Supplier Management public
    Title:
    Approve supplier bank account changes
    Summary:
    Approve supplier bank account changes
    Content:

    Is it possible to place a supplier on payment hold when any changes to nominated fileds have been made. These might be bank account details, payee name, payment method etc.

    If a hold is not possible can we utilise the audit facilities to perhaps drive mesaging to manage this. Perhapos by using API's thought ICS to set a hold flag on the supplier after a trigger from teh audit table?

    Any ideas welcome

    We are on R12 but moving to R13.

  • Luiz Mendes
    Supplier Tax Classification Code2
    Topic posted February 21, 2018 by Luiz MendesBlue Ribbon: 750+ Points, tagged Supplier Profile Management in Procurement > Supplier Management public
    Title:
    Supplier Tax Classification Code
    Summary:
    Unable to find tax data in the tables
    Content:

    Hi, 

    We are importing a considerable number of Suppliers and on our files we are populating the VAT_CODE column. I can see the POZ_SUPPLIERS does hold this information but it cannot be seen anywhere on Screen.

    So I'm wondering if you guys know what column we should populate on the FBDI files to see the info on the table below, or which table holds the information inserted on the field Tax Classification Code from the screenshot attached.

    Best Regards, Luiz

     

     

     

    Image:
  • Sivaraj Shanmugham
    Supplier Overview Page - Add Custom Content63.0
    Topic posted January 28, 2018 by Sivaraj ShanmughamBronze Medal: 1,250+ Points, tagged Supplier Profile Management in Procurement > Supplier Management public
    Title:
    Supplier Overview Page - Add Custom Content
    Summary:
    We would like to customize the Supplier Overview page and show a table of all "Supplier Registration requests not submitted".
    Content:

    Can this be done and display data with the same look and feel as other panels - Menu - Actions, View, format, Export to Excel etc. ?

  • Maullin Shah
    Supplier Registration process --> How to update supplier...3
    Topic posted January 25, 2018 by Maullin ShahRed Ribbon: 250+ Points, tagged Supplier Profile Management, Supplier Registration, Supplier User Account in Procurement > Supplier Management public
    Title:
    Supplier Registration process --> How to update supplier Bank Details at Site Level?
    Summary:
    Supplier Registration process --> How to update supplier Bank Details at Site Level?
    Content:


    Hello All,

    We are on Oracle ERP Cloud Procurement - R13 (Update 17D)

    We are using Supplier Registration process to enter suppliers in system.  Now, based on our model, bank details are updated at Supplier site level and not at Supplier profile level.

    Appreciate, if you can guide -->  if we can update bank details at supplier site level? If yes, then how?  If no, then what is workaround to achieve this?

    with regards, Maullin Shah

  • Manoj Kumar Chaurasia
    Ability to have vendors submit their W-9 via a vendor...3
    Topic posted January 22, 2018 by Manoj Kumar ChaurasiaBronze Medal: 1,250+ Points, tagged Supplier Creation, Supplier Merge, Supplier Profile Management, Supplier Registration, Supplier User Account in Procurement > Supplier Management public
    Title:
    Ability to have vendors submit their W-9 via a vendor self-service portal
    Summary:
    Ability to have vendors submit their W-9 via a vendor self-service portal
    Content:

    Ability to have vendors submit their W-9 via a vendor self-service portal.

    About Form W-9, Request for Taxpayer Identification Number and Certification. Use this form to provide your correct TIN to the person who is required to file an information return with the IRS to report, for example, income paid to you, real estate transactions, mortgage interest you paid, acquisition or abandonment of secured property, cancellation of debt, or contributions you made to an IRA.

  • Rajib Rath
    Q: Supplier Web Service - Is there a way to upsert and/or...6
    Topic posted January 12, 2018 by Rajib RathGreen Ribbon: 100+ Points, tagged Supplier Creation, Supplier Profile Management, Web Services in Procurement > Supplier Management public
    Title:
    Q: Supplier Web Service - Is there a way to upsert and/or query supplier information using web service?
    Summary:
    Need ability to upsert and/or query supplier information using web service
    Content:

    In R13, Inbound Supplier Web Service has been introduced with the following two operations:

    Customer is already live of R12 and has a need to synchronize supplier information from their on-premise supplier master / hub to Cloud on a near real-time basis. They have already imported their existing suppliers into cloud as a part of their initial go-live but would like to leverage the inbound supplier web service for near real-time synchronization of supplier information between their supplier master / hub and cloud. They currently have no way of identifying in their on-premise supplier master / hub if a specific supplier (and it related information) has already been created in cloud or not. Thus they are not able to decide if for the inbound supplier web service the "create" operation should be invoked to create a new supplier in cloud or the "update" information should be invoked to update an existing supplier in the cloud. 

    Questions:

    • Do either the create or update operations of the inbound supplier web service support "upsert" operation? This operation will allow them to invoke the web service and create the relevant supplier information if the supplier information does not exist or update the supplier information if matching records are found.
    • If "upsert" operation is not supported, is there a web service / operation that can be invoked to  "get" supplier information from cloud? Such a capability will allow them to query the supplier and then decide if  "create" or "update" operation should be invoked based on the non-existence or existence of the supplier record in the cloud.

    Thanks in advance for your help.

    Regards,

    Rajib