12 Replies Latest reply: Feb 19, 2013 9:12 AM by 990534 RSS

    Unable to create new rows in master detail

    990694
      Hi, I am new to ADF

      I am using Jdeveloper 11.1.1.6, I have two tables customer and contacts, customerId is a foriegnKey in contacts. when customer is deleted all the contacts need to be deleted.
      I have created an association (1 to * customer to contacts) between customerEO & contactsEO (checked Composite association, implement cascade delete option), and a view link (1 to * customerVO to contactsVO).
      I am testing the viewlink through AM, not using JSF
      when i am trying to create new row in details(contacts) table, the customer id is populating in details table.
      when i am trying to commit to database (Details table) i am getting the following error

      java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (CONTACT_CUSTOMERID_FK) violated - parent key not found
      ORA-06512: at line 1

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
           at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
           at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
           at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
           at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3904)
           at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:9417)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1512)
           at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:429)
           at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:8575)
           at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:6816)
           at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3290)
           at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:6893)
           at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3290)
           at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:3093)
           at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2097)
           at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2378)
           at oracle.adf.model.bc4j.DCJboDataControl.commitTransaction(DCJboDataControl.java:1615)
           at oracle.adf.model.binding.DCDataControl.callCommitTransaction(DCDataControl.java:1417)
           at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1437)
           at oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2150)
           at oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:740)
           at oracle.jbo.uicli.jui.JUActionBinding.actionPerformed(JUActionBinding.java:193)

      Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-02291: integrity constraint (CONTACT_CUSTOMERID_FK) violated - parent key not found
      ORA-06512: at line 1

           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
           at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
           at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
           at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
           at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
           at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
           at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)


      Can you please help me how to solve this issue

      Thanks & Regards
      Ani

      Edited by: 987691 on Feb 12, 2013 2:50 PM

      Edited by: 987691 on Feb 12, 2013 2:54 PM
        • 1. Re: Unable to create new rows in master detail
          990534
          Hi,

          I think the reason would be you wouldn't have commited the parent data to the db Before inserting the new row in the child table.

          Thanks,
          Raj.
          • 2. Re: Unable to create new rows in master detail
            990694
            Thanks for your reply Raj, But I am not creating any parent records, I am using existing parent and trying to create child records
            Even I tried by uncheking the composite association between parent and child, trying to insert directly through child view object(ContactsVO) then also its not working

            Edited by: 987691 on Feb 13, 2013 1:44 PM
            • 3. Re: Unable to create new rows in master detail
              Sudipto Desmukh
              Are you sure that the master primary key exists in the DB against which you are trying to enter child records ? Please double check the same.
              Also debug into your code and check what id's are being populated and if they are present in the DB
              • 4. Re: Unable to create new rows in master detail
                990534
                Hi,
                Which UI Model you are using master details form, form or table .....
                Can you please let me know so that i can help you .
                If you are creating using a tree table or tree you should follow this link .
                [http://jobinesh.blogspot.in/2010/05/crud-operations-on-tree-table.html]

                Thanks,
                Raj.

                Edited by: RajaSekharReddy.M on Feb 13, 2013 10:38 PM
                • 5. Re: Unable to create new rows in master detail
                  Dileep Rongali
                  Hi,

                  I think, you are trying to create child record without master context(directly clicking on Child VO instance in AM tester). Try running Master-ChildVO instance in AM tester. Here we will see master details section. Now try creating child record.

                  If you are not creating like above, hope this will help you.


                  -- Dileep.
                  • 6. Re: Unable to create new rows in master detail
                    990694
                    Thanks for your replies,
                    I am testing the master details from AM, Parent table is having the primaryKey and it is being populated through DBSequence.
                    When i am trying to create new rows in child table it is populating parent table CustomerId primaryKey and also the ContactId primaryKey(DBSequence) of the child table.
                    I am not sure how to debug to check whether the primary key is populating or not, Plz Help me resolving this issue..

                    Thanks,
                    Ani
                    • 7. Re: Unable to create new rows in master detail
                      990534
                      Hi Ani,
                      Are the getting the issue even at the application module level ??? can you post your code .
                      Thanks,
                      Raj.
                      • 8. Re: Unable to create new rows in master detail
                        990694
                        Hi Raj,
                        I have checked for foreignKey constraint it is existing in the database.

                        Following is the script i have used to create the tables

                        CREATE TABLE "XX_CUSTOMER"
                        ( "CUSTOMERID" NUMBER NOT NULL ENABLE,
                        "FIRSTNAME" VARCHAR2(50) NOT NULL ENABLE,
                        "MIDDLENAME" VARCHAR2(10),
                        "LASTNAME" VARCHAR2(50) NOT NULL ENABLE,
                        "DOB" DATE NOT NULL ENABLE,
                        "ADDRESS1" VARCHAR2(100) NOT NULL ENABLE,
                        "ADDRESS2" VARCHAR2(100),
                        "CITY" VARCHAR2(30) NOT NULL ENABLE,
                        "STATE" VARCHAR2(30) NOT NULL ENABLE,
                        "COUNTRY" VARCHAR2(30) NOT NULL ENABLE,
                        "GENDER" VARCHAR2(5) NOT NULL ENABLE,
                        "PRIMARYPHONE" VARCHAR2(12) NOT NULL ENABLE,
                        "SECONDARYPHONE" VARCHAR2(12),
                        "EMAIL" VARCHAR2(100) NOT NULL ENABLE,
                        "FAX" VARCHAR2(12),
                        "LANGUAGES" VARCHAR2(50) NOT NULL ENABLE,
                        CONSTRAINT "XX_CUSTOMERDETAILS_PK" PRIMARY KEY ("CUSTOMERID") ENABLE
                        );
                        /
                        CREATE OR REPLACE TRIGGER "XX_CUSTOMER_CUSTOMERID_TRIG"
                        BEFORE
                        insert or update or delete on "XX_CUSTOMER"
                        for each row
                        begin
                        select "XX_CUST_DETAILS_CUSTOMERID_SEQ".nextval into :NEW.CUSTOMERID from dual;
                        end;
                        /
                        ALTER TRIGGER "XX_CUSTOMER_CUSTOMERID_TRIG" ENABLE
                        /
                        CREATE SEQUENCE "XX_CUST_DETAILS_CUSTOMERID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE
                        /
                        CREATE TABLE "XX_CONTACTS"
                        ( "CONTACTID" NUMBER(10,0) NOT NULL ENABLE,
                        "CONTACTNAME" VARCHAR2(50) NOT NULL ENABLE,
                        "ADDRESS1" VARCHAR2(100) NOT NULL ENABLE,
                        "ADDRESS2" VARCHAR2(100),
                        "CITY" VARCHAR2(30) NOT NULL ENABLE,
                        "STATE" VARCHAR2(100) NOT NULL ENABLE,
                        "COUNTRY" VARCHAR2(100) NOT NULL ENABLE,
                        "PRIMARYPHONE" VARCHAR2(100) NOT NULL ENABLE,
                        "SECONDARYPHONE" VARCHAR2(100) NOT NULL ENABLE,
                        "EMAIL" VARCHAR2(100) NOT NULL ENABLE,
                        "FAX" VARCHAR2(100) NOT NULL ENABLE,
                        "CUSTOMERID" NUMBER,
                        CONSTRAINT "XX_CONTACTID_PK" PRIMARY KEY ("CONTACTID") ENABLE,
                        CONSTRAINT "XX_CONTACT_CUSTOMERID_FK" FOREIGN KEY ("CUSTOMERID")
                        REFERENCES "XX_CUSTOMER" ("CUSTOMERID") ENABLE
                        );
                        /
                        CREATE SEQUENCE "XX_CONTACTS_CONTACTID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE
                        /
                        CREATE OR REPLACE TRIGGER "XX_CONTACT_CONTACTID_TRIGGER"
                        BEFORE
                        insert on "XX_CONTACTS"
                        for each row
                        begin
                        select "XX_CONTACTS_CONTACTID_SEQ".nextval into :NEW.CUSTOMERID from dual;
                        end;
                        /
                        ALTER TRIGGER "XX_CONTACT_CONTACTID_TRIGGER" ENABLE

                        ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                        Following code i modified in ContactsEOImpl class to generate contact_Id through DBSequence

                        protected void create(AttributeList attributeList) {
                        super.create(attributeList);
                        //Populating primary key programatically
                        SequenceImpl seq = new SequenceImpl("XX_CONTACTS_CONTACTID_SEQ", getDBTransaction());
                        setContactid(seq.getSequenceNumber());
                        }
                        ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                        Edited by: 987691 on Feb 18, 2013 2:54 PM
                        • 9. Re: Unable to create new rows in master detail
                          990694
                          Here is My CustomerEO.xml file_

                          <?xml version="1.0" encoding="windows-1252" ?>
                          <!DOCTYPE Entity SYSTEM "jbo_03_01.dtd">
                          <!---->
                          <Entity
                          xmlns="http://xmlns.oracle.com/bc4j"
                          Name="CustomerEO"
                          Version="11.1.1.61.92"
                          InheritPersonalization="true"
                          DBObjectType="table"
                          DBObjectName="XX_CUSTOMER"
                          AliasName="CustomerEO"
                          BindingStyle="OracleName"
                          UseGlueCode="false"
                          xmlns:validation="http://xmlns.oracle.com/adfm/validation"
                          RowClass="customer.model.CustomerEOImpl">
                          <DesignTime>
                          <AttrArray Name="_publishEvents"/>
                          <Attr Name="_codeGenFlag2" Value="Init|Access"/>
                          <Attr Name="_isCodegen" Value="true"/>
                          </DesignTime>
                          <Attribute
                          Name="Customerid"
                          ColumnName="CUSTOMERID"
                          SQLType="NUMERIC"
                          Type="oracle.jbo.domain.DBSequence"
                          ColumnType="NUMBER"
                          TableName="XX_CUSTOMER"
                          PrimaryKey="true"
                          IsUpdateable="while_insert"
                          DefaultValue="@0"
                          Domain="oracle.jbo.domain.DBSequence"
                          RetrievedOnInsert="true">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="22"/>
                          </DesignTime>
                          </Attribute>
                          <Attribute
                          Name="Firstname"
                          IsNotNull="true"
                          Precision="50"
                          ColumnName="FIRSTNAME"
                          SQLType="VARCHAR"
                          Type="java.lang.String"
                          ColumnType="VARCHAR2"
                          TableName="XX_CUSTOMER">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="50"/>
                          </DesignTime>
                          <validation:PreDefinedValidationBean
                          Name="Firstname_Rule_0"
                          ResId="customer.model.CustomerEO.Firstname_Rule_0"
                          ValName="Mandatory"
                          Subtype="MANDATORY"/>
                          <validation:PreDefinedValidationBean
                          Name="Firstname_Rule_1"
                          ResId="customer.model.CustomerEO.Firstname_Rule_1"
                          ValName="Precision : (50)"
                          Subtype="PRECISION_SCALE"/>
                          <validation:RegExpValidationBean
                          Name="Firstname_Rule_2"
                          OnAttribute="Firstname"
                          Pattern="^[a-zA-Z(\s)]*$"
                          Inverse="false"
                          ResId="customer.model.CustomerEO.Firstname_Rule_2"/>
                          </Attribute>
                          <Attribute
                          Name="Middlename"
                          Precision="10"
                          ColumnName="MIDDLENAME"
                          SQLType="VARCHAR"
                          Type="java.lang.String"
                          ColumnType="VARCHAR2"
                          TableName="XX_CUSTOMER">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="10"/>
                          </DesignTime>
                          <validation:PreDefinedValidationBean
                          Name="Middlename_Rule_0"
                          ResId="customer.model.CustomerEO.Middlename_Rule_0"
                          ValName="Precision : (10)"
                          Subtype="PRECISION_SCALE"/>
                          <validation:RegExpValidationBean
                          Name="Middlename_Rule_1"
                          ResId="customer.model.CustomerEO.Middlename_Rule_1"
                          OnAttribute="Middlename"
                          Pattern="^[a-zA-Z(\s)]*$"
                          Inverse="false"/>
                          </Attribute>
                          <Attribute
                          Name="Lastname"
                          IsNotNull="true"
                          Precision="50"
                          ColumnName="LASTNAME"
                          SQLType="VARCHAR"
                          Type="java.lang.String"
                          ColumnType="VARCHAR2"
                          TableName="XX_CUSTOMER">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="50"/>
                          </DesignTime>
                          <validation:PreDefinedValidationBean
                          Name="Lastname_Rule_0"
                          ResId="customer.model.CustomerEO.Lastname_Rule_0"
                          ValName="Mandatory"
                          Subtype="MANDATORY"/>
                          <validation:PreDefinedValidationBean
                          Name="Lastname_Rule_1"
                          ResId="customer.model.CustomerEO.Lastname_Rule_1"
                          ValName="Precision : (50)"
                          Subtype="PRECISION_SCALE"/>
                          <validation:RegExpValidationBean
                          Name="Lastname_Rule_2"
                          ResId="customer.model.CustomerEO.Lastname_Rule_2"
                          OnAttribute="Lastname"
                          Pattern="^[a-zA-Z(\s)]*$"
                          Inverse="false"/>
                          </Attribute>
                          <Attribute
                          Name="Dob"
                          IsNotNull="true"
                          ColumnName="DOB"
                          SQLType="TIMESTAMP"
                          Type="oracle.jbo.domain.Date"
                          ColumnType="DATE"
                          TableName="XX_CUSTOMER">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="7"/>
                          </DesignTime>
                          <validation:PreDefinedValidationBean
                          Name="Dob_Rule_1"
                          ResId="customer.model.CustomerEO.Dob_Rule_1"
                          ValName="Mandatory"
                          Subtype="MANDATORY"/>
                          <validation:MethodValidationBean
                          Name="Dob_Rule_0"
                          ResId="customer.model.CustomerEO.Dob_Rule_2"
                          MethodName="validateDob"/>
                          </Attribute>
                          <Attribute
                          Name="Address1"
                          IsNotNull="true"
                          Precision="100"
                          ColumnName="ADDRESS1"
                          SQLType="VARCHAR"
                          Type="java.lang.String"
                          ColumnType="VARCHAR2"
                          TableName="XX_CUSTOMER">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="100"/>
                          </DesignTime>
                          <validation:PreDefinedValidationBean
                          Name="Address1_Rule_0"
                          ResId="customer.model.CustomerEO.Address1_Rule_0"
                          ValName="Mandatory"
                          Subtype="MANDATORY"/>
                          <validation:PreDefinedValidationBean
                          Name="Address1_Rule_1"
                          ResId="customer.model.CustomerEO.Address1_Rule_1"
                          ValName="Precision : (100)"
                          Subtype="PRECISION_SCALE"/>
                          <validation:RegExpValidationBean
                          Name="Address1_Rule_2"
                          ResId="customer.model.CustomerEO.Address1_Rule_2"
                          OnAttribute="Address1"
                          Pattern="^[a-z0-9A-Z(\s)]*$"
                          Inverse="false"/>
                          </Attribute>
                          <Attribute
                          Name="Address2"
                          Precision="100"
                          ColumnName="ADDRESS2"
                          SQLType="VARCHAR"
                          Type="java.lang.String"
                          ColumnType="VARCHAR2"
                          TableName="XX_CUSTOMER">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="100"/>
                          </DesignTime>
                          <validation:PreDefinedValidationBean
                          Name="Address2_Rule_0"
                          ResId="customer.model.CustomerEO.Address2_Rule_0"
                          ValName="Precision : (100)"
                          Subtype="PRECISION_SCALE"/>
                          <validation:RegExpValidationBean
                          Name="Address2_Rule_1"
                          ResId="customer.model.CustomerEO.Address2_Rule_1"
                          OnAttribute="Address2"
                          Pattern="^[a-z0-9A-Z(\s)]*$"
                          Inverse="false"/>
                          </Attribute>
                          <Attribute
                          Name="City"
                          IsNotNull="true"
                          Precision="30"
                          ColumnName="CITY"
                          SQLType="VARCHAR"
                          Type="java.lang.String"
                          ColumnType="VARCHAR2"
                          TableName="XX_CUSTOMER">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="30"/>
                          </DesignTime>
                          <validation:PreDefinedValidationBean
                          Name="City_Rule_0"
                          ResId="customer.model.CustomerEO.City_Rule_0"
                          ValName="Mandatory"
                          Subtype="MANDATORY"/>
                          <validation:PreDefinedValidationBean
                          Name="City_Rule_1"
                          ResId="customer.model.CustomerEO.City_Rule_1"
                          ValName="Precision : (30)"
                          Subtype="PRECISION_SCALE"/>
                          <validation:RegExpValidationBean
                          Name="City_Rule_2"
                          ResId="customer.model.CustomerEO.City_Rule_2"
                          OnAttribute="City"
                          Pattern="^[a-zA-Z(\s)]*$"
                          Inverse="false"/>
                          </Attribute>
                          <Attribute
                          Name="Country"
                          IsNotNull="true"
                          Precision="30"
                          ColumnName="COUNTRY"
                          SQLType="VARCHAR"
                          Type="java.lang.String"
                          ColumnType="VARCHAR2"
                          TableName="XX_CUSTOMER">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="30"/>
                          </DesignTime>
                          <validation:PreDefinedValidationBean
                          Name="Country_Rule_0"
                          ResId="customer.model.CustomerEO.Country_Rule_0"
                          ValName="Mandatory"
                          Subtype="MANDATORY"/>
                          <validation:PreDefinedValidationBean
                          Name="Country_Rule_1"
                          ResId="customer.model.CustomerEO.Country_Rule_1"
                          ValName="Precision : (30)"
                          Subtype="PRECISION_SCALE"/>
                          </Attribute>
                          <Attribute
                          Name="State"
                          IsNotNull="true"
                          Precision="30"
                          ColumnName="STATE"
                          SQLType="VARCHAR"
                          Type="java.lang.String"
                          ColumnType="VARCHAR2"
                          TableName="XX_CUSTOMER">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="30"/>
                          </DesignTime>
                          <validation:PreDefinedValidationBean
                          Name="State_Rule_0"
                          ResId="customer.model.CustomerEO.State_Rule_0"
                          ValName="Mandatory"
                          Subtype="MANDATORY"/>
                          <validation:PreDefinedValidationBean
                          Name="State_Rule_1"
                          ResId="customer.model.CustomerEO.State_Rule_1"
                          ValName="Precision : (30)"
                          Subtype="PRECISION_SCALE"/>
                          </Attribute>
                          <Attribute
                          Name="Gender"
                          IsNotNull="true"
                          Precision="5"
                          ColumnName="GENDER"
                          SQLType="VARCHAR"
                          Type="java.lang.String"
                          ColumnType="VARCHAR2"
                          TableName="XX_CUSTOMER">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="5"/>
                          </DesignTime>
                          <validation:PreDefinedValidationBean
                          Name="Gender_Rule_0"
                          ResId="customer.model.CustomerEO.Gender_Rule_0"
                          ValName="Mandatory"
                          Subtype="MANDATORY"/>
                          <validation:PreDefinedValidationBean
                          Name="Gender_Rule_1"
                          ResId="customer.model.CustomerEO.Gender_Rule_1"
                          ValName="Precision : (5)"
                          Subtype="PRECISION_SCALE"/>
                          </Attribute>
                          <Attribute
                          Name="Primaryphone"
                          IsNotNull="true"
                          Precision="12"
                          ColumnName="PRIMARYPHONE"
                          SQLType="VARCHAR"
                          Type="java.lang.String"
                          ColumnType="VARCHAR2"
                          TableName="XX_CUSTOMER"
                          DefaultValue="###-###-####">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="12"/>
                          </DesignTime>
                          <validation:PreDefinedValidationBean
                          Name="Primaryphone_Rule_0"
                          ResId="customer.model.CustomerEO.Primaryphone_Rule_0"
                          ValName="Mandatory"
                          Subtype="MANDATORY"/>
                          <validation:PreDefinedValidationBean
                          Name="Primaryphone_Rule_1"
                          ResId="customer.model.CustomerEO.Primaryphone_Rule_1"
                          ValName="Precision : (12)"
                          Subtype="PRECISION_SCALE"/>
                          <validation:RegExpValidationBean
                          Name="Primaryphone_Rule_2"
                          ResId="customer.model.CustomerEO.Primaryphone_Rule_2"
                          OnAttribute="Primaryphone"
                          Pattern="[0-9]{3}-?[0-9]{3}-?[0-9]{4}"
                          Inverse="false"/>
                          </Attribute>
                          <Attribute
                          Name="Secondaryphone"
                          Precision="12"
                          ColumnName="SECONDARYPHONE"
                          SQLType="VARCHAR"
                          Type="java.lang.String"
                          ColumnType="VARCHAR2"
                          TableName="XX_CUSTOMER"
                          DefaultValue="###-###-####">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="12"/>
                          </DesignTime>
                          <validation:PreDefinedValidationBean
                          Name="Secondaryphone_Rule_0"
                          ResId="customer.model.CustomerEO.Secondaryphone_Rule_0"
                          ValName="Precision : (12)"
                          Subtype="PRECISION_SCALE"/>
                          <validation:RegExpValidationBean
                          Name="Secondaryphone_Rule_1"
                          ResId="customer.model.CustomerEO.Secondaryphone_Rule_1"
                          OnAttribute="Secondaryphone"
                          Pattern="[0-9]{3}-?[0-9]{3}-?[0-9]{4}"
                          Inverse="false"/>
                          </Attribute>
                          <Attribute
                          Name="Email"
                          IsNotNull="true"
                          Precision="100"
                          ColumnName="EMAIL"
                          SQLType="VARCHAR"
                          Type="java.lang.String"
                          ColumnType="VARCHAR2"
                          TableName="XX_CUSTOMER">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="100"/>
                          </DesignTime>
                          <validation:PreDefinedValidationBean
                          Name="Email_Rule_0"
                          ResId="customer.model.CustomerEO.Email_Rule_0"
                          ValName="Mandatory"
                          Subtype="MANDATORY"/>
                          <validation:PreDefinedValidationBean
                          Name="Email_Rule_1"
                          ResId="customer.model.CustomerEO.Email_Rule_1"
                          ValName="Precision : (100)"
                          Subtype="PRECISION_SCALE"/>
                          <validation:RegExpValidationBean
                          Name="Email_Rule_2"
                          ResId="customer.model.CustomerEO.Email_Rule_2"
                          OnAttribute="Email"
                          Pattern="[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}"
                          Inverse="false"/>
                          </Attribute>
                          <Attribute
                          Name="Fax"
                          Precision="12"
                          ColumnName="FAX"
                          SQLType="VARCHAR"
                          Type="java.lang.String"
                          ColumnType="VARCHAR2"
                          TableName="XX_CUSTOMER"
                          DefaultValue="###-###-####">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="12"/>
                          </DesignTime>
                          <validation:PreDefinedValidationBean
                          Name="Fax_Rule_0"
                          ResId="customer.model.CustomerEO.Fax_Rule_0"
                          ValName="Precision : (12)"
                          Subtype="PRECISION_SCALE"/>
                          <validation:RegExpValidationBean
                          Name="Fax_Rule_1"
                          ResId="customer.model.CustomerEO.Fax_Rule_1"
                          OnAttribute="Fax"
                          Pattern="[0-9]{3}-?[0-9]{3}-?[0-9]{4}"
                          Inverse="false"/>
                          </Attribute>
                          <Attribute
                          Name="Languages"
                          IsNotNull="true"
                          Precision="50"
                          ColumnName="LANGUAGES"
                          SQLType="VARCHAR"
                          Type="java.lang.String"
                          ColumnType="VARCHAR2"
                          TableName="XX_CUSTOMER">
                          <DesignTime>
                          <Attr Name="_DisplaySize" Value="50"/>
                          </DesignTime>
                          <validation:PreDefinedValidationBean
                          Name="Languages_Rule_0"
                          ResId="customer.model.CustomerEO.Languages_Rule_0"
                          ValName="Mandatory"
                          Subtype="MANDATORY"/>
                          <validation:PreDefinedValidationBean
                          Name="Languages_Rule_1"
                          ResId="customer.model.CustomerEO.Languages_Rule_1"
                          ValName="Precision : (50)"
                          Subtype="PRECISION_SCALE"/>
                          </Attribute>
                          <AccessorAttribute
                          Name="ContactsEO"
                          Association="customer.model.CustomerEOtoContactsEO"
                          AssociationEnd="customer.model.CustomerEOtoContactsEO.ContactsEO"
                          AssociationOtherEnd="customer.model.CustomerEOtoContactsEO.CustomerEO"
                          Type="oracle.jbo.RowIterator"
                          IsUpdateable="false"/>
                          <Key
                          Name="SysC007004">
                          <DesignTime>
                          <Attr Name="_DBObjectName" Value="SYS_C007004"/>
                          <Attr Name="_checkCondition" Value='"CUSTOMERID" IS NOT NULL'/>
                          <Attr Name="_isCheck" Value="true"/>
                          </DesignTime>
                          <AttrArray Name="Attributes"/>
                          </Key>
                          <Key
                          Name="SysC007005">
                          <DesignTime>
                          <Attr Name="_DBObjectName" Value="SYS_C007005"/>
                          <Attr Name="_checkCondition" Value='"FIRSTNAME" IS NOT NULL'/>
                          <Attr Name="_isCheck" Value="true"/>
                          </DesignTime>
                          <AttrArray Name="Attributes">
                          <Item Value="customer.model.CustomerEO.Firstname"/>
                          </AttrArray>
                          </Key>
                          <Key
                          Name="SysC007006">
                          <DesignTime>
                          <Attr Name="_DBObjectName" Value="SYS_C007006"/>
                          <Attr Name="_checkCondition" Value='"LASTNAME" IS NOT NULL'/>
                          <Attr Name="_isCheck" Value="true"/>
                          </DesignTime>
                          <AttrArray Name="Attributes">
                          <Item Value="customer.model.CustomerEO.Lastname"/>
                          </AttrArray>
                          </Key>
                          <Key
                          Name="SysC007007">
                          <DesignTime>
                          <Attr Name="_DBObjectName" Value="SYS_C007007"/>
                          <Attr Name="_checkCondition" Value='"DOB" IS NOT NULL'/>
                          <Attr Name="_isCheck" Value="true"/>
                          </DesignTime>
                          <AttrArray Name="Attributes">
                          <Item Value="customer.model.CustomerEO.Dob"/>
                          </AttrArray>
                          </Key>
                          <Key
                          Name="SysC007008">
                          <DesignTime>
                          <Attr Name="_DBObjectName" Value="SYS_C007008"/>
                          <Attr Name="_checkCondition" Value='"ADDRESS1" IS NOT NULL'/>
                          <Attr Name="_isCheck" Value="true"/>
                          </DesignTime>
                          <AttrArray Name="Attributes">
                          <Item Value="customer.model.CustomerEO.Address1"/>
                          </AttrArray>
                          </Key>
                          <Key
                          Name="SysC007009">
                          <DesignTime>
                          <Attr Name="_DBObjectName" Value="SYS_C007009"/>
                          <Attr Name="_checkCondition" Value='"CITY" IS NOT NULL'/>
                          <Attr Name="_isCheck" Value="true"/>
                          </DesignTime>
                          <AttrArray Name="Attributes">
                          <Item Value="customer.model.CustomerEO.City"/>
                          </AttrArray>
                          </Key>
                          <Key
                          Name="SysC007010">
                          <DesignTime>
                          <Attr Name="_DBObjectName" Value="SYS_C007010"/>
                          <Attr Name="_checkCondition" Value='"STATE" IS NOT NULL'/>
                          <Attr Name="_isCheck" Value="true"/>
                          </DesignTime>
                          <AttrArray Name="Attributes">
                          <Item Value="customer.model.CustomerEO.State"/>
                          </AttrArray>
                          </Key>
                          <Key
                          Name="SysC007011">
                          <DesignTime>
                          <Attr Name="_DBObjectName" Value="SYS_C007011"/>
                          <Attr Name="_checkCondition" Value='"COUNTRY" IS NOT NULL'/>
                          <Attr Name="_isCheck" Value="true"/>
                          </DesignTime>
                          <AttrArray Name="Attributes">
                          <Item Value="customer.model.CustomerEO.Country"/>
                          </AttrArray>
                          </Key>
                          <Key
                          Name="SysC007012">
                          <DesignTime>
                          <Attr Name="_DBObjectName" Value="SYS_C007012"/>
                          <Attr Name="_checkCondition" Value='"GENDER" IS NOT NULL'/>
                          <Attr Name="_isCheck" Value="true"/>
                          </DesignTime>
                          <AttrArray Name="Attributes">
                          <Item Value="customer.model.CustomerEO.Gender"/>
                          </AttrArray>
                          </Key>
                          <Key
                          Name="SysC007013">
                          <DesignTime>
                          <Attr Name="_DBObjectName" Value="SYS_C007013"/>
                          <Attr Name="_checkCondition" Value='"PRIMARYPHONE" IS NOT NULL'/>
                          <Attr Name="_isCheck" Value="true"/>
                          </DesignTime>
                          <AttrArray Name="Attributes">
                          <Item Value="customer.model.CustomerEO.Primaryphone"/>
                          </AttrArray>
                          </Key>
                          <Key
                          Name="SysC007014">
                          <DesignTime>
                          <Attr Name="_DBObjectName" Value="SYS_C007014"/>
                          <Attr Name="_checkCondition" Value='"EMAIL" IS NOT NULL'/>
                          <Attr Name="_isCheck" Value="true"/>
                          </DesignTime>
                          <AttrArray Name="Attributes">
                          <Item Value="customer.model.CustomerEO.Email"/>
                          </AttrArray>
                          </Key>
                          <Key
                          Name="SysC007015">
                          <DesignTime>
                          <Attr Name="_DBObjectName" Value="SYS_C007015"/>
                          <Attr Name="_checkCondition" Value='"LANGUAGES" IS NOT NULL'/>
                          <Attr Name="_isCheck" Value="true"/>
                          </DesignTime>
                          <AttrArray Name="Attributes">
                          <Item Value="customer.model.CustomerEO.Languages"/>
                          </AttrArray>
                          </Key>
                          <Key
                          Name="XxCustomerdetailsPk"
                          PrimaryKey="true">
                          <DesignTime>
                          <Attr Name="_DBObjectName" Value="XX_CUSTOMERDETAILS_PK"/>
                          </DesignTime>
                          <AttrArray Name="Attributes">
                          <Item Value="customer.model.CustomerEO.Customerid"/>
                          </AttrArray>
                          </Key>
                          <ResourceBundle>
                          <PropertiesBundle
                          PropertiesFile="customer.model.CustomerModelBundle"/>
                          </ResourceBundle>
                          </Entity>
                          • 10. Re: Unable to create new rows in master detail
                            990694
                            ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                            ContactsEO.Xml file_

                            <?xml version="1.0" encoding="windows-1252" ?>
                            <!DOCTYPE Entity SYSTEM "jbo_03_01.dtd">
                            <!---->
                            <Entity
                            xmlns="http://xmlns.oracle.com/bc4j"
                            Name="ContactsEO"
                            Version="11.1.1.61.92"
                            InheritPersonalization="true"
                            DBObjectType="table"
                            DBObjectName="XX_CONTACTS"
                            AliasName="ContactsEO"
                            BindingStyle="OracleName"
                            UseGlueCode="false"
                            RowClass="customer.model.ContactsEOImpl">
                            <DesignTime>
                            <AttrArray Name="_publishEvents"/>
                            <Attr Name="_codeGenFlag2" Value="Init|Access"/>
                            <Attr Name="_isCodegen" Value="true"/>
                            </DesignTime>
                            <Attribute
                            Name="Customerid"
                            ColumnName="CUSTOMERID"
                            SQLType="NUMERIC"
                            Type="oracle.jbo.domain.Number"
                            ColumnType="NUMBER"
                            TableName="XX_CONTACTS">
                            <DesignTime>
                            <Attr Name="_DisplaySize" Value="22"/>
                            </DesignTime>
                            </Attribute>
                            <Attribute
                            Name="Contactid"
                            IsUpdateable="while_insert"
                            Precision="10"
                            Scale="0"
                            ColumnName="CONTACTID"
                            SQLType="NUMERIC"
                            Type="oracle.jbo.domain.Number"
                            ColumnType="NUMBER"
                            TableName="XX_CONTACTS"
                            PrimaryKey="true"
                            RetrievedOnInsert="true"
                            DefaultValue="0">
                            <DesignTime>
                            <Attr Name="_DisplaySize" Value="22"/>
                            </DesignTime>
                            </Attribute>
                            <Attribute
                            Name="Contactname"
                            IsNotNull="true"
                            Precision="50"
                            ColumnName="CONTACTNAME"
                            SQLType="VARCHAR"
                            Type="java.lang.String"
                            ColumnType="VARCHAR2"
                            TableName="XX_CONTACTS">
                            <DesignTime>
                            <Attr Name="_DisplaySize" Value="50"/>
                            </DesignTime>
                            </Attribute>
                            <Attribute
                            Name="Address1"
                            IsNotNull="true"
                            Precision="100"
                            ColumnName="ADDRESS1"
                            SQLType="VARCHAR"
                            Type="java.lang.String"
                            ColumnType="VARCHAR2"
                            TableName="XX_CONTACTS">
                            <DesignTime>
                            <Attr Name="_DisplaySize" Value="100"/>
                            </DesignTime>
                            </Attribute>
                            <Attribute
                            Name="Address2"
                            Precision="100"
                            ColumnName="ADDRESS2"
                            SQLType="VARCHAR"
                            Type="java.lang.String"
                            ColumnType="VARCHAR2"
                            TableName="XX_CONTACTS">
                            <DesignTime>
                            <Attr Name="_DisplaySize" Value="100"/>
                            </DesignTime>
                            </Attribute>
                            <Attribute
                            Name="City"
                            IsNotNull="true"
                            Precision="30"
                            ColumnName="CITY"
                            SQLType="VARCHAR"
                            Type="java.lang.String"
                            ColumnType="VARCHAR2"
                            TableName="XX_CONTACTS">
                            <DesignTime>
                            <Attr Name="_DisplaySize" Value="30"/>
                            </DesignTime>
                            </Attribute>
                            <Attribute
                            Name="Country"
                            IsNotNull="true"
                            Precision="100"
                            ColumnName="COUNTRY"
                            SQLType="VARCHAR"
                            Type="java.lang.String"
                            ColumnType="VARCHAR2"
                            TableName="XX_CONTACTS">
                            <DesignTime>
                            <Attr Name="_DisplaySize" Value="100"/>
                            </DesignTime>
                            </Attribute>
                            <Attribute
                            Name="State"
                            IsNotNull="true"
                            Precision="100"
                            ColumnName="STATE"
                            SQLType="VARCHAR"
                            Type="java.lang.String"
                            ColumnType="VARCHAR2"
                            TableName="XX_CONTACTS">
                            <DesignTime>
                            <Attr Name="_DisplaySize" Value="100"/>
                            </DesignTime>
                            </Attribute>
                            <Attribute
                            Name="Primaryphone"
                            IsNotNull="true"
                            Precision="100"
                            ColumnName="PRIMARYPHONE"
                            SQLType="VARCHAR"
                            Type="java.lang.String"
                            ColumnType="VARCHAR2"
                            TableName="XX_CONTACTS">
                            <DesignTime>
                            <Attr Name="_DisplaySize" Value="100"/>
                            </DesignTime>
                            </Attribute>
                            <Attribute
                            Name="Secondaryphone"
                            IsNotNull="true"
                            Precision="100"
                            ColumnName="SECONDARYPHONE"
                            SQLType="VARCHAR"
                            Type="java.lang.String"
                            ColumnType="VARCHAR2"
                            TableName="XX_CONTACTS">
                            <DesignTime>
                            <Attr Name="_DisplaySize" Value="100"/>
                            </DesignTime>
                            </Attribute>
                            <Attribute
                            Name="Email"
                            IsNotNull="true"
                            Precision="100"
                            ColumnName="EMAIL"
                            SQLType="VARCHAR"
                            Type="java.lang.String"
                            ColumnType="VARCHAR2"
                            TableName="XX_CONTACTS">
                            <DesignTime>
                            <Attr Name="_DisplaySize" Value="100"/>
                            </DesignTime>
                            </Attribute>
                            <Attribute
                            Name="Fax"
                            IsNotNull="true"
                            Precision="100"
                            ColumnName="FAX"
                            SQLType="VARCHAR"
                            Type="java.lang.String"
                            ColumnType="VARCHAR2"
                            TableName="XX_CONTACTS">
                            <DesignTime>
                            <Attr Name="_DisplaySize" Value="100"/>
                            </DesignTime>
                            </Attribute>
                            <AccessorAttribute
                            Name="CustomerEO"
                            Association="customer.model.CustomerEOtoContactsEO"
                            AssociationEnd="customer.model.CustomerEOtoContactsEO.CustomerEO"
                            AssociationOtherEnd="customer.model.CustomerEOtoContactsEO.ContactsEO"
                            Type="customer.model.CustomerEOImpl"
                            IsUpdateable="true"/>
                            <Key
                            Name="SysC007018">
                            <DesignTime>
                            <Attr Name="_DBObjectName" Value="SYS_C007018"/>
                            <Attr Name="_checkCondition" Value='"CONTACTNAME" IS NOT NULL'/>
                            <Attr Name="_isCheck" Value="true"/>
                            </DesignTime>
                            <AttrArray Name="Attributes">
                            <Item Value="customer.model.ContactsEO.Contactname"/>
                            </AttrArray>
                            </Key>
                            <Key
                            Name="SysC007019">
                            <DesignTime>
                            <Attr Name="_DBObjectName" Value="SYS_C007019"/>
                            <Attr Name="_checkCondition" Value='"ADDRESS1" IS NOT NULL'/>
                            <Attr Name="_isCheck" Value="true"/>
                            </DesignTime>
                            <AttrArray Name="Attributes">
                            <Item Value="customer.model.ContactsEO.Address1"/>
                            </AttrArray>
                            </Key>
                            <Key
                            Name="SysC007020">
                            <DesignTime>
                            <Attr Name="_DBObjectName" Value="SYS_C007020"/>
                            <Attr Name="_checkCondition" Value='"CITY" IS NOT NULL'/>
                            <Attr Name="_isCheck" Value="true"/>
                            </DesignTime>
                            <AttrArray Name="Attributes">
                            <Item Value="customer.model.ContactsEO.City"/>
                            </AttrArray>
                            </Key>
                            <Key
                            Name="SysC007021">
                            <DesignTime>
                            <Attr Name="_DBObjectName" Value="SYS_C007021"/>
                            <Attr Name="_checkCondition" Value='"STATE" IS NOT NULL'/>
                            <Attr Name="_isCheck" Value="true"/>
                            </DesignTime>
                            <AttrArray Name="Attributes">
                            <Item Value="customer.model.ContactsEO.State"/>
                            </AttrArray>
                            </Key>
                            <Key
                            Name="SysC007022">
                            <DesignTime>
                            <Attr Name="_DBObjectName" Value="SYS_C007022"/>
                            <Attr Name="_checkCondition" Value='"COUNTRY" IS NOT NULL'/>
                            <Attr Name="_isCheck" Value="true"/>
                            </DesignTime>
                            <AttrArray Name="Attributes">
                            <Item Value="customer.model.ContactsEO.Country"/>
                            </AttrArray>
                            </Key>
                            <Key
                            Name="SysC007023">
                            <DesignTime>
                            <Attr Name="_DBObjectName" Value="SYS_C007023"/>
                            <Attr Name="_checkCondition" Value='"PRIMARYPHONE" IS NOT NULL'/>
                            <Attr Name="_isCheck" Value="true"/>
                            </DesignTime>
                            <AttrArray Name="Attributes">
                            <Item Value="customer.model.ContactsEO.Primaryphone"/>
                            </AttrArray>
                            </Key>
                            <Key
                            Name="SysC007024">
                            <DesignTime>
                            <Attr Name="_DBObjectName" Value="SYS_C007024"/>
                            <Attr Name="_checkCondition" Value='"SECONDARYPHONE" IS NOT NULL'/>
                            <Attr Name="_isCheck" Value="true"/>
                            </DesignTime>
                            <AttrArray Name="Attributes">
                            <Item Value="customer.model.ContactsEO.Secondaryphone"/>
                            </AttrArray>
                            </Key>
                            <Key
                            Name="SysC007025">
                            <DesignTime>
                            <Attr Name="_DBObjectName" Value="SYS_C007025"/>
                            <Attr Name="_checkCondition" Value='"EMAIL" IS NOT NULL'/>
                            <Attr Name="_isCheck" Value="true"/>
                            </DesignTime>
                            <AttrArray Name="Attributes">
                            <Item Value="customer.model.ContactsEO.Email"/>
                            </AttrArray>
                            </Key>
                            <Key
                            Name="SysC007026">
                            <DesignTime>
                            <Attr Name="_DBObjectName" Value="SYS_C007026"/>
                            <Attr Name="_checkCondition" Value='"FAX" IS NOT NULL'/>
                            <Attr Name="_isCheck" Value="true"/>
                            </DesignTime>
                            <AttrArray Name="Attributes">
                            <Item Value="customer.model.ContactsEO.Fax"/>
                            </AttrArray>
                            </Key>
                            <Key
                            Name="XxContactidPk"
                            PrimaryKey="true">
                            <DesignTime>
                            <Attr Name="_DBObjectName" Value="XX_CONTACTID_PK"/>
                            </DesignTime>
                            <AttrArray Name="Attributes">
                            <Item Value="customer.model.ContactsEO.Contactid"/>
                            </AttrArray>
                            </Key>
                            <Key
                            Name="XxContactCustomeridFk">
                            <DesignTime>
                            <Attr Name="_referencedKey" Value="XX_CUSTOMERDETAILS_PK"/>
                            <Attr Name="_isForeign" Value="true"/>
                            <Attr Name="_DBObjectName" Value="XX_CONTACT_CUSTOMERID_FK"/>
                            </DesignTime>
                            <AttrArray Name="Attributes">
                            <Item Value="customer.model.ContactsEO.Customerid"/>
                            </AttrArray>
                            </Key>
                            <Key
                            Name="fk_ContactsEO">
                            <DesignTime>
                            <Attr Name="_isCascadeDelete" Value="true"/>
                            <Attr Name="_referencedKey" Value="XX_CUSTOMERDETAILS_PK"/>
                            <Attr Name="_isForeign" Value="true"/>
                            <Attr Name="_DBObjectName" Value="FK_CONTACTS_EO"/>
                            </DesignTime>
                            <AttrArray Name="Attributes">
                            <Item Value="customer.model.ContactsEO.Customerid"/>
                            </AttrArray>
                            </Key>
                            <Key
                            Name="fk_ContactsEO1">
                            <DesignTime>
                            <Attr Name="_referencedKey" Value="XX_CUSTOMERDETAILS_PK"/>
                            <Attr Name="_isForeign" Value="true"/>
                            <Attr Name="_DBObjectName" Value="FK_CONTACTS_EO1"/>
                            </DesignTime>
                            <AttrArray Name="Attributes">
                            <Item Value="customer.model.ContactsEO.Customerid"/>
                            </AttrArray>
                            </Key>
                            </Entity>
                            • 11. Re: Unable to create new rows in master detail
                              990694
                              ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                              CustomerEOToContactsEO.xml (Association)_

                              <?xml version="1.0" encoding="windows-1252" ?>
                              <!DOCTYPE Association SYSTEM "jbo_03_01.dtd">
                              <!---->
                              <Association
                              xmlns="http://xmlns.oracle.com/bc4j"
                              Name="CustomerEOtoContactsEO"
                              Version="11.1.1.61.92"
                              InheritPersonalization="true">
                              <DesignTime>
                              <Attr Name="_isCodegen" Value="true"/>
                              </DesignTime>
                              <AssociationEnd
                              Name="CustomerEO"
                              Cardinality="1"
                              Source="true"
                              Owner="customer.model.CustomerEO"
                              LockLevel="NONE"
                              CascadeUpdate="true">
                              <DesignTime>
                              <Attr Name="_aggregation" Value="0"/>
                              <Attr Name="_finderName" Value="CustomerEO"/>
                              <Attr Name="_isUpdateable" Value="true"/>
                              <Attr Name="_minCardinality" Value="1"/>
                              </DesignTime>
                              <AttrArray Name="Attributes">
                              <Item Value="customer.model.CustomerEO.Customerid"/>
                              </AttrArray>
                              </AssociationEnd>
                              <AssociationEnd
                              Name="ContactsEO"
                              Cardinality="-1"
                              Owner="customer.model.ContactsEO"
                              HasOwner="true">
                              <DesignTime>
                              <Attr Name="_aggregation" Value="0"/>
                              <Attr Name="_finderName" Value="ContactsEO"/>
                              <Attr Name="_isUpdateable" Value="true"/>
                              </DesignTime>
                              <AttrArray Name="Attributes">
                              <Item Value="customer.model.ContactsEO.Customerid"/>
                              </AttrArray>
                              </AssociationEnd>
                              </Association>
                              ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
                              CustomerVOToContactsVO.xml (ViewLink)_

                              <?xml version="1.0" encoding="windows-1252" ?>
                              <!DOCTYPE Association SYSTEM "jbo_03_01.dtd">
                              <!---->
                              <Association
                              xmlns="http://xmlns.oracle.com/bc4j"
                              Name="CustomerEOtoContactsEO"
                              Version="11.1.1.61.92"
                              InheritPersonalization="true">
                              <DesignTime>
                              <Attr Name="_isCodegen" Value="true"/>
                              </DesignTime>
                              <AssociationEnd
                              Name="CustomerEO"
                              Cardinality="1"
                              Source="true"
                              Owner="customer.model.CustomerEO"
                              LockLevel="NONE"
                              CascadeUpdate="true">
                              <DesignTime>
                              <Attr Name="_aggregation" Value="0"/>
                              <Attr Name="_finderName" Value="CustomerEO"/>
                              <Attr Name="_isUpdateable" Value="true"/>
                              <Attr Name="_minCardinality" Value="1"/>
                              </DesignTime>
                              <AttrArray Name="Attributes">
                              <Item Value="customer.model.CustomerEO.Customerid"/>
                              </AttrArray>
                              </AssociationEnd>
                              <AssociationEnd
                              Name="ContactsEO"
                              Cardinality="-1"
                              Owner="customer.model.ContactsEO"
                              HasOwner="true">
                              <DesignTime>
                              <Attr Name="_aggregation" Value="0"/>
                              <Attr Name="_finderName" Value="ContactsEO"/>
                              <Attr Name="_isUpdateable" Value="true"/>
                              </DesignTime>
                              <AttrArray Name="Attributes">
                              <Item Value="customer.model.ContactsEO.Customerid"/>
                              </AttrArray>
                              </AssociationEnd>
                              </Association>

                              ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                              I hope this is what you asked Raj, Plz correct me if i am doing anything wrong..

                              Thanks
                              -Ani
                              • 12. Re: Unable to create new rows in master detail
                                990534
                                Hi Ani,
                                I have few questions on why you did like this
                                1) The trigger XX_CUSTOMER_CUSTOMERID_TRIG is setting the customer id for insert update and delete operations !!!! I think it should be only for insert as it is the sequence number.
                                2)You are trying to implement sequence numbers both by a trigger and java code in business layer. Here XX_CONTACT_CONTACTID_TRIGGER and the method below it do the same.
                                Can you please tell me why are you using different methods at once to achieve the same functionality ??.

                                Assuming usage of trigger for inserting sequences in both cases it's working fine when i go with table import wizard . If you still have issues please post your workspace zip to my email rajasekhar1503@gmail.com


                                Thanks,
                                Raj.

                                Edited by: RajaSekharReddy.M on Feb 19, 2013 7:03 AM