java.lang.Exception when expired product catalog supplied in queryOrderManagementRequest getProductCatalog XML API (Doc ID 1299168.1)

Last updated on MARCH 10, 2011

Applies to:

Oracle Communications MetaSolv Solution - Version: 6.0.16 and later   [Release: 6.0.16 and later ]
Information in this document applies to any platform.

Symptoms

Execute the queryOrderManagementRequest getProductCatalog for a Product Catalog item that has the TO_EFF_DT not null on the ITEM_SPEC table and the XML API returns the following error message:

<ns:errorResponse xmlns:ns="http://www.openuri.org/">
    <ns:errorMessage> #### QueryOrderManagementTest:Tue Oct 06 12:11:53 EDT 2009;Product Catalog data not found for Spec Id : 15412</ns:errorMessage>
    <ns:exceptionToString> #### java.lang.Exception: QueryOrderManagementTest:Tue Oct 06 12:11:53 EDT 2009;Product Catalog data not found for Spec Id : 15412</ns:exceptionToString>
</ns:errorResponse>

Steps To Reproduce:
  1. Populate the queryOrderManagementRequest -> getProductCatalog XML API with a SPEC_ID that has the TO_EFF_DT set to a value other than null.
    <clientRequest xmlns="http://www.openuri.org/" xmlns:ord="http://www.metasolv.com/MIP/OrderManagementAPI" xmlns:ord1="http://www.metasolv.com/MIP/OrderManagementEntities" xmlns:com="http://java.sun.com/products/oss/xml/Common" xmlns:mip="http://www.metasolv.com/MIP/MIPCommonEntities" xmlns:ser="http://www.metasolv.com/MIP/ServiceEntities">
      <ord:queryOrderManagementRequest>
        <ord:queryValue>
          <ord:getProductCatalog>
            <ord:productCatalogPolicy>
              <mip:customAttribute>false</mip:customAttribute>
            </ord:productCatalogPolicy>
            <ord:criteria>
              <mip:specificationKey>
                <ser:serviceSpecificationPrimaryKey>12345</ser:serviceSpecificationPrimaryKey>
              </mip:specificationKey>
              <mip:exportInd>false</mip:exportInd>
            </ord:criteria>
          </ord:getProductCatalog>
        </ord:queryValue>
      </ord:queryOrderManagementRequest>
    </clientRequest>

Business Impact:
Unable to export Product Catalog items that have been to effective dated.

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