This content has been marked as final. Show 5 replies
Now I found that this problem arise in 2 tables adapter too. Is there any possibility that problem is joined with amount of data (columns) selected by adapter?
Because table in adapter has many columns.
I don't think amount of data will cause any issues here. Cross check the XSD generated by adapter and make sure that it is correct. Also check the SELECT sql which gets generated. make sure that it is correct.
XSD generated looks fine and is valid. I can send it. SQL select statement is ok too and returns correct data.
Hi.. did you try using Alias name for the tables in your query?
JDeveloper use aliase names for tables by default so aliases t0, t1, t3 are used for tables basketinvoice, basketitem, documents.
I think there is some connection to table. Collection of basketinvoicepayments table is missing when 3 tables select and 2 tables select too.
Table basketinvoicepayments is child table and it's element is missing even when relationship is 1:M or 1:1 (Foreign Key on Child table).