ORA-1402 and FRM-40735 Occurs While Opening Lot Based Job Form

(Doc ID 2314369.1)

Last updated on OCTOBER 10, 2017

Applies to:

Oracle Shop Floor Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Problem Statement
ORA 01403 and FRM-40735 error occur while creating Lot Based Job in Japanese session

Error
ORA-1403:No Data found FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-6502

Steps to Reproduce

  1. Login as 'Shop Floor Manager' responsibility.
  2. Navigate to 'Lot Based Job' menu and select organization where WSM is disabled on organization parameter. Then the message "Organization is not enabled for Shop Floor Management." is shown.
  3. After performing step 2, user changes to the correct organization where WSM is enabled (through change organization menu).
  4. And then select 'Lot Based Jobs' menu.
  5. Error message is shown and form can not be opened.

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