Deleting Suppliers and Sites

The deletion of supplier and site accounts is restricted to retailer administrator users with the Power Administrator authority profile only. There are two methods available:

  1. The Delete Suppliers and Delete Sites options in the Admin area allow for the deletion of accounts that have been created in error or were created and never used, that is, where there are no references to related records such as Users, Contacts, or Audits, and so on. For more information, see the Oracle Retail Supply Chain Collaboration Cloud Service Administration Guide.

  2. The Delete action within the Site record allows for the deletion of individual Site accounts. In this case, the deletion is permitted where there are references to certain types of related records. Deletion of the last remaining Site record also deletes the Supplier record.

    Deleting Site and Supplier records using this method will automatically remove the associated Contacts, Users, and references in Alerts, Documents, and Announcements/News Items. Deletion is not permitted if the account has other types of records associated to it (Audits/Visits, Assessments, or links to Processes).

    The records are soft deleted and are excluded from list views and data extracts. Filters must be applied to exclude them from reports and data retrieved by the APIs:

    • To exclude the soft deleted records from reports, it is necessary to add the Deleted column as a filter to the relevant Report Data Source, Report Design, and Report Schedule records.

    • The API XML contains a deleted element (set to true if deleted). To exclude soft deleted records, it is necessary to use a softDelete=false parameter when calling the API. For example:

      /creations-core/services/rest/site?softDelete=false

    The Delete action is available when the Site record is in edit mode. It first checks for any records that will prevent deletion and presents a message listing any that have been found, otherwise a confirmation prompt to continue. A batch job is submitted to handle the deletion processing, as follows:

    • A further check is made for any references that will prevent deletion. If any are found, the details are logged against the batch job and it is ended.

    • Contacts associated to the site which are not associated to another site or the supplier are deleted.

    • Any Site User or All Sites User type Users that are associated to the site that are not associated to another site are deleted.

    • Any Alert Responses related to the site are deleted.

    • Any references to the site in the Reader Log and Accept Log of any Library Documents are removed.

    • Any references to the site in the Reader Log and Accept Log of any Announcements/News Items are removed.

    • Any references to the site are removed from the Favorites, Recent Items, and Assignments/Tasks lists.

    • The site is deleted.

    • If deleting the supplier's only site, the same steps are applied to the Supplier record, before deleting that record.

    The deletion processing will do all or none, in that if any one part of the deletion cannot be completed for a Site, the processing will roll-back so that none of the deletion is done for the Site. If any records cannot be deleted due to record locks, the process will automatically retry per the standard batch job record lock handling, with details of the locked record logged against the batch job.

Note:

If integrating with Merchandising and if a site is soft deleted, it may continue to show Supplier Evaluation scores in the Merch dashboard, but will no longer have updates sent. A business process should be established for deleting or deactivating the corresponding accounts in Merchandising, as appropriate.