MFG_LOOKUPS Err ORA-01722 Invalid Number
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.
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
ORA-01722 invalid number
Error at line: 1
1. Execute queries in SQL like the following : select * from APPS.MFG_LOOKUPS order by 1
2. Receive the error.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms