Posts

Posts

  • 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
  • jin hu
    Supplier Contacts -FBDI Error2
    Topic posted August 22, 2019 by jin huSilver Medal: 2,000+ 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:
  • Aishwarya Pawar
    Importing Supplier Bank Accounts using FBDI25.0
    Topic posted November 16, 2018 by Aishwarya PawarGold Medal: 3,500+ 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

  • Dave Dengate
    Supplier Import Spreadsheet2
    Topic posted August 16, 2017 by Dave DengateBlue Ribbon: 750+ Points, tagged Import, Supplier Creation, Supplier Profile Management, Supplier User Account in Procurement > Supplier Management public
    Title:
    Supplier Import Spreadsheet
    Summary:
    Amending fields via the Supplier Import Spreadsheet
    Content:

    Does anyone know how to 'delete' a field (in our case the Alternate name) when using the 'Update' feature within the Supplier Import Spreadsheet ? If I enter a space character it just ignores the change. We could change the unwanted ones to have the text of 'Null' or 'Empty' but this is not an elegant solution.

    Regards

    Dave

     

  • 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 SinghSilver Trophy: 7,500+ 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

     

  • 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

  • Ramesh JC
    Supplier Bank Account Import1
    Topic posted September 15, 2016 by Ramesh JCSilver Trophy: 7,500+ Points, tagged Import in Procurement > Supplier Management public
    Title:
    Supplier Bank Account Import
    Summary:
    Import supplier bank account information using FBDI template.
    Content:

    We would like to import bank accounts along with other supplier entities. However, we cannot find any FBDI templates that have the bank account information. How can we import supplier bank accounts?

    [This thread is transferred from customer support forum]

  • Ramesh JC
    Supplier Import Automation1
    Topic posted September 15, 2016 by Ramesh JCSilver Trophy: 7,500+ Points, tagged Import in Procurement > Supplier Management public
    Title:
    Supplier Import Automation
    Summary:
    Automated process to load data for supplier import.
    Content:

    Using the supplier import process to bulk load supplier data is a multi step process. Is there any service to automate the entire process?

    [This thread is transferred from customer support forum]

  • Aishwarya Pawar
    Use ERP Integration Service to automate Supplier Import5.0
    Topic posted December 20, 2018 by Aishwarya PawarGold Medal: 3,500+ 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.