Error ORA-01400: Cannot Insert NULL on Configuration Save (Doc ID 2043500.1)

Last updated on JULY 20, 2017

Applies to:

Oracle Configurator - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.25.45 version, Runtime UI

When attempting to save a configuration, the following error occurs. This error occurs for all models in the system, when saving a called Configurator session from sales order.

ERROR
-----------------------
oracle.apps.cz.dio.config.IBTransactionException: ORA-01400: cannot insert NULL into ("CZ"."CZ_CONFIG_EXT_ATTRIBUTES"."CREATED_BY")

at oracle.apps.cz.cio.Configuration.saveInternal(Configuration.java:3770)
at oracle.apps.cz.cio.Configuration.saveNew(Configuration.java:3566)
at oracle.apps.cz.service.ConfiguratorService.save(ConfiguratorService.java:1495)
at oracle.apps.cz.service.ConfiguratorService.save(ConfiguratorService.java:1525)
at oracle.apps.cz.service.ConfiguratorService.closeConfiguration(ConfiguratorService.java:1619)
at oracle.apps.cz.service.ConfiguratorService.processMessage(ConfiguratorService.java:442)
at oracle.apps.cz.service.ConfiguratorServiceLocal.onMessage(ConfiguratorServiceLocal.java:18)
at oracle.apps.cz.runtime.PageController.postServiceMessage(PageController.java:535)
at oracle.apps.cz.runtime.PageController.processEvent(PageController.java:1188)
at oracle.apps.cz.runtime.PageController.closeConfiguration(PageController.java:857)
at oracle.apps.cz.runtime.oa.server.CZApplicationModuleImpl.processEventInternal(CZApplicationModuleImpl.java:2200)
at oracle.apps.cz.runtime.oa.server.CZApplicationModuleImpl.processEvent(CZApplicationModuleImpl.java:2172)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. In Sales online
2. Configure a line
3. Select valid options for active configuration
4. Finish and save
5. Error occurs

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