Oracle JHeadstart 10g Designer Generator Reference

JHeadstart Image

Release 10.1.2

This Reference contains the following sections:

Introduction

For best printing results, set Orientation to Landscape!

The JHeadstart Designer Generator uses the meta-data stored in an Oracle Designer 6i or 9i Repository to generate input files required by the JHeadstart Application Generator. Thereafter the JHeadstart Application Generator can be used to generate a transaction-based application using a Model-View-Controller Architecture. In short, the JHeadstart Designer Generator generates the following objects:

  • a domain definition file that contains the definitions of all static domains
  • an Application Structure file
  • ADF Entity Objects
  • ADF Associations
  • ADF View Objects
  • ADF View Link Objects
  • ADF Application Module

The ADF (Application Development Framework) objects created will have a collection of so called Custom Properties, representing additional properties of Entities, Views and Attributes over and above the standard ADF properties. This document provides an overview of how the definitions (elements and properties) in Designer translate to the objects and files generated by the JHeadstart Designer Generator (looking forward).

Note: the hyperlinks in the bug/enhancement numbers refer to an Oracle internal website.

Oracle Designer Elements

This section describes the Element level mapping from Oracle Designer into ADF and JHeadstart definition files.

Server Model Objects

Table/View Object ADF Object Comment Related bug#
Table Definition/ View Definition BC4J Entity Object

Column Attribute

Primary Key Entity Constraint with Key Type Primary These are meant for forward generation into the database, so these will have no impact on the BC4J runtime behavior.
Unique Key Entity Constraint with Key Type Unique These are meant for forward generation into the database, so these will have no impact on the BC4J runtime behavior.
Check Constraint Entity Constraint with Key Type Check These are meant for forward generation into the database, so these will have no impact on the BC4J runtime behavior.
Domain Key Constraint Not Processed

Foreign Key Entity Constraint with Key Type Foreign,
View Link, and
Entity Association
The entity constraints are meant for forward generation into the database, so these will have no impact on the ADF runtime behavior. Associations implement the run-time Foreign Keys in ADF 2345857
Key Column (Key Component) Key Component
EO Attribute – Primary Key indicator


Table Trigger Not Processed

Base Table Usage (view only) Not Processed For views with free format set to No the base table usage is used to form the VO query.
Index Not Processed

Synonyms Not Processed

Table API/Trigger Logic Not Processed

Domain usage Validation Rule for EO attribute

Domain Domain Definition File Object Comment Related bug#
Domain Domain entry Only static enumerated domains are processed.
Allowable Value Allowable Value


Module Objects

Module Definition Type of ADF Object Comment Related Bug#
Arguments Not Processed

List of Values ADF View Object. Row LOV’s are handled differently.

If the MCO to which the ROW LOV belongs is single record, then the group layout will be select-form. A concatenated transient attribute is created with all the displayed lov items, and is used as the descriptorAttribute in the group definition.

If the MCO to which the ROW LOV belongs is multi record, then a find page is created with the row lov items displayed.

Module Component ADF View Object

Key Based (Module Component) Link ADF View Link

Detail Table Usage Entity Usage (in View Object)

Data Bound Item ADF VO Attribute

Unbound Item ADF VO Attribute

Navigation Item Planned for later release

Action Item Planned for later release

Item Group Region. Impacts order of ADF VO Attributes

User Preference<</small> Not Processed

Application Logic Not Processed

Sub-component Part of ADF View Object All items in al sub-component are folded into a single View Object, the same as the main VO. 2268380
Called Modules (Module Network) Not Processed

Module Elements Mapping in Application Structure File Comment Related Bug#
Module
Impacts Group definitions and ADF VO definitions


Module Component
with “Children”
with “Master, no children”
with Master and with Children
Group
base or root Group
nested Group
base and nested Group


LOV Inclusion Lookup

Item Group Region

Window Impacts Group definitions



Oracle Designer Server Model Properties

Oracle Designer Elements




Table / View Properties Translated into Additional Comment Example Related Bug#
Name Name of Entity Object. For each word or phrase of the table name, this is changed to initcap, and any underscores are removed.
The Entity Object will be based on a schema object with a name identical to the table name.
When the JDG is run, it will use the name to find out whether a mapped Entity Object already exists. For table MSW_PERSONS the name of the created Entity Object will be MswPersons.
Version Planned for later relase


Alias N/A


Col. Prefix N/A


Display Title Custom Property “Display Title” against the ADF Entity Object
Display Title: Maintain Requests
Object Table N/A


Journal N/A


Volume properties N/A


Storage properties N/A


Data Warehouse Type N/A


Documentation - Comment N/A


Documentation - Description, Notes, User Help Text N/A


Visual Basic / C++ properties N/A


Column Properties Translated into Additional Comment Example Related Bug#
Name
Name of Entity Object Attribute. For each word or phrase of the Column name, this is changed to initcap, and any underscores are removed.
The Attribute will be based on a column in the table on which the Entity Object is based in the database. This column name will be identical to the column name used in Oracle Designer.
DEPARTMENT_NAME becomes DepartmentName

Version N/A


Sequence in Table Planned for future relase

3894310
Complete? Planned for future release

3894301
Domain Custom property “Domain” on the EO Attribute, and List or Range Validator of the EO Attribute. The “Domain” custom property is only included if it is static and contains a set allowable values. This means that if the domain is used to the format (datatype, length etc.) or ranges no “Domain” property will be included.
If the domain is static, a List Validator is created, and if it is dynamic, a Range Validator is created.
Domain : YESNO 3810005
Def Template/Library Object N/A


Scalar - Datatype Database Column Type for the EO Attribute. Oracle Designer Datatypes are translated as follows:
BFILE BfileDomain
BLOB BlobDomain
CHAR String
CLOB ClobDomain
DATE Date
DECIMAL Number
DOUBLE PRECISION Number
FLOAT Number
INTEGER Number
INT Number
LONG String
LONG RAW Raw
NUMBER Number
NUMERIC Number
NVARCHAR2 String
RAW Raw
REAL Number
ROWID RowID
SMALLINT Number
TEXT String
TIME Date
TIMESTAMP Date
VARCHAR2 String
VARGRAPHIC String

The following datatypes are not translated:
CHARACTER in db VARCHAR2(240)
DEC in db VARCHAR2(240)
GRAPHIC in db LONG RAW
IMAGE in db(8i) LONG RAW
in db(9i) BLOB
INTERVAL DAY TO SECOND in db(8i) VARCHAR2(31)
in db(9i) INTERVAL DAY TO SECOND
INTERVAL YEAR TO MONTH in db(8i) VARCHAR2(31)
in db(9i) INTERVAL YEAR TO MONTH
LONG VARCHAR in db LONG VARCHAR
LONG VARGRAPHIC in db LONG RAW
MLSLABEL in db MLSLABEL
NCHAR in db NCHAR
NCLOB in db NCLOB
SOUND in db (8i) LONG RAW
in db(9i) BLOB
TEXT in db (8i) LONG
in db(9i) BLOB
TIMESTAMP WITH LOCAL TIMEZONE in db (8i) DATE
in db(9i) TIMESTAMP WITH LOCAL TIMEZONE
TIMESTAMP WITH TIMEZONE in db (8i) DATE
in db(9i) TIMESTAMP WITH TIMEZONE
UROWID in db UROWID
VARGRAPHIC in db VARCHAR2(240)
VIDEO in db VARCHAR2(240)

2266239
Scalar - Average Length N/A


Scalar - Maximum Length Length of the datatype for the corresponding attribute
VARCHAR2(2000)
Scalar - Decimal Places Decimal places of the datatype for the corresponding attribute
NUMBER(8,2)
Object properties N/A


Definition - Optional? Mandatory property of the ADF EO Attribute.

A check condition is created to actually verify that the column is not null, when Optional? is No.
If Optional is Yes, then the ADF mandatory property is unchecked.
If Optional is No and Server Derived is No, then the ADF mandatory property is checked.
However, if Optional is No and Server Derived is Yes, then the ADF mandatory property is unchecked. The reason for this is that if the attribute value should be derived from the server it is important that the client will not force the end user to enter a value.
Check condition: “PRIORITY” IS NOT NULL
Definition - Uppercase? Custom property “Uppercase/Lowercase” for the EO Attribute.. When Uppercase? is set to Y, “Uppercase/Lowercase” will be set to upper. In all other cases, “Uppercase/Lowercase” is not set by the JDG.
JAG does not use this property.


Definition - Default Value Either set as ADF Default Property, or as custom property “Complex Default” against the EO Attribute. The Default Value Type determines where the value is set. JAG does not use “Complex Default”. It is there to indicate to the developer that the default needs to be implemented as a post-generation step.
2249148
Definition - Default Value Type Determines whether ADF Default property or custom property “Complex Default” should be used. If Default Value Type is Literal then the BC4J Default property is used, otherwise “Complex Default” is used.

Definition - Sequence Planned for later release

2249148
Definition - Cluster Column N/A


Volumes properties N/A


Default Display - Display? Custom property “Display” for the corresponding ADF EO attribute. When Display? is Yes Display=true,
otherwise Display=false.


Default Display - Display Type? Custom property “Display Type” for the corresponding ADF EO attribute.
Designer Display Type JHeadstart Display Type
Text
editor if the display width is less than the maximum length and the display height is 1
dateField if it is a date
textInput in all other cases.
Check box checkBox
Combo box <none>
Descriptive Flexfield <none>
Image <none>
OLE Container <none>
Poplist choice
Radio Group (Across) radioAcross
Radio Group (Down) radioDown
Text List <none>
OCX Control <none>
Display Item displayField


Default Display - Alignment Planned for later release

2389531
Default Display - Display Length Custom property “Width” for the corresponding BC4J EO attribute.
Width: 30
Default Display - Display Height Custom property “Heigth” for the corresponding BC4J EO attribute.
Heigth: 3
Default Display - Display Sequence N/A See Display Sequence of Bound Items.

Default Display - Descriptor Sequence The Descriptor with Descriptor Sequence 1 becomes the “Descriptor Attribute” in Group definitions that use the corresponding EO as the datasource. If no descriptor column is defined, then the first displayed item in the module component will be used as the “Descriptor Attribute”. Descriptor Attribute: Name
Default Display - Format Mask Custom property “Format Mask” for the corresponding attribute. JAG does not use this property.

Default Display - Formatting Not Used


Default Display - Prompt Custom property “Prompt” for the corresponding attribute
Prompt: Description
Default Ordering properties N/A See Order By Sequence of Bound Items.

Denormalization properties Not Used Note that if the Server Derived is set to Yes, then the Table API handles this.

Derivation - AutoGen Type If the AutoGen Type is a history type then the History Column attribute is checked for the corresponding EO attribute, and the type is specified.
AutoGen Type Translated into
Created By History Column: created by
Date Created History Column: created on
Date Modified History Column: modified on
Modified By History Column: modified by
Seq in Parent Not translated


Derivation - Server Defaulted When set to Yes, the ADF attribute properties ‘Refresh After Insert’ and ‘Refresh After Update’ are checked. Further, if the column is mandatory, the corresponding attribute is set to optional so that the client does not force a value to be entered.


Derivation - Server Derived When set to Yes, the ADF attribute properties ‘Refresh After Insert’ and ‘Refresh After Update’ are checked. Further, if the column is mandatory, the corresponding attribute is set to optional so that the client does not force a value to be entered.


Derivation - Derivation Expression Not Used See also Derivation - Server Derived

Derivation - Derivation Expression Type Not Used See also Derivation - Server Derived

Source Attribute N/A


Validation properties Not Used


Help - Hint Custom property “Hint Text” for the corresponding attribute.


Help - User/Help Text N/A


Documentation properties N/A


Field properties N/A


Allowable value List or range validator for EO attribute If there is no high value he validator is a List Validator with the actial allowable values given. If there is a high value present, then a range validator is created with the value as the minimum value and the high value as the maximum value.
3894319
Primary Key Properties Translated into Additional Comment Example Related Bug#
Name Name of Entity Constraint (Key). For each word or phrase of the primary key name, this is changed to initcap, and any underscores are removed.
MSC_PK is translated into MscPk
Version N/A


Complete? Value determines whether key is created. Even when the complete property is No for the primary key, the key is generated as every EO must have a primary key

Enable? Not used  

Update? N/A


Validation - Validate In Not used.

3894314
Validation - Defer Status Not used.  
3894314
Validation - Error Message N/A


Validation Exceptions Table N/A


Source - Unique Identifier N/A


Documentation properties N/A


Primary Key Column Selected attribute for Entity Constraint (Key) The attribute in the ADF EO that corresponds to the primary key column is in the selected attribute list for the Key.

Domain Properties Translated into Additional Comment Example Related Bug#
Name Name attribute in the Domain Definition File. Only static enumerated domains with no ranges are transformed. Domain name in Oracle Designer: YESNO
Domain Definition File:

<DomainSet>
  <Domain name="YESNO">
  (...)
</DomainSet>


Version N/A


Subset of N/A


Authority N/A


Attributes in Domain properties N/A


Columns in Domain properties N/A


Documentation properties N/A


Domain - Allowable Value Properties Translated into Additional Comment Example Related Bug#
Value Value attribute in AllowableValue in Domain Definition File. If no meaning is given for the domain, it is also translated into the meaning in the domain definition.
If the domain is static, it is also generated as a value in the list validator.
If the domain is dynamic (i.e there is also a High Value) then this is not processed into the domain definition file, but as a range validator. The value is translated into the minimum value of the range validator.

Domain Definition File:
<DomainSet>
  <Domain name="YESNO">
    <AllowableValue value="Y" meaning="Yes"/>
    <AllowableValue value="N" meaning="No"/>
</DomainSet>

Version N/A


Value Type Planned for later release.


High Value If there is a High Value it indicates that it is a range domain. This is not processed into the domain definition file, but as a range validator. The high value is translated into the maximum value of the range validator.


High Value Type N/A


Abbreviation N/A


Meaning Meaning attribute in AllowableValue in Domain Definition File.
See the given example for the Value property.
Display Sequence Determines the sequence of the AllowableValues in the Domain Definition File.


Documentation properties N/A


Oracle Designer Module Properties

Module Objects

Module Properties Translated into Additional Comment Example Related Bug#
Short Name Together with the name of the Module Component used to form the name of the:
  • ADF View Object for MCO’s as follows:
    <Modified module short name><Modified module component name>ViewObject
  • Name of GROUP in Application Structure File as follows:
    <MCO NAME><MODIFIED MODULE SHORT NAME>
  • ADF View Object for LOVs as follows:
    >Modified module short name><Modified LOV name>LovViewObject
The name is changed into a single word by removing all the spaces, making all the leggers lowercase, with the exception of the first letter for each word, which is used in upperacse to build the name of the ADF VO.

To form the GROUP name, the name is again changed into a single word by removing all the spaces, but the name is all in uppercase.
Module Short Name MOSCOW REQUEST and MCO Name MIM2 is changed into:
ADF VO Name:
MoscowREquestsMim2ViewObject
GROUP name:
MIM2MOSCOWREQUESTS
3894325
Version Planned for later release.


Name N/A


Language N/A


Purpose N/A


Implementation Name N/A


Module Type Only Modules with Default Module Type are processed.


Top Title Not used


Bottom Title Not used


Short Title Tab name of the top level group created for the module


Layout Format Not used


Planning properties N/A


Invocation properties N/A


Source path N/A


Help properties N/A


Documentation properties N/A


 
List of Value Properties Translated into Additional Comment Example Related Bug#
Name Together with the short name of the Module used to form the name of the:
  • ADF View Object as follows:
    <Modified Module short name><Modified LOV Name>LovViewObject

  • Name of LOOKUP in Application Structure File as follows:
    <LOVNAME>_<MCONAME>_<ITEMNAME>
Each word of the LOV is changed to initcap, and any underscores are removed to form parts of the ADF VO object name. Module Name ENTER MOSCOW REQS, Module Component Name MRQ and LOV Name STATUS_LOV.  The item from which the LOV is activated is STS_ID.

This is changed into ADF VO name: StatusLovEntermoscowreqsLovView
and the LOOKUP name:
STATUS_LOV_MRQ_STS_ID

3894325
Version N/A


Short Description N/A


Template/Library Object N/A


Usage sequence Not used.


Item baseDisplayAttribute in the lookup definition in the Application Structure File The attribute in the ADF VO corresponding to the item is selected as the baseDisplayAttribute ITEM: L_STS_MEANING
b
aseDisplayAttribute : LStsMeaning

Return List lookupDisplayAttribute, baseValueAttribute and lookupValueAttribute in the lookup definition in the Application Structure File


Filter before display? N/A


Restriction - Used for The lov may be used in both data entry pages and find pages, therefore this property is ignoerd.


Restriction - Additional Restriction The Additional Restriction is included in the whereclause of the VO representing the LOV.


Restriction - Restriction Clause Planned for future release The generated additional restriction is generated as if this value is Default (or Where).
3894329
Placement properties N/A


Display - Title title in the lookup definition in the Application Structure File This is only used if Title Override is null

Display - Layout Style Not Used The display type of the item from which the lov is activated determines the layout style for the lookup that is the item in the Item property of the Lov.

Display - Rows Displayed N/A


Display - Title Override title in the lookup definition in the Application Structure File


Size properties N/A


Help properties N/A


Documentation properties N/A


Module Component Properties Translated into Additional Comment Example Related Bug#
Name Together with the short name of the Module used to form the name of the:
  • ADF View Object as follows:
    Modified Module name><Modified MCO Name>ViewObject
  • Name of GROUP in Application Structure File as follows:
    <MCO NAME><MODIFIED MODULE NAME>

Also used to determine Oracle Headstart/Headstart for Apps Query Find features. If the name of the MCO starts with QF_ the MCO is handled as if it is a Query Find window. A VO or a GROUP will NOT be created.
The name is changed into a single word by removing all the underscores, making all the letters lowercase, with the exception of the first letter, which is used in uppercase to build the name of the ADF VO.

To form the GROUP name, the name is again changed into a single word by removing all the underscores, but the name is all in uppercase.
Module Name ENTER MOSCOW REQUEST and MCO Name MIM_2 is changed into

ADF VO name:
Mim2EntermoscowrequestsView

and into GROUP name:
MIM2ENTERMOSCOWREQUESTS
3894325
Version N/A


Short Description N/A


Template/Library Object Used in specific situations to determine whether specific Oracle Headstart functionality has been used. If the Template/Library Object is:
QMSSO$MSEL_BLOCK and the name of the module component starts with ML_ then the module component is handled as a multi select lov.


Language N/A The language for the Module is used to determine whether or not the module can be processed by the JDG.

Module Level? Not Used


Usage sequence Determines sequence in which MCO’s are processed when other dependencies are not available. Other dependencies are used first, such as master/detail relationships.

Placement - Window Together with the Placement - Placement property determines the value of the Group Attribute: samePage samePage=true when:
- the MCO is located on the same window as the previous MCO
- there exists a Key Based Link between these MCO’s
- the Placement property is NOT New stacked canvas, or NewTab Canvas.
This is the main rule, Some exceptions to the rule exist (see below).


Placement - Placement Together with the Placement - Window property determines the value of the Group Attribute: samePage samePage=true when Placement is
Same content canvas, Same tab canvas page or Same stacked canvas page,and Key based Link exists between previous and this MCO, UNLESS the previous MCO is located on a different window, and the previous MCO has number of rows set to 1.


Placement - Right of Component Not used


Placement - Placement Template/Library Obj Not used


Placement - X position N/A


Placement - Y position N/A


Relative Tab Stops Not used


Data properties N/A


Operations - Insert? Group Attribute: insert Yes : insert=true; No: insert=false

Operations - Delete? Group Attribute: delete Yes : delete=true; No: delete=false

Operations - Update? Group Attribute: update Yes : update=true; No: update=false

Query properties N/A


Display - Title Group Attribute tabName and displayTitle
(singular and plural)



Display - Layout Style N/A


Display - Rows Displayed Group Attribute: tableRangeSize, and together with the Display - Overflow property determines the value of the Group Attribute: layoutStyle If Rows Displayed is 1 or null it translates to layoutStyle form.
Display - Overflow If Rows Displayed property > 1 then Overflow determines the value of the Group Attribute: layoutStyle
Overflow Property Group Layout style
null Form
Wrap line Table
Overflow area right table-form
Overflow area below table-form
Spreadtable table


Size properties Not used


Help properties N/A


Documentation properties N/A


Table Usage Properties (MCO and LOV) Translated into Additional Comment Example Related Bug#
Usage Alias Not used


Version N/A


Name in Database Not used


Partition N/A


Usage Type Determines how the table usage should be handled while creating/updating the ADF VO For Usage Type LOOKUP the corresponding EO is included in the ADF VO created for the base table usage.

Query - Where/Validation Condition Is included in the whereclause of the generated VO.


Query - Select Distinct Not Used


Link - Link To Lookup to become a part of ADF VO for base table. All bound items are included in the ADF VO for the base table.

Link - Via Join Constraint Determines the join condition between the lookup and base table in the query statement of the BC4J VO for the base table.


Link - Outer Join Adds outer join to the where clause in the ADF VO query statement.
(Nte.PRN_ID = LPrx.ID (+)) 3894332
Lookup - Validation Where Clause Not Used


Sub Query - Not Exists Not Used


Tree Walk properties N/A


Documentation properties N/A


Item Group Properties Translated into Additional Comment Example Related Bug#
Name Name of Region in Application Structure File.


Version N/A


Parent Item Group Not Used


Template/Library Object N/A


Display - Prompt Title of region in Application Structure File


Display - Layout Format N/A


Display - Orientation Not used.


Display - Stacked Stack regions property of the Region.


Relative Tab Stops properties Not Used


Reports Break Group properties N/A


Help - User/Help Text Not Used


Documentation properties N/A


Bound Item Properties Translated into Additional Comment Example Related Bug#
Column Query column for the ADF VO attribute


Version N/A


Name Names the attributes in the ADF View Objects created from the modules MCO’s. The name is changed into a single word by removing all the underscores, making all the letters lowercase, with the exception of the first letter in each word, which is used in uppercase. SHORT_DESCRIPTION
i
s changed into: ShortDescription

Usage Sequence Determines the order of ADF VO attributes which again determines the order in which the attributes will be displayed on the page. If no item groups are used in the MCO, then the order of the attributes will correspond with the order of the Bound Items in the MCO.
If item groups are used, the items within the item group are placed after each other at the position of the usage sequence of the first item in the item group.
Name Display Sequence Item Group
A 1
B 2 Personal
C 3
D 4 Personal
E 5 Personal

The order of attributes in the VO created for this MCO would be:
A, B, D, E, C with D and E inserted before C because they are in the same item group as B.

Template/Library Object In some situations used to determine how to transform Oracle Headstart features.


Operations - Insert? Updateable property of ADF VO attribute When Insert? is Yes, this has no effect, but when Insert? is No and the Update? property is also No, then the Updateable property is set to Never.

Operations - Update? Updateable property of ADF VO attribute.
Operation Updateable Property
Update? Yes Always
Update? No While New
Update? No and
Insert? No
Never


Query - Query? Queriable property of ADF VO attribute. When the Query? property is Yes, the Queriable property of the corresponding attribute is checked. When it is No, then the Queriable property is unchecked.
When the Queriable property is checked this means the item will be included on the find page if included


Query - Range Search Not Used


Query ConText Option? N/A


Display - Display? Custom property “Display” on ADF VO attribute. If Display? Yes, then the “Display” property is set to true, otherwise it is set to hidden.

Display - Prompt Custom property “Prompt” on ADF VO attribute.


Display - Display Type Custom property “Display Type” on ADF VO attribute.
Designer Display Type JHeadstart Display Type
Text
editor if the display width is less than the maximum length and the display height is 1
dateField if it is a date
textInput in all other cases.
Check box checkBox
Combo box <none>
Descriptive Flexfield <none>
Image <none>
OLE Container <none>
Poplist <none>
Radio Group (Across) radioAcross
Radio Group (Down) radioDown
Text List <none>
OCX Control <none>
Display Item displayField


Display - Show Meaning Planned for later release

2283209
Display - Width Custom property “Width” for the ADF VO attribute.


Display - Height Custom property “Height” for the ADF VO attribute.


Display - Alignment Planned for later release


Display - Format mask Custom property “Format Mask” for the ADF VO attribute. See also the Column property Format Mask.
This property is not used by the JAG.


Display - Formatting Not Used


Display - Wrap Style N/A


Display - Item Group For each Item Group a Region is created in the Application Structure File for the Group to which the corresponding MCO belongs. In addition, the custom property “Region” is populated for the ADF VO attribute.
Influences the order of the attributes in the ADF VO. See the property Usage Sequence for more details about this.



Display - Context? Custom property “Display Table” for the ADF VO attribute. When JDG generates to LayoutStyle table-form, then the “Display Table” custom property is set to true for all attributes with Context set to Yes. The other attributes will have “Display Table” set to false.

Relative Tab Stops properties Not Used.


Definition - Datatype Type for ADF VO attribute.
Bound Item Datatype VO Attribute Type
null Datatype of EO attribute is used.
CHAR String
DATE Date
DATETIME Date
NUMBER Number
RAW Raw


Definition - Default Value Transformed into the Default value for the ADF VO Attribute. If the default is not Literal, the value is also transformed into the Custom property “Complex Default“ for the ADF VO attribute. The “Complex Default“ property is not used by JAG, and is meant as a reminder that a customization is required.

Definition - Default Value Type If the default is not Literal, the value is transformed into the custom property “Complex Default“ for the ADF VO attribute.


Definition - Optional? Custom property “Mandatory” for the ADF VO attribute. If Optional? Yes, then the custom property “Mandatory”=false, while if Optional? No then the custom property “Mandatory”=true

Ordering - Order By Sequence Order by clause for the ADF View Object. Order by clause is built with the columns following the order provided in the Order By Sequence. Bound Item: PRIORITY
   Order By Sequence: 1
Bound Item: SUB_PRIORITY
    Order By Sequence: 2
Gives an order by clause as follows: Msc2.PRIORITY, Msc2.SUB_PRIORITY

Ordering - Sort Order Order by clause for the ADF View Object Sort Order is added to order by column in the order by clause as specified in the Sort Order. Bound Item: PRIORITY
   Order By Sequence: 1
   Sort Order: Descending
Bound Item: SUB_PRIORITY
   Order By Sequence: 2
   Sort Order: Ascending
Gives an order by clause as follows: Msc2.PRIORITY Desc, Msc2.SUB_PRIORITY Asc

SQL - PL/SQL Block N/A


Help - Hint Custom property “Hint Text” for the ADF VO attribute.


Help - User/Help Text N/A


Documentation Properties N/A


Window Properties Translated into Additional Comment Example Related Bug#
Name N/A


Version N/A


Template/Library Object N/A


Display - Title Group Attribute tabName if MCO title is null


Display - Scrollable N/A


Display - Width N/A


Display - Height N/A


Placement Properties N/A


Documentation Properties N/A




Revision History

Date Author Version Comments
18-feb-2005 Sigrid Gylseth 1.10 Cleaned html file and performed minor corrections
18-jan-2005 Sigrid Gylseth 1.9 Added module - short title property, as this is now used.
16-sept-2004 Sigrid Gylseth 1.8 Updated for ADF.
21-aug-2003 Sandra Muller 1.7 Transformation to BLAF style, small textual changes
19-aug-2003 Sigrid Gylseth 1.6 Included reference to Oracle Designer 9i in addition to 6i. Updated old namings for custom properties to reflect the names as they are shown in the editors.
Updated related Bug# column.
Updated the following descriptions:
Item Groups: To reflect that Regions are generated
LOV: Restriction - Used For and Restriction - Additional Restriction to reflect that these now are transformed.
Column Properties: Complete? and Help - Hint to reflect that these now are used.
Bound Item Properties: Display - Item Group and Help - Hint to reflect that these are used.
2-jul-2002 Sigrid Gylseth 1.5 Added Item Group properties to cover for Regions.
7-jun-2002 Sigrid Gylseth 1.4 Changed description for Foreign Key Properties - Validate In as result of changes to bug 2345857.
Changed reference to be bug 2364260.
Removed reference to bug for Foreign Keys in the table Server Model Objects.Clarified for Domains that also dynamic domains are processed in the Server Model Objects table.
For Column Properties - Domain removed comment that only static domains are processed, and for Domain Properties - Name included that also dynamic domains are processed.
5-jun-2002 Sigrid Gylseth 1.3 Clarified in description of the Table/View Properties - domain, and Domain Properties - name that only static domains are processed.
Corrected that the version property is not processed for never checked in objects and for objects in non-versioned repositories.
This was corrected for Table/View Properties - version and Module properties - version.
Modified text in List of Values properties - Name to reflect changes in naming conventions for lookups as result of bug fix 2346041.
Therefore also removed reference to 2346041.Changed 'Translated into' for Check Constraint properties Validation - Where/validation Condition and Type as a result of bug fix 2345949.
Also removed reference to bug.Changed 'Translated into' for Check Constraint property - Defer Status as a result of bug fix 2345955. Also removed reference to bug.
Modified 'Translated into' for Domain - Allowable Values Properties - Value as result of bug fix 2343589, and removed reference to bug.
Changed 'Translated into' for Foreign Key Properties - Mandatory as a result of bug fix 2345876, and removed reference to bug.
Changed 'Translated into' for Foreign Key Properties - Cascade Rules - Delete Rule as a result of bug fix 2345907, and removed reference to bug.
Removed reference to bug in Foreign Key Properties - Joining To - Unique Key Joined To, and Foreign Key Column attributes as a result of bug fix 2345930,.
28-may-2002 Sigrid Gylseth 1.2 Removed last paragraph in introduction that indicated that the document also show the properties in the reverse direction.
Changed all column widths to autofit to column.
Corrected text for Module Name mapping, rewritten the additional comment for the Module Component, Placement - Window property.
24-may-2002 Sigrid Gylseth 1.1 Removed references to fixed bugs, changed Not Used into N/A and Planned for later release where appropriate.
Added some new references to new bugs/enh. req's.
Added additional comment for Column properties Derivation - Derivation Expression and Derivation - Derivation Expression Type, for Primary Key properties Update?, for Foreign Key properties Transferable?, Cascade Rules - Update Rule, Arc Properties, for Check Constraint property Enforce when null?
Changed Additional Comment for Domain Property name to indicate that it not only static domains that are used.
Removed gif in example for Domain - Allowable Values Properties, Value.
Added Additional Comment for MCO property Language.Removed gif in example for Column, Definition - Optional?
26-apr-2002 Lucas Jellema
/ Sigrid Gylseth
1.0 Initial creation based on initial reference guide by Lucas, and user guide by Sigrid.