Searching WIP Jobs results in Error FRM-40202: Field must be entered (Doc ID 2175423.1)

Last updated on AUGUST 02, 2017

Applies to:

Oracle Work in Process - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Work Order Definition

User wants to search discrete job through discrete job summary
form by using F11. But when doing the same , it gives the error as FRM-40202 Filed must be entered
User needs to clear the record every time in order to display the results.
This used to work in Rel 11i.


ERROR
-----------------------
FRM-40202: Field must be entered.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Steps taken in both Rel 11i and Rel 12:

  In Rel 11i:
  1. Work In Process -> Discrete -> Discrete Jobs.
  2. Close Find Discrete Jobs window.
  3. Navigate to Discrete Jobs Summary window.
  4. Click inside job text field
  5. Press Ctrl + F11 (execute query)
  6. Result -> Displays all jobs in Discrete Jobs Summary window in 11i.

  In Rel 12:
  1. Work In Process -> Discrete -> Discrete Jobs.
  2. Close Find Discrete Jobs window.
  3. Navigate to Discrete Jobs Summary window.
  4. Click inside job text field
  5. Press Ctrl + F11 (execute query)
  6. Result -> In R12, displays an error message (FRM-40202: Field must be entered) in the task bar.
  7. Click Ok on the caution window (Clear 1 records?).
  8. Press Ctrl + F11 (execute query).
  9. Result -> Displays all discrete jobs in Discrete Jobs Summary window in R12.



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms