on 05-25-2006 1:02 PM
Hi,
I'm trying to map infotype(source) 2, 32 & 41 onto a flat structure(target) of Oracle DB( IDoc to JDBC ), it works partially as it comes to multiple occurances of any segment under parent node E1PLOGI, it only reads first 2 occurances of segments E1P0002 & E1P0032(in bold) and ignores the subsequent segments. Could someone pls. point out what I'm doing wrong, actually its my first XI interface, so I would appreciate the details.
Inbound
<?xml version="1.0" encoding="UTF-8" ?>
- <E1PLOGI SEGMENT="1">
<PLVAR>01</PLVAR>
<OTYPE>P</OTYPE>
<OBJID>00000006</OBJID>
<OPERA>I</OPERA>
- <E1PITYP SEGMENT="1">
<PLVAR>01</PLVAR>
<OTYPE>P</OTYPE>
<OBJID>00000006</OBJID>
<INFTY>0002</INFTY>
<BEGDA>18000101</BEGDA>
<ENDDA>99991231</ENDDA>
<LONG_INFTY>X</LONG_INFTY>
<b>+ <E1P0002 SEGMENT="1">
+ <E1P0002 SEGMENT="1"></b>
+ <E1P0002 SEGMENT="1">
+ <E1P0002 SEGMENT="1">
- <E1PITYP SEGMENT="1">
<PLVAR>01</PLVAR>
<OTYPE>P</OTYPE>
<OBJID>00000006</OBJID>
<INFTY>0032</INFTY>
<BEGDA>18000101</BEGDA>
<ENDDA>99991231</ENDDA>
<b>+ <E1P0032 SEGMENT="1">
+ <E1P0032 SEGMENT="1"></b>
+ <E1P0032 SEGMENT="1">
- <E1PITYP SEGMENT="1">
<PLVAR>01</PLVAR>
<OTYPE>P</OTYPE>
<OBJID>00000006</OBJID>
<INFTY>0041</INFTY>
<BEGDA>18000101</BEGDA>
<ENDDA>99991231</ENDDA>
<b>+ <E1P0041 SEGMENT="1"></b>
</E1PLOGI>
The flat structure of Oracle DB is set as StatementName as 0..Unbounded and access as 1..unbounded.
cheers
Taj
Hi Taj,
Put a trace and test it monitoring.
TY
SY
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Taj
welcome to SDN,
U r unable to see the remaing segments since the mapping between the source and target element is not properly done... Do assign the source elements with the target..
And also once test u r mapping in IR and see what values r being mapped with the target...
Regards,
sridhar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.