My Oracle Support Banner

ORA-01400: cannot insert NULL into ("ASAP"."CIRCUIT"."SERVICE_TYPE_CATEGORY") when invoking the startOrderByKeyRequest XML API method (Doc ID 739307.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Communications MetaSolv Solution - Version 6.0.13 and later
Information in this document applies to any platform.

Symptoms

An ORA-01400 error occurs invoking the startOrderByKeyRequest XML API method.  The problem occurs for Execute Finish Order on a PSR order via the XML API when the order contains products that require a record on the CIRCUIT table (Telephone Numbers, Circuits, etc).  Below are the details of the error:

Changes

Customers upgrading from Oracle 9i to 10g or new database instances using Oracle 10g.

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
Changes
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.