My Oracle Support Banner

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 04, 2019

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.