How to Add New Field in ADF jDeveloper

Add New Field in Oracle SQL

    ALTER TABLE PWC_MFG_PRINTING_QUANTITY_H

    ADD CHILD_STYLE_NO VARCHAR2(255)

After adding field in database, you need to add this field in your ADF jDeveloper. From the following steps you can easily to add field in you ADF jDeveloper

Step 1:

• Open your form in ADF jDeveloper, Open you Entity Objects (EO) / Tables, Right click on the Table where you want to add you field, select Synchronize with Database.
• After click you will see popup in your screen. In this popup you need to the select that field and click on Synchronize button, you will see another popup, click on OK button, then click on previous popup OK button.

Step 2:

• Now adding field in you Entity Ojbect, go the View Object (VO), go the that Table View where you want to add that field. Click on it.
• Now click on Query Table.
• Click on Edit (Pen 🖊) Button

Step 3:

• Type you field name in View Object
• Now click on Attribute Mapping (It is database field not Calculation or Transient Field)

Step 4:

• In Arribute Mapping, find your field (ChildStyleNo) which you have added in you View Object (VO), That field should be xyz icon (it's mean that your fild is a database field).

Step 5:

• After completing these all above steps, go to the Data Control Tab, refresh it. Now you will se your field has been added, you can easily drag and drop in you Form.