My Oracle Support Banner

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

Last updated on MAY 06, 2024

Applies to:

Oracle Communications MetaSolv Solution - Version 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.

Business Impact:

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

Changes

 

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
References


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