Posts

Posts

  • chetan Kumar
    Isupplier Portal-Unable to create invoice without PO2
    Topic last edited November 7, 2019 by chetan Kumar, tagged How-To, Supplier Communication, Supplier Creation, Supplier Profile Management, Supplier Registration, Supplier User Account in Procurement > Supplier Management public
    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:
  • William Knowles
    Supplier Portal User Guide/Manual3
    Topic posted April 17, 2017 by William KnowlesSilver Medal: 2,000+ Points, tagged Setup, Supplier Profile Management, Supplier User Account in Procurement > Supplier Management public
    Title:
    Supplier Portal User Guide/Manual
    Summary:
    Supplier Portal User Guide/Manual
    Content:

    We are planning to roll-out our Supplier Portal to our top preferred/approved suppliers.  Has anyone created a Supplier Portal guide/manual that can be sent to suppliers for learning or training purposes?  Since the layout in Fusion is globally uniform I was hoping that I would not have to start from scratch on developing the guide?  Would any customers be willing to share their guide or portions of their guide?

  • Jayaganesh Alagirisamy
    Masking Supplier Tax Payer ID45.0
    Topic posted June 19, 2019 by Jayaganesh AlagirisamyBlue Ribbon: 750+ Points, tagged Fusion, Supplier Creation, Supplier Merge, Supplier Profile Management, Supplier Registration, Supplier User Account in Procurement > Supplier Management public
    Title:
    Masking Supplier Tax Payer ID
    Summary:
    We would want to mask the Supplier Taxpayer ID across Organization types
    Content:

    Hi,

     

    The business would want to have their suppliers tax payer id masked, but it is only possible to mask if the Organization type is "Individual". Please refer the below metalink. Masking Supplier Tax Identifiers PII Data (Doc ID 2330050.1)

    My question is if the supplier renders a different kind of service irrespective of the tax organization type, then is it possible to mask the Taxpayer ID across suppliers? Please let me know if you have any workaround for the same. 

    Thanks,

    Jay.

  • Amy Chan
    Unique key of supplier2
    Topic posted December 11, 2018 by Amy ChanSilver Medal: 2,000+ Points, tagged Financials, Supplier Creation, Supplier Merge, Supplier Profile Management, Supplier Registration, Supplier User Account in Procurement > Supplier Management public
    Title:
    Unique key of supplier
    Summary:
    Unique key of supplier
    Content:

    I have a question for unique key of supplier. I want to create "HP" as a supplier name and the country is "US" for US legal entity. Later when we rollout to "UK"  and we need to create another "HP" supplier with country "UK" and system prompt up an error message.

    Would anyone share with me for such case?

     

  • Dave Dengate
    Displaying Unmasked Bank Account12
    Topic posted April 3, 2017 by Dave DengateBlue Ribbon: 750+ Points, tagged Public Sector, Supplier Creation, Supplier Profile Management in Procurement > Supplier Management public
    Title:
    Displaying Unmasked Bank Account
    Summary:
    When Maintaining Bank Accounts we need to see the full Bank Account number
    Content:

    There are occasions when our Account Payable's manager need to see the full bank account number to ensure we are creating duplicates or allocating the wrong Bank Account to a Supplier.

    Is there a way within Fusion where the full Bank Account Number (I.e. 12345678, not xxxx5678) can be displayed.?

  • Sivaraj Shanmugham
    Scheduling Supplier Audit report3
    Topic posted October 21, 2019 by Sivaraj ShanmughamRed Ribbon: 250+ Points, tagged Audit, Supplier Creation, Supplier Profile Management in Procurement > Supplier Management public
    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

     

  • 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 RoyBlue Ribbon: 750+ 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