AddComplianceData
This operation will add compliance data for a single supplier. If the supplier does not already have compliance data, the new data is created. If the supplier already has compliance data, it is updated.
Execute
This stored procedure includes a #TEMP table input. Below is an example execution.
The temporary table must be defined and used within the same connection. Closing the connection will clear out any temporary tables in memory.
INSERT INTO Evidences#TEMP (UniqueId, Source, Provider, PenaltyAmount, IsoCurrencyCode, Url, EffectiveStartDate, EffectiveEndDate, SupportingIndicatorStatus, Note) VALUES ('1', 'Test', 'providerName', '1000.5', 'USD', 'https://www.test.com', '2020-01-01', '2020-05-01', 'SANCTION', 'summary')
INSERT INTO Evidences#TEMP (UniqueId, Source, Provider, PenaltyAmount, IsoCurrencyCode, Url, EffectiveStartDate, EffectiveEndDate, SupportingIndicatorStatus, Note) VALUES ('2', 'example', 'anotherProvider', '750.25', 'EUR', 'https://www.test.com', '2021-03-15', '2021-08-15', 'WATCHLIST', 'description')
EXECUTE AddComplianceData
SMVendorId = 'S10666588',
SanctionIndicatorStatus = 'VIOLATION_FOUND',
WatchlistIndicatorStatus = 'VIOLATION_NOT_FOUND',
Note = 'Note.',
Evidences = 'Evidences#TEMP',
Evidences temporary table schema info:
Column Name | Type | Required | Description |
UniqueId | string | False | An ID that you provide to uniquely identify the evidence data. This isn't a mandatory field. You only need to provide this ID if you want to have the ability to update it later. |
Source | string | False | The source is the origin of the evidence about the supplier. An example is when there are multiple articles supporting the evidence about the supplier, only the most relevant source is shown. You can use the information in the source to find articles from other sources. The URL for a source must start with https or http. |
Provider | string | False | The provider of the compliance data for the supplier. Your provider can have evidence data from multiple sources. |
PenaltyAmount | decimal | False | The currency amount of any penalty applied to the supplier for the violation. |
IsoCurrencyCode | string | False | The ISO 4217 currency code that represents the alphabetic currency for the penaltyAmount. |
Url | string | False | The URL used to provide proof of the evidence. The URL is a clickable link. An example is a link to an article. |
EffectiveStartDate | date | False | The date the compliance violation started. |
EffectiveEndDate | date | False | The date the compliance violation ended. |
SupportingIndicatorStatus | string | False | The fields from the risk configurations such as sanction and watchlist. |
Note | string | False | Any note you add about the evidence of the supplier's violation. You can add a note of up to 3000 characters. |
Input
Name | Type | Description |
Realm | String | The requested realm. |
SMVendorId | String | A unique ID that SAP Ariba assigns automatically. |
SanctionIndicatorStatus | String | The status that tells you if a sanction was found for the supplier.
The allowed values are VIOLATION_FOUND, VIOLATION_NOT_FOUND, VIOLATION_EXPIRED, NOT_SCREENED. |
WatchlistIndicatorStatus | String | The status that tells you if the supplier is on a watchlist.
The allowed values are VIOLATION_FOUND, VIOLATION_NOT_FOUND, VIOLATION_EXPIRED, NOT_SCREENED. |
SupplierScreenedAt | Date | The date you screened the supplier for compliance data. |
Note | String | Any note you add when you screen the supplier. You can add a note of up to 3000 characters. |
Evidences | String | Evidence data. |
Result Set Columns
Name | Type | Description |
Success | String | Indicates whether or not the operation was successful. |
Details | String | Any extra details on the operation's execution. |