| | Integration and Data Mapping Integrating OTM / G-Log with external and legacy systems - including XML, WebServices, SOA, ESB, BPEL, EDI and Oracle's Fusion. |  | 
January 24th, 2008, 04:41
| | Junior Member | | Join Date: Dec 2007
Posts: 16
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0 | | | Question about Outbound XML size Hi
Do we have any limit for outbound XML file size limit in OTM.When am sending voucher/bill to external system the outbound XML getting generated always have size <1100 lines. Is there any limit in size for outbound XML?
Thanks
Baji | 
January 24th, 2008, 08:40
|  | Site Moderator | | Join Date: Jun 2006 Location: West Chester, PA
Posts: 1,167
Groans: 0
Groaned at 1 Time in 1 Post
Thanks: 143
Thanked 258 Times in 161 Posts
Rep Power: 10 | | | Re: Question about Outbound XML size Baji,
I'm not aware of any way to arbitrarily limit the outbound XML size - say to a certain number of lines, but you can use XML Profiles to limit the fields and information which are included in the outbound XML - thereby greatly reducing the total XML size. This also allows you to include only the information which is important to you in the outbound XMLs.
--Chris | 
January 24th, 2008, 08:56
| | Senior Member and Blogger | | Join Date: Dec 2006 Location: Singapore
Posts: 179
Groans: 0
Groaned at 1 Time in 1 Post
Thanks: 6
Thanked 13 Times in 12 Posts
Rep Power: 4 | | | Re: Question about Outbound XML size Hi Baji,
I have also noticed that all my outbound shipment XMLs have a rough limit of 5 MB. Because I have alot of outbound shipments to be sent in 1 go, I noticed that for every Send Integration process, I sometimes have 2 or more Outbound Transmissions and they are of 4 to 5 MB in size.
This may cause problems to the some systems receiving multiple outbound transmissions (at such short time apart) - I have personally seen some issues with IIS 6.0.
So what we did to *limit* the outbound XML file sizes was to add a ROWNUM < xxx clause in our saved queries.
This effectively limits the number of records selected for an Send Integration process - and indirectly limiting the outbound XML file size.
Hope this helps!
Ian | 
January 24th, 2008, 09:18
| | Junior Member | | Join Date: Dec 2007
Posts: 16
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0 | | | Re: Question about Outbound XML size Hi Ian/Chris,
Here is the problem that am facing
In out XML profile -> GLOG_MIN (default=MIN) i have added following xpath values
1)PaymentSummary/FreightCharge
2)PaymentSummary/WeightVolume
3)PaymentSummary/*
4)PaymentModeDetail/GenericDetail/PickupDate
But outbound XML transmission does not have any of these tags in it.It does does show this tags at all.I have checked in Integration->Integration Manager->Perform Integartion command -> command=viewTransmissionXML ,its not showing any tags that i have added in GLOG_MIN profile.and always see that Outbound xml size is <1100 lines.
Any suggestion.............
Thanks
Baji | 
January 25th, 2008, 00:24
| | Senior Member and Blogger | | Join Date: Dec 2006 Location: Singapore
Posts: 179
Groans: 0
Groaned at 1 Time in 1 Post
Thanks: 6
Thanked 13 Times in 12 Posts
Rep Power: 4 | | | Re: Question about Outbound XML size Quote:
Originally Posted by baji Hi Ian/Chris,
Here is the problem that am facing
In out XML profile -> GLOG_MIN (default=MIN) i have added following xpath values
1)PaymentSummary/FreightCharge
2)PaymentSummary/WeightVolume
3)PaymentSummary/*
4)PaymentModeDetail/GenericDetail/PickupDate
But outbound XML transmission does not have any of these tags in it.It does does show this tags at all.I have checked in Integration->Integration Manager->Perform Integartion command -> command=viewTransmissionXML ,its not showing any tags that i have added in GLOG_MIN profile.and always see that Outbound xml size is <1100 lines.
Any suggestion.............
Thanks
Baji | Hi Baji,
I may not have the same setup as you have and I don't have much experience on this but what I did is as follows (at least it worked for me). In the customer out XML profile defined:
1) Default Mode = MAX
2) Validate For MAX is checked
3) Use Template unchecked
4) Create the list EXCLUDE XML builder IDs
So this is the opposite of what you are doing - set for MAX and then remove all that you don't need. I have not tried setting for MIN and then adding what you need.
Hope this helps!
Ian | 
January 25th, 2008, 14:26
|  | Site Moderator | | Join Date: Jun 2006 Location: West Chester, PA
Posts: 1,167
Groans: 0
Groaned at 1 Time in 1 Post
Thanks: 143
Thanked 258 Times in 161 Posts
Rep Power: 10 | | | Re: Question about Outbound XML size To Ian's point, I can confirm that we've done it the same way. Added MAX and subtracted what wasn't necessary or relevant.
--Chris | 
February 5th, 2008, 16:25
| | OTMSIG Board Member | | Join Date: Oct 2006
Posts: 9
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 2 Times in 2 Posts
Rep Power: 0 | | | Re: Question about Outbound XML size Hi All -
Along this same note, we experienced an issue with the online booking and tendering screen in 5.5 CU4.
The Loaded distance was not being populated on the screen. Oracle instructed us to create a custom xml profile with the max setting and assign it to the carrier. We then had to withdraw the tender and retender to get the info to show up.
Even though the fix worked, I don't understand why an out of the box screen would not show all of the data until we created a custom xml profile. Just an observation.
Beth |  | | Thread Tools | | | | Display Modes | Linear Mode |
Posting Rules
| | | | |