Database Administration (MOSC)

MOSC Banner

ORA-00904: "ITEM_KEY" : invalid identifier

edited Dec 16, 2020 12:17PM in Database Administration (MOSC) 4 commentsAnswered ✓

Hi,

On 11.2.0.4 I have :

desc apps.wf_item_attribute_values

Nom        NULL ?  Type        

----------------- -------- ------------------ 

ITEM_TYPE     NOT NULL VARCHAR2(8)     

ITEM_KEY     NOT NULL VARCHAR2(240)    

NAME       NOT NULL VARCHAR2(30)    

TEXT_VALUE         VARCHAR2(4000)   

NUMBER_VALUE        NUMBER       

DATE_VALUE         DATE        

EVENT_VALUE        APPS_NE.WF_EVENT_T 

SECURITY_GROUP_ID     VARCHAR2(32)    

INST_ID          NUMBER 


Then I try to update:

update apps.wf_notification_attributes set TEXT_VALUE='xxxx/OA_HTML/AppsLogin?requestUrl=APPSHOMEPAGE&cancelUrl=https%3A%2F%2Fxxx%3A4483%2FOA_HTML%2FAppsLogin' where ITEM_TYP='UMXLHELP' and ITEM_KEY=2280;

ORA-00904: "ITEM_KEY" : invalid identifier

I tried even with and ITEM_KEY='2280'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center