Creating rows in parent and child VO connected using a VL

Hi,

Today I got stuck with the requirement where I had to display the parent and child in the input mode. My problem was I am having two VOs both are connected to each other using a view link and both are having the id column. This column is a primary key for the Employee table and foreign key for the Description table which in tern also have a id column.

so my database schema is like this.


EQUITY_USERS
Name Null Type
------------------- -------- --------------
USERID NOT NULL NUMBER
USER_NAME NOT NULL VARCHAR2(20)
FULL_NAME VARCHAR2(20)
ACTIVATION_FLAG NOT NULL VARCHAR2(10)
DEACTIVATION_REASON VARCHAR2(2000)
ADMINUSERID NUMBER
LAST_UPDATED_DATE NOT NULL DATE
LAST_UPDATED_BY VARCHAR2(20)
USER_TYPE VARCHAR2(10)
INSERTED_DATE DATE

and

desc EQUITY_USERS_ADDITIONAL_INFO
Name Null Type
------------- -------- -------------
USER_ID NOT NULL NUMBER
ADDRESS_LINE2 VARCHAR2(200)
PHONE_NUMBER VARCHAR2(20)
MOBILE_NUMBER VARCHAR2(20)
EMAIL_ID VARCHAR2(50)
CITY VARCHAR2(200)
STATE VARCHAR2(200)
PIN_CODE VARCHAR2(20)
ADDRESS_LINE3 VARCHAR2(200)
ADDRESS_LINE1 VARCHAR2(200)

Now I have two EO bases on this table and then two VOs bases on the same EOs. These two VOs are connected using a view link using id column. In the page I have dropped both the VOs as form with input box. But the problem I faced that even if I call create method of both the VOs before the page rendering the second VO was not rendering with the input box, or say row is not been created in the second row.

After a number of try what I did is create a method in AM and called this method before the page. The code which I need to write in this is


Row userRow = this.getEquityUsersVO().createRow();
this.getEquityUsersVO().insertRow(userRow);

Row userAdditionalRow= this.getEquityUserVOToEquityUserAdditionalInfoVO1().getDestination().createRow();
this.getEquityUserVOToEquityUserAdditionalInfoVO1().getDestination().insertRow(userAdditionalRow);



so what this code is doing its first creating the row in the first VO (parent) and then its inserting also so if any sequence code is there in the create method of the VO can be executed and then calling the create and insert for the child VO using the viewlink so that the same id can be transferred to the child automatically.


Now my form is opening properly

Comments

Post a Comment

Popular posts from this blog

Executing a method bindings In Bean method.

Image
Many time you be in a situation where there is a AM method exposed as a client and requirement is to execute that AM method from the backing bean. Its quite simple first you have to register that AM method in the page definition file as method bindings. Now choose the method you want to add to the page definition and executed by a bean method. for the parameter either you can use the bindings if your parameter clearly coming from bindings else leave them blank. Now in the bean method first you have to catch the handle of the DCBindingContainer and then using this binding container you can get the operation binding for the AM method and then can add the parameter. If you are have already bind the parameter with the bindings then can skip that. then you just need to call the execute method of your operation binding.
Read more

Using Java Decompiler(JD) with Oracle Jdeveloper (Jdev)

Image
  Java Decompiler(JD) with Oracle Jdeveloper (Jdev) Java Decompiler is a good tool to check the code, when we just have complied code.  There are ways by which you can check the code, which is been in form of jar with you.   Let say you got ADF Jar file for a project and now want to check, what is the code inside of an entity object IMpl or how this code is structured.  There are some simple steps to it. 1. Create an ADF application with mode and UI project. If you have more project, try to keep the name of the model same as jar. Here I have two jars to check. employee Model.jar and employeeUI.jar.   2. Now go to you jars and then unzip these jars using the unzip or 7 zip prog. 3. Once you done with the unzip then place these directries under the application and project you have created. Please have model code paste under src directory only. 4. Refresh the application now and you will be able to see ...
Read more

Current Logged in User and Roles in ADF and Fusion Apps

A) Using the groovy Expression. We can set default expression in view object attribute as below  adf.context.securityContext.getUserPrincipal().getName()  adf.context.securityContext.getUserName()    For Roles use  adf.context.securityContext.getUserRoles() B) Java Code You can get User Name in Java code also using the following code. ADFContext adfCtx = ADFContext.getCurrent(); SecurityContext secCntx = adfCtx.getSecurityContext(); String user = secCntx.getUserPrincipal().getName(); String userName = secCntx.getUserName(); String[] Roles = secCntx.getUserRoles(); C) Expression  Language You can bind ADF Faces componenets with the following EL to get logged User Name. #{securityContext.userName} #{securityContext.userRoles} D) In Fusion Applications (On Premise Implementation) ApplSession session = ApplSessionUtil.getSession(); String guid1 = session.getUse...
Read more