This discussion is archived
12 Replies Latest reply: Feb 19, 2013 7:12 AM by 990534 RSS

Unable to create new rows in master detail

990694 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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 Newbie
    Currently Being Moderated
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points