Performance Problem With QueryInventoryManagementRequest XML API Method (Doc ID 2011980.1)

Last updated on MAY 20, 2015

Applies to:

Symptoms

The queryInventoryManagementRequest XML API performance is slow for the initial execution which often times out. Subsequent executions respond in a few seconds. This process is generally executed early at the beginning of the work day.

Below is a sample XML to query for 2 TNs with specified values for NPA and Reservation ID.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

<inv:queryInventoryManagementRequest>
<inv:queryValue>
<inv:queryTelephoneNumberInventoryValue>
<inv1:telephoneNumberSearchCritera>
<inv1:inventorySubTypeCd>301</inv1:inventorySubTypeCd>
<inv1:strucFmt>
<cus:sfType>TN</cus:sfType>
<cus:name>TN-US</cus:name>
<cus:structureFormatComponents>
<cus:id>46</cus:id>
<cus:name>NPA</cus:name>
<cus:componentType>G</cus:componentType>
<cus:value>920</cus:value>
<cus:discriminator>string</cus:discriminator>
</cus:structureFormatComponents>
</inv1:strucFmt>
<inv1:locationCode/>
<inv1:reservation>83</inv1:reservation>
<inv1:networkAreaCity>0</inv1:networkAreaCity>
<inv1:networkAreaStateProv>0</inv1:networkAreaStateProv>
<inv1:networkAreaCountry>0</inv1:networkAreaCountry>
<inv1:customerAccountKey>
<com:applicationDN>string</com:applicationDN>
<com:type>string</com:type>
<cus1:customerAccountPrimaryKey>0</cus1:customerAccountPrimaryKey>
</inv1:customerAccountKey>
<inv1:quantity>2</inv1:quantity>
<inv1:checkOutIndicator>true</inv1:checkOutIndicator>
<inv1:statusSeq>
<inv2:telephoneNumberStatus>tnsReserved</inv2:telephoneNumberStatus>
</inv1:statusSeq>
<inv1:telnbrTypeCd>
<inv2:telephoneNumberType>tntWTN</inv2:telephoneNumberType>
</inv1:telnbrTypeCd>
<inv1:tniCategoryId>0</inv1:tniCategoryId>
<inv1:tniSubcategoryId>0</inv1:tniSubcategoryId>
</inv1:telephoneNumberSearchCritera>
</inv:queryTelephoneNumberInventoryValue>
</inv:queryValue>
</inv:queryInventoryManagementRequest>

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.