MFG_LOOKUPS Err ORA-01722 Invalid Number

(Doc ID 1491963.1)

Last updated on MARCH 19, 2018

Applies to:

Oracle Project Manufacturing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run queries on the MFG_LOOKUPS view, see a "TO_NUMBER (lv.lookup_code) lookup_code" but in fnd_lookup_values some of those lookup_code are not numbers like PJM type values.

Example non-number values:
LOOKUP_TYPE LANG LOOKUP_CODE
PJM_INQUIRY_ACTIONS FRC 10EXP
PJM_INQUIRY_ACTIONS US 10EXP
PJM_INQUIRY_ACTIONS FRC 11COMM
PJM_INQUIRY_ACTIONS US 11COMM

ERROR
ORA-01722 invalid number
Error at line: 1

STEPS
1. Execute queries in SQL like the following : select * from APPS.MFG_LOOKUPS order by 1
2. Receive the error.

Changes

 

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