0 Replies Latest reply: Aug 16, 2011 11:36 PM by 881538 RSS

    Find Criteria problem in ADF BC framework with DataServices for tables 1to1


      I have built a DataService (Database tables exposed as WebServices) using ADF BC framework in JDeveloper.

      I have used 2 tables Cqualitycategory(Parent) and Cqualitycategoryxref(child) with 1 to 1 relationship on id Cqualitycategoryid.

      This service exposes operations such as Create, Update, Find, delete & etc.

      After providing this service WSDL path to SOAP UI tool and when I try to hit the find criteria(*childFindCriteria*) using the below request I receive all the records of the child for a single parent table(Having multiple records for the child tables). But according to the below request(childFindCriteria filter) I should only get the records which matches the filter along with the Parent record.

      <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="/com/abc/csim/ebo/module/common/types/" xmlns:typ1="http://xmlns.oracle.com/adf/svc/types/">

      But the same kind of request (find criteria) is perfectly works fine by giving the desired result(childFindCriteria) with 1 Parent tables and 2-3 childs(1 to many relationship).

      It seems to be an issue with the ADF BC Framework for the tables with 1 to 1 relationship.

      Please suggest me a solution or a work around so that the childFindCriteria works for tables with 1 to 1 relationship.


      Edited by: user13174911 on Aug 17, 2011 10:03 AM

      Edited by: user13174911 on Aug 17, 2011 10:05 AM