OSM Order Line Items Reports Incorrectly Generated (Doc ID 1528675.1)

Last updated on APRIL 04, 2023

Applies to:

Symptoms

On : 7.2.0 version, Process Integration Pack

OSM Order Line Items reports incorrectly generated

When "Orders" report is generated using the ant scripts, the reports get generated, but the data is incorrectly populated. There are two issues:

1. In multi instance nodes, (such as /ControlData/OrderItem) the elements which are at a level 2 or lower hierarchy, the data gets repeated for all line items.

2. In multi Instance nodes, if child elements of the first line do not have a value populated, the value is picked from the next line in which a value is available. As an example:

Line 1:
BaseLineId : 1234
ParentLineId : ____

Line 2 :
BaseLineId : 1235
ParentLineId : 1233

The reports show:
BaseLineId_Id1_1 : 1234
ParentLineId_Id1_2 : 1233
BaseLineId_Id1_3 : 1235

1. From the getorderresponse for the submitted orderid and view

 <ord:GetOrder>
        <ord:OrderId>19</ord:OrderId>
        <ord:View>COM_SalesOrderFulfillment_OrderDetails</ord:View>
     </ord:GetOrder>

For Orderline Item and Name VoIP Fax Service - SSB (ADD), BusinessComponentID is coming as below
<osmc:BusinessComponentID index="1357749636402">2d313536393930343139333639353530</osmc:BusinessComponentID>
 For Orderline Item and Name>VoIP First Month Free Discount (ADD), BusinessComponentID is coming as below
<osmc:BusinessComponentID index="1357749636541">38333232383630353239303935313539</osmc:BusinessComponentID>

Where as in generated report BusinessComponentID,ID number are coming as same for both the orderline items

<LineName__id1__1>VoIP Fax Service - SSB (ADD)</LineName__id1__1>
     <LineId__id1__2>2d333639303531393134323536353734</LineId__id1__2>
     <BaseLineId__id1__3>2d333639303531393134323536353734</BaseLineId__id1__3>
     <StatusCode__id1__4>IN PROGRESS</StatusCode__id1__4>
     <StatusDescription__id1__5>SYNC CUSTOMER START: reached</StatusDescription__id1__5>
     <MilestoneCode__id1__6>SYNC CUSTOMER START</MilestoneCode__id1__6>
     <BusinessComponentID__id1__7>2d313536393930343139333639353530</BusinessComponentID__id1__7>
     <ID__id1__8>88-2EUN8</ID__id1__8>
     <LineName__id1__9>VoIP First Month Free Discount (ADD)</LineName__id1__9>
     <LineId__id1__10>2d343835313032393732313637393132</LineId__id1__10>
     <BaseLineId__id1__11>2d343835313032393732313637393132</BaseLineId__id1__11>
     <StatusCode__id1__12>IN PROGRESS</StatusCode__id1__12>
     <StatusDescription__id1__13>SYNC CUSTOMER START: reached</StatusDescription__id1__13>
     <MilestoneCode__id1__14>SYNC CUSTOMER START</MilestoneCode__id1__14>
     <BusinessComponentID__id1__15>2d313536393930343139333639353530</BusinessComponentID__id1__15>
     <ID__id1__16>88-2EUN8</ID__id1__16>
 

2. For the second problem, from worklist editor, Query for the Order id (in my case it was 19) and search

2.a Open the order in the editor
2.b For eg: Remove the MilestoneCode for the first orderlineitem and Name VoIP Fax Service - SSB (ADD)
2.c. Now generate the report and getorderresponse for the order
2.d. From the report you can see that MilestoneCode from Second orderlineitem is shifted to First orderlineItem. And SecondlineITem MilestoneCode is coming as empty in the Report. This is the same case if you 3 line order items, 2 lineitem milestone goes to 1 lineitem, 3rd lineitem milestone goes to 2 lineitem and 3 lineitem milestonecode will empty.

Please see the output of report and getorder response for milestonecode.
From the report:
<LineName__id1__1>VoIP Fax Service - SSB (ADD)</LineName__id1__1>
     <LineId__id1__2>2d333639303531393134323536353734</LineId__id1__2>
     <BaseLineId__id1__3>2d333639303531393134323536353734</BaseLineId__id1__3>
     <StatusCode__id1__4>IN PROGRESS</StatusCode__id1__4>
     <StatusDescription__id1__5>SYNC CUSTOMER START: reached</StatusDescription__id1__5>
     <MilestoneCode__id1__6>SYNC CUSTOMER START1</MilestoneCode__id1__6>--->Milestone code of Orderline item of 2.
     <BusinessComponentID__id1__7>2d313536393930343139333639353530</BusinessComponentID__id1__7>
     <ID__id1__8>88-2EUN8</ID__id1__8>
     <LineName__id1__9>VoIP First Month Free Discount (ADD)</LineName__id1__9>
     <LineId__id1__10>2d343835313032393732313637393132</LineId__id1__10>
     <BaseLineId__id1__11>2d343835313032393732313637393132</BaseLineId__id1__11>
     <StatusCode__id1__12>IN PROGRESS</StatusCode__id1__12>
     <StatusDescription__id1__13>SYNC CUSTOMER START: reached</StatusDescription__id1__13>
 XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX---->Milestone code is coming as null
     <BusinessComponentID__id1__14>2d313536393930343139333639353530</BusinessComponentID__id1__14>
     <ID__id1__15>88-2EUN8</ID__id1__15>

From the getorderresponse:

  <osmc:OrderItem index="1357749634449">
                    <osmc:LineName index="1357749636363">VoIP Fax Service - SSB (ADD)</osmc:LineName>
                    <osmc:BillingProductTypeCode index="1357749636354">SERVICE BUNDLE</osmc:BillingProductTypeCode>
                    <osmc:PermittedTypeCode index="1357749636375">/service/telco/voip</osmc:PermittedTypeCode>
                    <osmc:ServiceActionCode index="1357749636390">ADD</osmc:ServiceActionCode>
                    <osmc:TypeCode index="1357749636395">PRODUCT</osmc:TypeCode>
                    <osmc:LineId index="1357749636388">2d333639303531393134323536353734</osmc:LineId>
                    <osmc:BaseLineId index="1357749636355">2d333639303531393134323536353734</osmc:BaseLineId>
                    <osmc:ProductSpec index="1357749636393">Service.VoIP</osmc:ProductSpec>
                    <osmc:ProductClass index="1357749636386">VoIP Service Feature Class</osmc:ProductClass>
                    <osmc:StatusCode index="1357749636392">IN PROGRESS</osmc:StatusCode>
                    <osmc:StatusDescription index="1357749636377">SYNC CUSTOMER START: reached</osmc:StatusDescription>
                    <osmc:PrimaryClassificationCode index="1357749636391">SERVICE_VoIP</osmc:PrimaryClassificationCode>
                    <osmc:CustomerPartyAccountTypeCode index="1357749636359">RESIDENTIAL</osmc:CustomerPartyAccountTypeCode>
                    <osmc:ServiceAddressCountryCode index="1357749636360">USA</osmc:ServiceAddressCountryCode>
                    <osmc:LineRequestedDeliveryDateTime index="1357749636394">2009-07-07T17:15:27Z</osmc:LineRequestedDeliveryDateTime>
                    <osmc:IsLineInvokeInitiateBilling index="1357749636489">NO</osmc:IsLineInvokeInitiateBilling>
                    <osmc:FulfillmentState index="1357749636376">IN_PROGRESS</osmc:FulfillmentState>
                    <osmc:BaseLineItemData index="1357749636396">
<osmc:OrderItem index="1357749634450">
                    <osmc:LineName index="1357749636502">VoIP First Month Free Discount (ADD)</osmc:LineName>
                    <osmc:BillingProductTypeCode index="1357749636493">DISCOUNT</osmc:BillingProductTypeCode>
                    <osmc:PermittedTypeCode index="1357749636514">/service/telco/voip</osmc:PermittedTypeCode>
                    <osmc:ServiceActionCode index="1357749636529">ADD</osmc:ServiceActionCode>
                    <osmc:TypeCode index="1357749636534">PRODUCT</osmc:TypeCode>
                    <osmc:LineId index="1357749636527">2d343835313032393732313637393132</osmc:LineId>
                    <osmc:BaseLineId index="1357749636494">2d343835313032393732313637393132</osmc:BaseLineId>
                    <osmc:ProductSpec index="1357749636532">NonService.BillingItem</osmc:ProductSpec>
                    <osmc:StatusCode index="1357749636531">IN PROGRESS</osmc:StatusCode>
                    <osmc:StatusDescription index="1357749636516">SYNC CUSTOMER START: reached</osmc:StatusDescription>
                    <osmc:MilestoneCode index="1357749636692">SYNC CUSTOMER START1</osmc:MilestoneCode>
                    <osmc:PrimaryClassificationCode index="1357749636530">DISCOUNT_VoIP</osmc:PrimaryClassificationCode>
                    <osmc:CustomerPartyAccountTypeCode index="1357749636498">RESIDENTIAL</osmc:CustomerPartyAccountTypeCode>
                    <osmc:ServiceAddressCountryCode index="1357749636499">USA</osmc:ServiceAddressCountryCode>
                    <osmc:LineRequestedDeliveryDateTime index="1357749636533">2009-07-07T17:15:27Z</osmc:LineRequestedDeliveryDateTime>
                    <osmc:IsLineInvokeInitiateBilling index="1357749636623">NO</osmc:IsLineInvokeInitiateBilling>
                    <osmc:FulfillmentState index="1357749636515">IN_PROGRESS</osmc:FulfillmentState>
                    <osmc:BaseLineItemData index="1357749636535">

Cause

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