Posts

Posts

  • 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 in Procurement > Supplier Management public
    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
  • Shivani Roy
    Points to consider when importing supplier attachments using...5.0
    Topic last edited October 25, 2019 by Shivani RoyBronze Medal: 1,250+ Points, tagged How-To, Import, Supplier Profile Management, Tip in Procurement > Supplier Management public
    Title:
    Points to consider when importing supplier attachments using Import Supplier Attachments FBDI template.
    Summary:
    Here are some useful tips for importing supplier attachments using the supplier attachments import template:
    Content:

    1. Pick the correct template as per your quarterly update. Refer to this post to access the correct FBDI template for your quarterly update:

    Where can I find FBDI Import templates for my current quarterly update?

    2. In general an import job can complete successfully and still have error status even if one of the records failed to import due to incorrect data provided. Check the report to ensure all attachments are    imported successfully and identify any failed records.

    3. The Supplier Attachment Import template contains three individual worksheets for importing supplier profile, supplier site and business classification attachments.The instructions to run the import are given in the ‘Instructions and CSV Generation’ worksheet of the import template.Do not delete worksheets corresponding to levels of attachments that you do not intend to import. Delete only the sample data from these unused worksheets.

    4. For a file attachment consider the following points:

    • Limit the number of attachments in each .zip file to less than 300.
    • Reduce the number of attachments in the .zip file even further if the .zip file size is more than 1.5GB. Use one or more zip files for each batch and use batch name as part of zip file name for ease of data entry in the spread sheet.
    • Execute import in multiple smaller batches as opposed to a single big batch to expedite the import process.
    • Make sure the zip filename matches the zip file uploaded in the UCM server.
    • Make sure the ‘File/Text/URL*’ column value in the spreadsheet has the full folder hierarchy of the attachment file inside the zip folder including subfolders if any. Take a look at the example below.

                             e.g: we have a zip file named: Policies.zip

                                    Subfolder: SupplierPolicies is a subfolder in the zip file

                                    File Name: Terms.doc is the file inside the subfolder

                                    Input for column ‘File/Text/URL*’: SupplierPolicies/Terms.doc

                                    Input for column ‘File Attachments .ZIP’: Policies.zip

    • Some of the special characters are currently not supported for a filename:

               <  >  *  ?  |  ;  "  :  /  \\  %  $  ( )

     

    Readiness training video is available for further reference: Supplier Attachments Import

    Tips on general supplier import: Supplier Import Tips

  • Mukund Kudrimoti
    Details on supplier portal setups25.0
    Topic posted October 15, 2019 by Mukund KudrimotiRed Ribbon: 250+ Points, tagged Payables, Supplier Communication, Supplier Profile Management, Supplier Registration in Procurement > Supplier Management public
    Title:
    Details on supplier portal setups
    Summary:
    Details on supplier portal setups
    Content:

    Hi,

    I was looking for a step by step document on setting up Supplier portal and access in Cloud. Appreciate if someone has any information.

    Regards,

    Mukund

    Version:
    19C
  • 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 in Procurement > Supplier Management public
    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

     

  • Faye Karas
    How to Configure Foreign Suppliers for 1042-S Reporting3
    Topic posted October 19, 2018 by Faye KarasBronze Medal: 1,250+ Points, tagged Supplier Profile Management in Procurement > Supplier Management public
    Title:
    How to Configure Foreign Suppliers for 1042-S Reporting
    Summary:
    How to Configure Foreign Suppliers for 1042-S Reporting (Form 1042-S, also "Foreign Person's U.S. Source Income Subject to Withholding", is used to report any payments made to foreign persons. )
    Content:

    How to Configure Foreign Suppliers for 1042-S Reporting.  Form 1042-S, also "Foreign Person's U.S. Source Income Subject to Withholding", is used to report any payments made to foreign persons.

    Version:
    Oracle Cloud Fusion R13
  • Harshith Eshwar Shaila
    In need of a query to track number of emails and related...Answered2
    Topic last edited October 9, 2019 by Harshith Eshwar ShailaBronze Medal: 1,250+ Points, tagged Security, Supplier Communication, Supplier Profile Management in Procurement > Supplier Management public
    Title:
    In need of a query to track number of emails and related details sent out to suppliers over a period of time?
    Content:

    Hi all,

    We require a query that we can run in BI publisher to show any emails sent out to suppliers over a period of time?  During testing we unintentionally had emails from POs and Agreements sent out to actual suppliers from development instance, we have manually generated a list of affected suppliers (they were less in number), but it would be helpful to have a query for this issue if it occurs again. 

    We have opened an service request (SR 3-21255360671) for this a well.

    Regards,

    Harshith E S

     

    Version:
    19C (11.13.19.07.0)
  • Catherine Hull
    Enabling Supplier Match; Batch Feature35.0
    Topic last edited October 6, 2019 by Catherine HullGold Medal: 3,500+ Points, tagged FAQ, How-To, Supplier Creation, Supplier Merge, Supplier Profile Management in Procurement > Supplier Management public
    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
  • Catherine Hull
    Contact Duplicate Identification and Address Duplicate...35.0
    Topic last edited October 6, 2019 by Catherine HullGold Medal: 3,500+ Points, tagged How-To, Setup, Supplier Creation, Supplier Profile Management in Procurement > Supplier Management public
    Title:
    Contact Duplicate Identification and Address Duplicate Identification
    Summary:
    What is the purpose of "Contact Duplicate Identification" or "Address Duplicate Identification" ?
    Content:

    Under Define Supplier Matching > Manage Enterprise Data Quality Matching Configurations, what is the purpose of "Contact Duplicate Identification" or "Address Duplicate Identification" ?

    This question arose, because after following the Oracle setup documentation (all steps of Implementing-Procurement.pdf > Enabling Supplier Match: Explained), I obtained results after setup of 'Account Duplicate Identification' BUT no results after setup for 'Contact Duplicate Identification' or 'Address Duplicate Identification'. The 'Account Duplicate Identification' setup provided results when testing in the system or testing Actions > Review Configuration Results.

     

    My results are in a system with multiple suppliers, duplicate information within multiple supplier records, and duplicate information within one supplier record.

     

    The Oracle Implementing Procurement manual does not provide any detail about the purpose of "Contact Duplicate Identification" or "Address Duplicate Identification". I have not been able to find additional insight anywhere else.

     

    Thanks, Catherine

    Version:
    Oracle Cloud 19B
  • 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 in Procurement > Supplier Management public
    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:
  • Rushi Joshi
    Show supplier bank account from supplier address/site on...2
    Topic last edited October 10, 2019 by Rushi JoshiSilver Medal: 2,000+ Points, tagged Fusion, How-To, Supplier Profile Management, Supplier User Account in Procurement > Supplier Management public
    Title:
    Show supplier bank account from supplier address/site on supplier portal
    Summary:
    Need to check if it is possible to capture supplier bank account from supplier address or/and supplier site to the supplier profile on supplier portal.
    Content:

    Hello all,

    Currently, I can only see the bank account that is on the supplier header and that is getting captured on the supplier portal (supplier user account).

    Scenario: There are there supplier addresses, sites and contacts(user accounts). Every address is linked with a unique bank account, site and a unique contact(through address). All these three unique bank accounts are also unique with the one on the supplier header(profile).

    Aim: 

    1) To capture bank account on supplier portal from supplier address/site instead of supplier header. Is this achievable? Does it govern by roles/privileges?

    2) If point one is achievable, how can we add security? On the supplier portal, one user account should only be able to view the bank account associated with the address and site assigned to him/her.

    3) If everything above is not possible, can I simply restrict one bank account from supplier header to one contact user account on the supplier portal?

    Thanks,

    Rushi

    Version:
    19C