My Oracle Support Banner

startOrderByKeyRequest XML API Error; nullError Code 39990:Miscellaneous Error: Value [CUST_ACCT_NBR] with length of 20 exceeds the maximum length of 12 for the column ALLTEL_BILLING_NUMBER in table ASAP.CIRCUIT (Doc ID 1911806.1)

Last updated on NOVEMBER 19, 2018

Applies to:

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

Symptoms

The startOrderByKeyRequest XML API method throws the following exception for PSR orders having an ASAP.CUST_ACCT.CUST_ACCT_NBR value greater that 12 characters.  Note that the ASAP.CIRCUIT.ALLTEL_BILLING_NUMBER is defined as as VARCHAR2(12) whereas the ASAP.CUST_ACCT.CUST_ACCT_NBR column is defined as VARCHAR2(20).



ERROR RESPONSE
----------------------------------------------



BUSINESS IMPACT
-----------------------
Due to this issue, the startOrderByKeyRequest XML API method cannot be invoked for PSR orders related to Customer Account Numbers having a value greater than 12 characters where a circuit shell will be created which is dependent on the ordered item types.


WORKAROUND
-----------------------
Open the PSR order in the GUI and click the "Finish Order" link. This will create the circuit shell record.

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
References


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.