AI Agent: Inventory Expiry Assistant

New in 26A, the Inventory Expiry Assistant agent is a powerful AI-driven assistant designed for warehouse supervisors and inventory managers to proactively monitor and manage inventory shelf life. This intelligent tool helps identify, isolate, and secure lot-controlled goods that have expired or are nearing expiration, ensuring only safe and compliant inventory is processed for customer orders.

This agent provides the following features:

  • Real-Time Expiration Monitoring - Instantly identify expired inventory or items at risk of expiring across Reserve, Active, and Outbound areas using a workflow agents.
  • Interactive Chat -  Users can query the AI Agent with specific requests. For example, to list expired inventory by location, date range, item, or storage area - and get instant, relevant responses.
  • Container Locking - Through the chat interface, users can apply locks to individual or multiple containers to prevent allocation. The Agent ensures that only containers with correctly configured locks are secured and notifies users if a lock cannot prevent allocation.

With the Inventory Expiry Assistant, you can significantly reduce the risks of shipping expired products, ensure regulatory compliance, and optimize warehouse operations with AI-powered efficiency.

Before you use the AI Agent, you have to complete the key configurations in the Steps to Enable and Configure section. Once you complete all configurations, you can launch the AI Agent and use prompts to perform specific tasks.

Here are some sample prompts/questions that could be useful when interacting with the Inventory Expiration Assistant:

Sample Prompts/Questions Sample Response
Find me LPNs in area A that are expired
  • There are 25 LPNs in area A that are expired. Here are the LPN numbers: xxxx
  • There are no expired LPNS in area A. However 3 LPNs are about to expire in 2 days: xxx

List the Active locations with Expired Inventory (OR) 

 There are 458 LPNs with the expired inventory. Here are the first few by earliest expiry listed below: Container Number: CSPMM141890011 Item/SKU: EXP011 Expiry Date: 2019-10-31 Location: R0152A1

List the Inbound LPNs with inventory that will expire in the next 3 days

 There are no LPNs that are expiring in the next 3 days.

List the Outbound LPNs with expired inventory from last month

 There are 395 LPNs with the expired inventory. Here are the first few by earliest expiry listed below: Container Number: CSPMM00000704 Item/SKU: TSTITM58 Expiry Date: 2017-06-02 Location: Container Number: OBOR440404 Item/SKU: TSTITMBE1 Expiry Date: 2018-01-17 Location:

Steps to Enable and Configure

KEY CONFIGURATIONS

To connect with the Fusion AI Agent Studio app, do the following:

  1. On the SAAS App Configuration UI, click Create.
  2. From the App Name drop-down list, select AI-AGENT-STUDIO.

SaaS App Configuration

SaaS App Configuration

  1. Enter the mandatory Base URL, App Parameter, etc fields described in the table below.

Refer to the following table for each parameter’s meaning and the format required.

NOTE: Prerequisite – make sure FA IDCS Oauth2 with grant-type JWT confidential app is configured.

Field Name Description Details
Base URL FA AI Studio Base URL

Fusion base URL where AI Studio is hosted.

https://xxx.fa.us6.oraclecloud.com
App parm3 IDCS Token URL

https://idcs-xxx.identity.oraclecloud.com:443/oauth2/v1/token
App parm4 Client id of the WMS confidential app in FA IDCS

Enter the Client ID. In your OCI Instance follow the path “Identity and Security” --> Domains --> select the domain that hosts the OIC instance. From the Domains screen, click “Oracle Cloud Services” tab. Search or browse to your OIC application, click to open.
App parm8

Private Key for the WMS confidential app in FA IDCS 

A valid RSA private key. This is used to sign the access token request.

NOTE: App parm8 is encrypted in the database and not displayed in the grid view (but it is editable).
App parm9 Public x509 cert 

corresponding to private key entered in parm8 field

NOTE: SaaS App configurations can be created for Facility * (one AI Agent configuration per company).

  1. Click Save.

To add the Inventory Expiry Assistant AI Agent to the list of available AI Agents, do the following:

  1. Once you’ve added the AI Agent Configuration UI from Modules, you’ll be able to access it from Redwood Desktop -> Configuration Tab or -> searching from Ask Oracle.
  2. From the AI Agent Configuration UI, click Create.
  3. Enter your AI Agent Name and Agent Team Code.

NOTE: Agent Team Code must be unique to the company and match the agent team code in Fusion AI Agent Studio.

  1. Click Save.

REQUIRED GROUP CONFIGURATION

Additionally, you need to assign access to agents by assigning them to Groups. To add an AI Agent to a group, do the following:

  1. From the Redwood Groups UI, select a group for which you want to assign the AI Agent.
  2. Click More Actions (elipses button to the right of the Refresh button) (…), then AI Agents action button. 
  3. On the AI Agents screen, click Create.
  4. To assign an AI Agent to the selected group, select an AI Agent from the drop-down list.
  5. Click Save.

To access the Inventory Expiry Assistant AI Agent after it is configured: 

  1. From the User drop-down, select Try the New Redwood Experience.
  2. Hover your cursor over the Ask Oracle button, and an elipses slide-out button will appear. Click the elipses button.

From Redwood Mobile, you can click the Ask button to launch the AI Agent pane.

NOTE: If only one AI Agent is configured, the system launches the configured AI Agent.

  1. From the list, select the Inventory Expiration Assistant AI agent and enter a prompt to get started.

NOTE: For information on using AI Agent Studio, see How do I use AI Agent Studio?