otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire


Integration and Data Mapping Integrating OTM / G-Log with external and legacy systems - including XML, WebServices, SOA, ESB, BPEL, EDI and Oracle's Fusion.

Tags: , , , ,

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old April 17th, 2008, 09:06
chrisplough's Avatar
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 821
Blog Entries: 7
Thanks: 53
Thanked 201 Times in 121 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 10
chrisplough has a spectacular aura aboutchrisplough has a spectacular aura aboutchrisplough has a spectacular aura about
Send a message via AIM to chrisplough
OTM Outbound Integration Issue - GLOG_MIN XML Profile

All,

For those who haven't been bit by Oracle's decision to change XML profile for outbound integration transmissions to GLOG_MIN - be warned. Many integration issues stem from this - where you aren't receiving all of the information in your integration XML file that you expect -- or were previous to an upgrade.

A friend of mine recently hit this, and I wanted to post, in order to hopefully prevent others from experiencing the same issue:

Quote:
Where you aware that in version 5.5 Oracle tried to limit the size and information being sent out in the outbound XML's using outbound xml profiles and associating the profiles with some of the different integration elements like ActualShipment's, TransOrders and ShipmentGroup's?

So the following needs to take place.
Code:
SELECT * FROM INT_GLOG_XML_ELEMENT WHERE GLOG_XML_ELEMENT_GID = 'ShipmentGroup';


More than likely you will see the OUT_XML_PROFILE_GID assigned is GLOG_MIN. If so, this would indicate only the minimum information would be sent out.
You can modify this entry to be GLOG_NONE, which should allow for the entire ShipmentGroup XML to be sent out. The following SQL statement should work.
Code:
UPDATE INT_GLOG_XML_ELEMENT set OUT_XML_PROFILE_GID = 'GLOG_NONE' where GLOG_XML_ELEMENT_GID = 'ShipmentGroup';

Since this record is in the PUBLIC domain you should be logged in as DBA.ADMIN when you access the SQL Servlet to make this change.
Once done the server needs to be bounce.
Hope this helps!

--Chris
__________________
Chris Plough
MavenWire

www.MavenWire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with External System Translations for OUTBOUND/INBOUND Stefano Integration and Data Mapping 4 June 2nd, 2008 14:03
Question about Outbound XML size baji Integration and Data Mapping 6 February 5th, 2008 17:25
Performance issue integration bob_romijn Performance, Scalability and HA 5 November 28th, 2007 12:11
Outbound Queue in OTM rkuruba Integration and Data Mapping 0 September 18th, 2007 22:01
EBS / OTM Integration Issue - appsborg* Libriaries chrisplough OTM / EBS / JDE E1 Integration 7 September 9th, 2007 19:46



All times are GMT. The time now is 21:36.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37