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 SEPTEMBER 18, 2017

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

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