My Oracle Support Banner

OSM XMLAPI Query Request Not Returning Order Data (Doc ID 2720069.1)

Last updated on OCTOBER 16, 2020

Applies to:

Oracle Communications Order and Service Management - Version 7.3.5.0.0 and later
Information in this document applies to any platform.

Symptoms

OSM XMLAPI query request not returning order data


In production we have noticed XMLAPI functionality is not returning order data.

Request :
<Query.Request xmlns="urn:com:metasolv:oms:xmlapi:1">
   <FlexibleHeaders>
       <FlexibleHeader namespace="TheCompany_Solution" path="/WorkOrder/WorkOrderExtension/ReferencedWorkOrder/ID/Id"/>
       <FlexibleHeader namespace="TheCompany_Solution" path="/combiningKey"/>
   </FlexibleHeaders>
   <Field namespace="TheCompany_Solution" path="/WorkOrder/WorkOrderExtension/ReferencedWorkOrder/ID/Id">****EC.SomeCharactersQC</Field>
   <Field namespace="TheCompany_Solution" path="/combiningKey">****123456</Field>
</Query.Request>

Response :
<Query.Response xmlns="urn:com:metasolv:oms:xmlapi:1">[[
    <Header>
        <_order_seq_id desc="Order ID"/>
        <_order_hist_seq_id desc="Order History ID"/>
        <_order_state desc="Task State"/>
        <_execution_mode desc="Execution Mode"/>
        <_task_id desc="Task Name"/>
        <_order_source desc="Source"/>
        <_order_type desc="Order Type"/>
        <_current_order_state desc="Order State"/>
        <_target_order_state desc="Target Order State"/>
        <_reference_number desc="Ref. #"/>
        <_priority desc="Priority"/>
        <_date_pos_created desc="Order Creation Date"/>
        <_requested_delivery_date desc="Requested Delivery Date"/>
        <_expected_start_date desc="Expected Start Date"/>
        <_expected_duration desc="Expected Duration"/>
        <_user desc="User"/>
        <_process_status desc="Process Status"/>
        <_date_pos_started desc="Started"/>
        <_compl_date_expected desc="Expected Order Completion Date"/>
        <_ord_completion_date desc="Completed Date"/>
        <_grace_period_completion_date desc="Expected Grace Period Completion"/>
        <_num_remarks desc="Number of Remarks"/>
        <_namespace desc="Namespace"/>
        <_version desc="Version"/>
        <_workgroups desc="Workgroups">
            <_workgroup/>
        </_workgroups>
        <_header mnemonic_path="/WorkOrder/WorkOrderExtension/ReferencedWorkOrder/ID/Id"
            desc="sourceSystemKey"/>
        <_header mnemonic_path="/combiningKey" desc="combiningKey"/>
    </Header>
</Query.Response>

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.