MFG_LOOKUPS Err ORA-01722 Invalid Number (Doc ID 1491963.1)

Last updated on JANUARY 26, 2016

Applies to:

Oracle Project Manufacturing - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance 12-AUG-2014***

Symptoms

On : 12.1.3 version, SUPPORT

When attempting to run

MFG_LOOKUPS view does a TO_NUMBER (lv.lookup_code) lookup_code but in fnd_lookup_values some of those lookup_code aren't numbers

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
-----------------------
The issue can be reproduced at will with the following steps:

Run the following

select *
from APPS.MFG_LOOKUPS
order by 1

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