How To Fix The Null Value In the Field HZ_LOC_ASSIGNMENTS.CREATED_BY_MODULE? (Doc ID 1270883.1)

Last updated on OCTOBER 19, 2016

Applies to:

Oracle Trading Community - Version 12.0 and later
Information in this document applies to any platform.


You are trying to update the CREATED_BY_MODULE field to a value defined in FND_LOOKUP table via update statement:

Set Created_By_Module = 'Customer_Interface_FIX'
where created_by_module is NULL;

and get the error:

ORA-01732 data manipulation operation not legal on this view

When you push F4 button,  you get "APPS.ZX_LOC_ASSIGNMENTS_V"


Upgraded to Release 12


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