JTM Master Concurrent Program With 'Lookup' Parameter Completed With Error "ORA-01400: cannot insert NULL into ("CSM"."CSM5_MTL_PARAMETERS_ACC".''ORGANIZATION_ID")" (Doc ID 2122016.1)

Last updated on JUNE 25, 2024

Applies to:

Oracle Mobile Field Service - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
JTM Master Concurrent Program with LOOKUP parameter completed with error:

Error message from CSM_MTL_PARAMETERS_EVENT_PKG.REFRESH_ACC: Error in CSM_MTL_PARAMETERS_EVENT_PKG.Refresh_Acc: -1400:ORA-01400: cannot insert NULL into ("CSM"."CSM5_MTL_PARAMETERS_ACC".''ORGANIZATION_ID").

EXPECTED BEHAVIOR
Program should complete without any error.

STEPS
1. Login to Oracle APPS.
2. R) Mobile Field Service Administrator > Run the JTM Master Concurrent Program with LOOKUP parameter.
3. Program completed with the above error.

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

Cause

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

JTM Master Concurrent Program With 'Lookup' Parameter Completed With Error "ORA-01400: cannot insert NULL into ("CSM"."CSM5_MTL_PARAMETERS_ACC".''ORGANIZATION_ID")" (Doc ID 2122016.1)

Applies to:

Symptoms

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!