Inquiry on Triggering Actions Based on Lot/Serial Dates for Recertification
Summary: We are currently working on a requirement from our client that involves the recertification of lot/serial controlled items. Specifically, we need to trigger certain actions based on the dates associated with these lot/serial numbers (e.g., expiration date, recertification date).
Could you please provide guidance on the following:
- Is it possible to configure Oracle Inventory or any related module to automatically trigger actions or alerts based on the dates of lot/serial controlled items?
- What are the best practices for setting up such triggers or workflows within Oracle Cloud Applications?
- Can custom PL/SQL procedures be used to check lot/serial dates and trigger actions, and if so, are there any recommended approaches or examples you can provide?
Tagged:
0