ORA-01400: cannot insert NULL into ("ASAP"."CIRCUIT"."SERVICE_TYPE_CATEGORY") when invoking the startOrderByKeyRequest XML API method
Last updated on JULY 23, 2013
Applies to:Oracle Communications MetaSolv Solution - Version 6.0.13 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Jul-2013***
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:
Customers upgrading from Oracle 9i to 10g or new database instances using Oracle 10g.
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