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.

Symptoms

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

Update HZ_LOC_ASSIGNMENTS
Set Created_By_Module = 'Customer_Interface_FIX'
where created_by_module is NULL;

and get the error:

Error:
ORA-01732 data manipulation operation not legal on this view


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

Changes

Upgraded to Release 12

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