My Oracle Support Banner

Unable to Find Serial Numbers While Performing Some Intransit Receipts - FRM-40212: Invalid value for field FM_SERIAL_NUMBER (Doc ID 2098966.1)

Last updated on MAY 01, 2021

Applies to:

Oracle Inventory Management - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Unable to find the serial numbers while performing some (not all) Intransit Receiving Transactions (Interorg transfer and Internal Order Receipts).

       ERROR:  "FRM-40212: Invalid value for field FM_SERIAL_NUMBER"

- Running 'Generate Serials' concurrent program for the item in the receiving org does not help.
- No changes in the Item Serial number set up exists after shipping.
- Inventory Miscellaneous Receipt transactions for same serial numbers work correctly.

Steps:

  1. Create an Item with purchasing template and assign to M1 and M2. Serial control of item at M1 should be plain and M2 should be At receipt or Pre-specified.
  2. Create Internal Requisition in M1
  3. Run Create Internal Order Program, Order Import Program, Pick Release and Ship confirm the ISO in M2.
  4. Try Performing Intransit Receipt in M1 for the requisition created in M1. System will allow to enter serials.
  5. Error "FRM-40212: Invalid value for field FM_SERIAL_NUMBER" occurs when Clicking Serial number list of value (lov) in Receiving form > Serial Entry window

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.