Enforce Numeric Format Validation for Manual Lot Entry (DDMMYYYY Format) in Inventory Transaction
In Oracle Fusion Inventory Management, users currently have the ability to manually enter alphanumeric lot numbers during inventory transactions such as PO receiving, miscellaneous receipts.
However, our organization has a critical business requirement to enforce strict numeric-only lot numbers, specifically in the format DDMMYYYY (date-based format).
This standard is required for:
- Simplified traceability
- Batch reporting
- Integration with external systems that rely on numeric-only lot references
- Oracle Fusion does not provide a configuration or validation rule to restrict lot entry to numeric-only.
- As a result, users are able to enter invalid formats (e.g.,
A123,LOT2025,2024BATCH) which causes downstream issues in quality, reporting, and integrations.
Tagged:
0