You can use database sequence in ADF BC in different ways and I will explain some of these ways. 1 - Override Create() method in the entity object : t his solution depends on create operation, mean when you create new row then the database sequence generate new value, in the entity object select java, then click on edit icon , and check Create Method . Now inside the EntityObjectImpl go to the create() method and add the following code, make sure your key attribute data type is compatible with sequence return value. 2 - Using Groovy Expression : in this way we need to set the key attribute with default value and this value will be expression, this expression will get the sequence value from database sequence, make sure to pick Expression choice. The expression value will be like Also you can write your own method that call database sequence inside the EntityO...
Tips, information, and proof of concepts about Oracle Fusion Technology.
Comments