Reading data from EDID4 table for the Error idoc and exctract it in Oracle table. Correct the data and send it back by forming data in iDOC format.
After 5 segemnt theh job fails. If we create more than 5 query transform to map the data the job fails.
raniaher (BOB member since 2012-01-12)
Fails with what error message?
Werner Daehn 
(BOB member since 2004-12-17)
It does not fails actally but shows job created successfully and if i check on the job server the iDoc is not exists. In some cases if the segement has 2 records it creates 2 idoc. looks very strange.
raniaher (BOB member since 2012-01-12)
Check the from clause in the query you do the nesting. The from (and where) clause on each schema level selected to be current one in the output pane controls how many records will go into the schema. When you say it creates 2 records if there are two rows in a segment, I would guess the from clause contains the source table with the segment data in the root schema of the query - the query itself. How many IDOCs do you want? Just one? Then we need a Row_Gen transform as source and as only from clause at the query level.
Werner Daehn (BOB member since 2004-12-17)