Posts

Posts

  • jin hu
    Supplier Contacts -FBDI Error2
    Topic posted August 22, 2019 by jin huBronze Medal: 1,250+ Points, tagged Financials, Import, Setup in Procurement > Supplier Management public
    Title:
    Supplier Contacts -FBDI Error
    Summary:
    Supplier contacts showing not imported with error message, but was actually loaded in the UI
    Content:

    Hi,

    We got errors saying that the supplier contacts were not loaded and the rejection reason is "An error occurred. Contact your help desk". However, when I go into the UI to check, I see that the contacts are actually there. Is this an issue I should be concerned about? Or is it a bug?

    Image:
  • Bhawana Fnu
    Supplier hold1
    Topic posted May 3, 2019 by Bhawana Fnu, tagged Financials, Fusion, How-To, Import, Orders, Payables, Sourcing Programs, Supplier Communication, Supplier Creation, Supplier Merge, Supplier Profile Management, Supplier Registration, Supplier User Account in Procurement > Supplier Management public
    Title:
    Supplier hold
    Content:

    Supplier Holds: How would supplier holds for one business be interacting with another business? InventoryOrganization1 has Supplier A on hold but InventoryOrganization2 wants to do business with Supplier A. how will this work at supplier level? How will this work on supplier item level? (Please note: InventoryOrganization1 and InventoryOrganization2 are defined in same Business Unit)

  • Piyush Singh
    Creating an Existing Party as a Supplier15.0
    Topic posted April 25, 2019 by Piyush SinghBronze Trophy: 5,000+ Points, tagged How-To, Import, Supplier Creation, Tip in Procurement > Supplier Management public
    Title:
    Creating an Existing Party as a Supplier
    Summary:
    How to establish a supplier relationship for an existing party
    Content:

    In today’s competitive business environment, organizations must continuously strive to optimize business flow efficiency and operate more strategically.  One opportunity is for smarter modeling of trading relationships with key business partners to gain better visibility and business insight into these relationships.  This is achieved in Oracle Cloud by creating multiple relationships with the same company, for example, a banking provider that is also a customer or, a customer that also serves as a strategic supplier providing goods or services.  These represent different business relationships with a single enterprise, which can be managed from both the supplier and customer master by leveraging a single shared party profile record.

    You can establishing a supplier relationship with an existing party either using Data Quality Management or using Supplier Import process. Following is a brief on the usages of these approaches.

    1. Data Quality Management (DQM): DQM is a preventive mechanism empowering users such that they do not create duplicate parties identified as parties with similar names. DQM does not rely on exact match of the name (depending upon the configuration) to list out the potential duplicates therefore is very effective in preventing duplicate parties in the application.
    2. Establishing supplier relationship using supplier import: When user knows the party that he or she has to create as a supplier, then this approach will be more effective. Following this approach, user saves time required to review all the potential matches as well as avoids any mistake in form of picking up incorrect party for supplier relationship establishment.

    *Details on Data Quality Management will be covered in another post.

    If you know the exact party that you want to create as a supplier, use the supplier import capability to achieve the same. Following are the steps you need to follow when creating supplier from an existing party (customer in the example below).

    1. Find the Registry ID of the customer from the Manage Customers task.

     image2019-4-25_11-50-32.png?version=1&modificationDate=1556173232514&api=v2

    2. Use this Registry ID and the Organization Name to create a supplier relationship for this customer using the supplier import process. Populate the FBDI template for Supplier Import as shown in the screen shot below.

    image2019-4-25_11-50-56.png?version=1&modificationDate=1556173256402&api=v2

    Points to consider when using Registry ID in the template:

    1. Provide Registry ID only for the import action ‘Create’.
    2. Organization Name must be entered exactly as the Supplier Name. If not, the record will be rejected.
    3. Complete the supplier import process (generate csv > load file to interface > run supplier import job).
    4. After the import process completes successfully, search for this supplier, and review the registry ID along with the Relationships of the supplier.

    image2019-4-25_11-51-24.png?version=1&modificationDate=1556173284712&api=v2

    Additional reference:

    -          Create Supplier From Existing Party Using Supplier Import: TOI

     

  • Mohammad Alhindawi
    Approval cycle for the suppliers master data creation6
    Topic posted March 11, 2019 by Mohammad AlhindawiRed Ribbon: 250+ Points, tagged Approvals/Notifications, Audit, Business Intelligence, Create Requisition, Customization, FAQ, Financials, Fusion, How-To, Import, Orders, Payables, Public Sector, Requisition Processing, Security, Setup, Sourcing Programs, Supplier Communication, Supplier Creation, Supplier Merge, Supplier Profile Management, Supplier Registration, Supplier User Account, Tip, Web Services, White Paper in Procurement > Supplier Management public
    Title:
    Approval cycle for the suppliers master data creation
    Summary:
    Approval cycle for the suppliers master data creation
    Content:

    Is there an approval cycle for the suppliers master data creation in the app?

    Version:
    Oracle Fusion Procurement Cloud
  • Binayak Mohanty
    Restrict Contract/PO Creation for a specific Supplier1
    Topic posted February 13, 2019 by Binayak MohantyBlue Ribbon: 750+ Points, tagged Create Requisition, Customization, Financials, Fusion, How-To, Import, Orders, Payables, Requisition Processing, Security, Setup, Supplier Communication, Supplier Creation, Supplier Merge, Supplier Profile Management, Supplier Registration, Supplier User Account, Tip, White Paper in Procurement > Supplier Management public
    Title:
    Restrict Contract/PO Creation for a specific Supplier
    Summary:
    Restrict Contract/PO Creation for a specific Supplier
    Content:

    Hi,

    I have a requirement where we would like to restrict the creation of Procurement Contract/Purchase Requisition/Purchase Order for a supplier after Supplier is issued with a specific amount in a particular financial year.

    How can we achieve this functionality?

    Thanks

    BM

  • Aishwarya Pawar
    Use ERP Integration Service to automate Supplier Import5.0
    Topic posted December 20, 2018 by Aishwarya PawarSilver Medal: 2,000+ Points, tagged How-To, Import, Web Services in Procurement > Supplier Management public
    Title:
    Use ERP Integration Service to automate Supplier Import
    Summary:
    (How-To) use the ERP Integration Web Service to import suppliers into Oracle Procurement Cloud
    Content:

    Supplier Import feature allows you to bulk load suppliers from external systems into Oracle Procurement Cloud. This involves capturing the import data in a CSV format, uploading the data file to the UCM server, loading the data into interface tables and then moving it to the supply base post successful validation. The loading and importing of data is accomplished by scheduling 2 ESS processes:

    1. Load Interface File for Import process that loads the data into the interface table
    2. The import process that validates the data in the interface tables and moves it to the supplier base (E.g. Import Suppliers, Import Supplier Addresses etc.).

    ERP Cloud provides an integration web service that helps automate the steps to upload data file (CSV format) to the UCM server, load the data into interface tables and subsequently import it into Oracle Procurement Cloud. This eliminates the need to execute these steps manually.

    Here are the instructions to import supplier data using the ERP Integration Web Service:

    1. Use the FBDI templates available on Oracle Help Center to capture the import data and generate the CSV file (made available as a zip file). TIP: Using these templates ensures import data is loaded into the interface in the correct format. The latest import templates are available here.
    2. Convert the zip file generated above to BASE64 encoding. NOTE: You will later need to insert that in the request payload below.
    3. Construct the ERP Integration Service End Point URL (WSDL URL). Note: Replace HOST_NAME.DOMAIN_NAME using the appropriate values from your pod instance in this URL: https://<hostname>.<domainname>/publicFinancialCommonErpIntegration/ErpIntegrationService.
    4. Create the payload for the operation: importBulkData available as part of the service. In general, this operation uploads the file specified in the payload to the UCM server and submits ESS jobs to load and import the uploaded files to the appropriate application. NOTE: Sample request payload included below.
      image2018-12-18_14-53-47.png?version=1&modificationDate=1545173627000&api=v2
    5. Ensure the payload is correctly populated as follows:
      1. Insert the ZIP file contents in BASE64 encoding within the <erp:Content> tag.
      2. Specify the exact file name of the ZIP file in the <erp: FileName> tag.
      3. Include the correct import process in the <erp: JobName> tag. E.g. include /oracle/apps/ess/prc/poz/supplierImport,ImportSuppliers if suppliers are being imported or /oracle/apps/ess/prc/poz/supplierImport,ImportSupplierAddresses if supplier addresses are being imported.
      4. List the import parameters in the order specified within the <epr:ParameterList> tag: Import Options (valid values: NEW,ALL,REJECTED), Report Exceptions Only (valid values: N,Y), Batch ID (as specified in CSV data file. Do not include a value if not specified in data file.)
    6. Invoke the ERP Integration Service.
    7. The response of the operation: importBulkData contains the process ID of the job that will load the import data into the interface tables. The process ID of the job that actually imports the data from the interface table into the application is not included, but is available to view from the Import Suppliers UI once the process is scheduled. NOTE: Sample response payload included below:
      image2018-12-18_14-47-57.png?version=1&modificationDate=1545173277000&api=v2

     

    Refer to the following for more details on what this integration service offers:

    1. ERP Integration Services: Automate ERP Inbound Bulk Import Integration
    2. Using External Data Integration Services for Oracle ERP Cloud (Doc ID 2102800.1)

    NOTE: Attached content above in a PDF document.

  • Aishwarya Pawar
    Importing Supplier Bank Accounts using FBDI25.0
    Topic posted November 16, 2018 by Aishwarya PawarSilver Medal: 2,000+ Points, tagged How-To, Import, Supplier Profile Management, Tip in Procurement > Supplier Management public
    Title:
    Importing Supplier Bank Accounts using FBDI
    Summary:
    Importing Supplier Bank Accounts using File-Based Data Import
    Content:

    A supplier's bank accounts can be maintained at the supplier header, address or site levels. While the accounts can be added manually, you can also use file-based data import templates to add new bank accounts for a given supplier or any of its supplier sites.

    The most recent template is available on Oracle Help Center here.

    Here is a screenshot for quick reference:

    image2018-11-14_11-48-58.png?version=1&modificationDate=1542224938000&api=v2

  • Shivani Roy
    Points to consider when importing supplier attachments using...5.0
    Topic posted October 31, 2018 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:

    • 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

    • Use multiple small zip files instead of one large zip file.  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. You can also have multiple zip files under the same batch.
    • 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

  • Aishwarya Pawar
    Where can I find FBDI Import templates for my current...5.0
    Topic posted October 26, 2018 by Aishwarya PawarSilver Medal: 2,000+ Points, tagged How-To, Import in Procurement > Supplier Management public
    Title:
    Where can I find FBDI Import templates for my current quarterly update?
    Summary:
    Step by Step instructions to find FBDI Import templates on Oracle Help Center
    Content:

    File-Based Data Import Templates are used to import supplier data from external sources into Oracle Fusion Procurement Cloud. The templates are routinely enhanced to incorporate new functionality and may differ from one quarterly update to another. These templates are available on the Oracle Help Center and here are the step by step instructions to locate them for a given update. It is recommended that you use templates that correspond to your current update.

    1. Access the Oracle Help Center and navigate to Cloud Documentation.
      image2018-10-22_21-41-59.png?version=1&modificationDate=1540269719000&api=v2
    2. Click on the Applications link that appears on the left.
      image2018-10-22_21-43-5.png?version=1&modificationDate=1540269785000&api=v2
    3. Click on the Procurement link available under Application Services > Supplier Chain Management
      image2018-10-22_15-53-12.png?version=1&modificationDate=1540248792000&api=v2 
    4. Select the quarterly update and then click on the Integrate link that appears on the left.
      image2018-10-22_15-55-5.png?version=1&modificationDate=1540248905000&api=v2
    5. Click on the Get started with file-based data import link. NOTE: You can review the SOAP and REST Services from this page as well.
      image2018-10-22_15-57-4.png?version=1&modificationDate=1540249024000&api=v2
    6. Expand the File-Based Data Imports section.
      image2018-10-22_15-58-19.png?version=1&modificationDate=1540249099000&api=v2
    7. All the import templates available for the update chosen are listed.
      image2018-10-22_16-0-5.png?version=1&modificationDate=1540249205000&api=v2
  • Aishwarya Pawar
    Supplier Import Tips4.7
    Topic posted January 26, 2018 by Aishwarya PawarSilver Medal: 2,000+ Points, tagged How-To, Import, Tip in Procurement > Supplier Management public
    Title:
    Supplier Import Tips
    Summary:
    Tips for importing supplier records using FBDI templates from external sources into Oracle Supplier Model Cloud
    Content:

    Supplier import functionality allows you to mass insert or update supplier records into the supply base. Import records are first loaded into interface tables and then added to the supply base post successful validation. 

    Here are some tips to consider that could help ensure your supplier import processes run successfully:

    Populating FBDI templates

    1. Use #NULL wherever applicable to update an attribute value to blank. E.g. use #NULL to remove Acme Corp. as the Alternate Name.
      Refer to Comments added for every import column header in the FBDI import templates to find useful details such as attribute description, interface table column name, actions supported, UI navigation that can help you identify acceptable values. Also, refer to the Instructions and CSV Generation worksheet for details on how  CSV files should be generated and used to import records.
    2. Use the Batch ID attribute (displayed as a column name in FBDI templates) and the corresponding parameter while submitting an import process, especially if you are importing a large number of import records. This will allow you to process import records in a single import file using multiple processes. Also please note that when no value is provided for Batch ID parameter, only import records that do not have a Batch ID specified will be processed.
    3. You can import contact addresses for an existing contact without importing the contact i.e. it is perfectly acceptable to leave the POZ_SUP_CONTACTS worksheet empty and only populate the POZ_SUPP_CONTACT_ADDRESSES_INT worksheet in the Supplier Contacts Import template.
      OTBI subject area: Supplier Import - Supplier Real Time and related seeded reports can be leveraged to populate supplier import templates starting Release 11. The reports are in a format that resemble the templates and could be used to generate import data that is suitable to be copied over to the templates . For more details refer to the Release 11 training: Supplier Reporting Enhancements.

    Scheduling import processes

    1. While scheduling an import process to import new records, be sure to select the import option of "New". This ensures that the current import process does not attempt to validate existing interface table records that have already been processed and rejected previously.
    2. Ensure that your parent entity exists in the supply base before importing the child entities. E.g. ensure the supplier site exists before importing its site assignments.

    After successful imports

    Empty the interface table of the supplier entity you have successfully imported by running the Purge Supplier Interface Records process immediately after the import. This ensures that interface tables are empty for your subsequent import and the new import process does not attempt to process older records which are no longer relevant. NOTE: This process is available along with the other import processes.