Stock Report Integration
This integration maintains the study drug inventory in your Oracle Clinical One Platform studies.
Table 2-24 Stock Report integration details
| Specification | Details |
|---|---|
| Data flow | Inbound from SAP to Oracle Clinical One Platform via Oracle sFTP |
| Frequency | Scheduled (configurable) |
| Data type | Unblinded and cumulative |
Integration workflow
- SAP generates a stock report file and posts it on the Oracle sFTP server at a configured location.
- The integration, using the time stamp, determines, by study, which is the latest file at the configured sFTP location.
- The data is then imported into Oracle Clinical One Platform. The manufacturing lot is created for a given kit type with the
corresponding quantity, material number, and expiration date. The
manufacturing lot is associated with the corresponding blinded lot.
Note:
If a manufacturing lot already exists, the information in Oracle Clinical One Platform is updated as per the details in the stock report file that is being processed. - If a manufacturing lot exists in Oracle Clinical One Platform but is missing in the stock report, the quantity for such lots is updated to zero. This ensures they are not available when a shipment request is generated.
- Also, the blinded lots in Oracle Clinical One Platform are updated with the countries and the corresponding DNS (do not ship) and DNC (do not count) days calculated using the lot’s expiration date.
Parent topic: SAP Supply Management System