We are a utility organization that has implemented smart meters as serialized assets in WACS to ensure traceability between each meter and its assigned premise. While this provides the asset-level granularity we need, it has also introduced significant bottlenecks in our inventory operations.
Currently, we are unable to efficiently mass issue or transfer these serialized meters whether from storeroom to field, or between storerooms due to limitations in the WACS search and selection functionality. Specifically, the system allows processing of only one asset at a time when serial numbers are random, and there is no option to select a range or upload a list for bulk issuance. This process is extremely time-consuming and operationally impractical.
As suggested by Oracle support SR 3-41515524131, we attempted a configuration-based workaround by increasing the number of asset lines returned in the interface from the default 25 up to 999. However, even at a limit of 100, the page loading performance degrades noticeably. When users click the "Issue Asset" button, the response time increases significantly, and navigating through large inventories becomes challenging.
For example, in scenarios where we have 10,000+ inventory items and a user needs to issue 50 specific serialized assets, they are forced to page through results multiple times. Given the serial numbers are random, it’s nearly impossible to locate the desired items quickly. Additionally, if a user attempts to search for a specific serial number and it isn’t found, the only option is to close the window and restart the process adding further delay and frustration.
We are reaching out to understand how other WACS customers are managing serialized asset issuance at scale and whether any alternative tools, extensions, or practices are being used to overcome this challenge. A more robust and efficient solution is critical for maintaining operational efficiency across our meter rollout and field logistics workflows.
Suggested Enhancements for WACS Serialized Asset Handling
1. Bulk Serial Number Upload Capability
- Description: Enable users to upload a list of serial numbers (via CSV, Excel, or text input) for mass issuance or transfer.
- Benefit: Eliminates the need for paging through large inventories and manually selecting items.
- Use Case: Issue or transfer 50+ specific meters with known serial numbers in seconds.
2. Advanced Filtering Options
- Description: Add filtering by:
- Serial number patterns (prefix/suffix/contains)
- Meter status (In Store, In repair)
- Benefit: Helps narrow down results in large inventories (10K+ items) without relying on serial order.
3. Range Selection for Serialized Items
- Description: Support selection of serial numbers using a defined range (e.g., 1000001 to 1000050).
- Benefit: Simplifies bulk operations where serials follow semi-sequential patterns.