Supplier Management

Get Involved. Join the Conversation.

Posts

  • Zemeer Padikkal
    Tax Registration Number
    Topic posted 12:44 PM by Zemeer Padikkal, tagged Financials, Payables, Supplier Creation 
    Title:
    Tax Registration Number
    Summary:
    Tax Registration Number usage between Legal Entity and Supplier with Validation
    Content:

    We do need a new option to use the Tax Registration Number used in Legal Entity to Supplier Creation without any duplication inside Suppliers

    We have multiple legal entities
    - As per our business requirement, one legal can be a supplier to other legal entity 
    - when Optin allow duplicate TRN is off, we can't use the same TRN number in Supplier creation because that is used in Legal Entity
    - If we allow duplicate is on - we can create supplier A and Supplier B with same TRN number (We don't want duplicate TRN inside Suppliers)
     

     

  • chetan Kumar
    Isupplier Portal-Unable to create invoice without PO2
    Topic posted November 7, 2019 by chetan Kumar, tagged How-To, Supplier Communication, Supplier Creation, Supplier Profile Management, Supplier Registration, Supplier User Account 
    Title:
    Isupplier Portal-Unable to create invoice without PO
    Summary:
    Isupplier Portal-Unable to create invoice without PO
    Content:

    Hi 

    I am unable to create a invoice without po through supplier portal getting below error,

     
    You must provide a value for the attribute Accounting Date.

     

    And i can see there is no Accounting date attribute.

     

    Regards,

    Chetan

    Image:
  • Ashish Gupta
    Need to know the method to create Supplier using REST API4
    Topic posted November 6, 2019 by Ashish Gupta, tagged Supplier Creation, Web Services 
    Title:
    Need to know the method to create Supplier using REST API
    Summary:
    Need to know the method to create Supplier using REST API
    Content:

    Hi

     

    We have a requirement to create end to end supplier including supplier header, supplier address. business classification, sites and site assignments via REST API. We are using version 19c and referred "Create Supplier" REST API. When we tried to create end to end supplier, we get error " The action create is not enabled". 

     

    Please advise if there is any method through which we can achieve the same.

     

    Regards

    Ashish

    Version:
    19c
  • David Wright
    REST API for Payment Attributes For SupplierAnswered3
    Topic posted November 4, 2019 by David Wright, tagged Fusion, How-To, Supplier Creation 
    Title:
    REST API for Payment Attributes For Supplier
    Content:

    Is there a method of updating or entering values for Payment Attributes when creating a Supplier via REST API?  Documentation does not have anything for that section at all. (documentation in question).

    Version:
    19d
  • David Wright
    REST Suppliers Status failure3
    Topic posted November 4, 2019 by David Wright, tagged Fusion, How-To, Supplier Creation 
    Title:
    REST Suppliers Status failure
    Summary:
    Trying to list a Status value on a Supplier POST REST action causes failure
    Content:

    Creating a supplier via REST does not allow Status value to be set. If Status is listed in payload, regardless of value, request fails with status code 400

    Example from documentation with added Status line (https://docs.oracle.com/en/cloud/saas/procurement/19d/fapra/op-suppliers-post.html):
    {
    "Supplier" : "Tall Manufacturing",
    "TaxOrganizationType" : "Corporation",
    "SupplierType" : "Services",
    "BusinessRelationship" : "Prospective",
    "DUNSNumber" : "221134568",
    "OneTimeSupplierFlag" : false,
    "TaxpayerCountry" : "United States",
    "TaxpayerId" : "98-03376373",
    "Status" : "ACTIVE" # IF THIS LINE IS PRESENT, REST POST FAILS with error: "Attribute Status in view object SupplierVO cannot be set."
    }

  • Sem van Donk
    Taxpayer ID on address level2
    Topic posted October 21, 2019 by Sem van Donk, tagged Supplier Creation, Supplier Profile Management, Supplier Registration, White Paper 
    Title:
    Taxpayer ID on address level
    Summary:
    Taxpayer ID on address level
    Content:

    Hi Community,

    We are having some issues with storing the Taxpayer ID which is required for certain reports of tax authorities on the profile level, and would like to know if there are users with experience where different addresses in the supplier model have their own Taxpayer ID. 

    The situation:

    We are buying products at different companies throughout Europe. Some organizations that we do business with have multiple locations, for example 1 per country, while operating in 3 different countries. For these locations, the supplier makes use of different VAT registration and do business with the particular business unit (from our side) in the corresponding countries (Supplier X, address NL --> business unit NL). From our perspective, as a client of this specific supplier operating in three countries, we see the different supplier locations as 1 main supplier, with whom, as a global company we do business with, meaning price agreements on a global scale and specific services services, eventhough this supplier has different registrations and tax details for the various locations. Long story short, to be able to help the procurement department, we would like to be able to see in one glimpse, what we, eventhough from different business units, buy as a company from this supplier. Which is why we want to store the different locations/addresses underneath one supplier profile. 

    In the below overview you see a table of the sketched situation;

    PartyID

    Profile

    Taxpayer ID

    Address

    VAT-number (connected to address)

    Site

    X

    Company X

     

    Address NL

    NL122225B01

    Procurement BU from NL

     

     

     

     

     

    Procurement BU from BE

         

    Address PL

    DE1225552

    Procurement BU from PL

       

    55445554

    Address ESP

    ES111125556

    Procurement BU from ES

     

    Now the problem arises, for the supplier data we need to provide in the system, we have the ability to store tax related matters on different levels. However, not all tax details can be stored everywhere, we have VAT registrations on Address level (per location) and Taxpayer ID is forced to profile level (1 for all locations) for the SII VAT filling report in Spain. 

     

    The case:

    For the, in the table above, mentioned supplier, the Spanish tax authorities wants us to provide a different tax ID next to the existing VAT registration in the VAT filing, or near real time VAT reporting (SII). In Oracle we can enable this reporting and filing by filling the Taxpayer ID (only possible on profile level for SII reporting as per an oracle whitepaper https://cloud.oracle.com/opc/saas/datasheets/online-vat-spain-topical-essay.pdf). If this would be a single requirement from only Spain, storing this Taxpayer ID on profile level would not be an issue. However, if in the given example, Polish tax authorities are going to raise the same tax requirement, we are not able to store this on the profile level of the same supplier (addresses in Poland and also Spain) as there will already be a Tax Payer ID stored.

    We can ofcourse create seperate suppliers for the countries in which we forsee any kind of potential Taxpayer ID requirement arising, however, due to reporting of spend at grouped suppliers, we do not want to do so. Seperating a supplier based on country to be able to store the Taxpayer ID on profile level will make the business reporting for total spend a lot more cumbersome and time consuming.

    Is there anyone with a simular issue, and has a solution on how to handle this, ideally we would like to store the Taxpayer ID on address level, where VAT registrations are stored as well, at the moment, for the SII reporting, this is not possible as mentioned here; https://cloud.oracle.com/opc/saas/datasheets/online-vat-spain-topical-essay.pdf. (attached) And as confirmed by Oracle support in a Service Request.

    Thanks,

    Regards,

    Sem

    Version:
    19C
  • Sivaraj Shanmugham
    Scheduling Supplier Audit report3
    Topic posted October 21, 2019 by Sivaraj ShanmughamRed Ribbon: 250+ Points, tagged Audit, Supplier Creation, Supplier Profile Management 
    Title:
    Scheduling Supplier Audit report
    Summary:
    Looking for an automated way to send the Supplier Audit report to Finance
    Content:

    Currently users are running the audit report from Tools menu. Team is asking if there is a way to schedule this report to run on a weekly basis and deliver the report output to one or more users. 

    Thanks, Siva

     

  • ALEXANDER JOSEPH
    Which table stores the tax classification code that is...4
    Topic posted October 10, 2019 by ALEXANDER JOSEPHRed Ribbon: 250+ Points, tagged Supplier Creation, Supplier Profile Management 
    Title:
    Which table stores the tax classification code that is entered at the Supplier profile
    Summary:
    Which table stores the tax classification code that is entered at the Supplier profile
    Content:

    Which table stores the tax classification code that we enter at the Supplier Profile level > Transaction tax>Controls and defaults

    Is there a webservice or API that we can call to get this detail

     

  • PRASHANT MENON
    Not able to Select Roles while Creating User Contact in...1
    Topic posted October 9, 2019 by PRASHANT MENONGreen Ribbon: 100+ Points, tagged Supplier Communication, Supplier Creation, Supplier Profile Management, Supplier Registration, Supplier User Account 
    Title:
    Not able to Select Roles while Creating User Contact in Supplier Contact
    Summary:
    Not able to Select Roles while Creating User Contact in Supplier Contact
    Content:

    Not able to Select Roles while Creating User Contact in Supplier Contact

    “If Manage Supplier User Roles shows that there are no roles, that means there are no roles that can be added for supplier contacts. 

    We will need to add roles here so that roles are available for selection when requesting/creating user accounts for supplier contacts.” 

    Which roles can be added in 'Manage Supplier User Roles'  task, so that it is visible while creating User contact

    Image:
  • Catherine Hull
    Enabling Supplier Match; Batch Feature35.0
    Topic posted October 6, 2019 by Catherine HullSilver Medal: 2,000+ Points, tagged FAQ, How-To, Supplier Creation, Supplier Merge, Supplier Profile Management 
    Title:
    Enabling Supplier Match; Batch Feature
    Summary:
    What is the purpose of the Supplier Match Batch Feature? How to utilize this feature?
    Content:
    What is the purpose of the Supplier Match Batch Feature? How to utilize this feature?

    Under Define Supplier Matching > Manage Enterprise Data Quality Matching Configurations, what is the purpose of Batch: Match Configuration Parameters?

    This question arose, because after following the Oracle setup documentation (all steps of Implementing-Procurement.pdf > Enabling Supplier Match: Explained), I obtained results after defining Real-Time Match Configuration Parameters, BUT I do not know where in the system the Batch Match Configuration Parameters are utilized. Would it be a scheduled process that runs?

     

    The Oracle Implementing Procurement manual does not provide any detail about the purpose of the Batch feature. I have not been able to find additional insight anywhere else.

     

    Thanks, Catherine

    Version:
    Release 13 19B