Tuesday, October 24, 2017

View Objects in Oracle OAF

  • View Objects represent a query Result.
  • View Objects are used for joining, filtering, projecting, and sorting business data.
  • View Objects are created based on any number of Entity Objects.
  • View Objects can also be constructed from a SQL Statement.
  •  The View Objects represents both the data i.e. SELECT statement & the operations or methods that can be performed on the data(get/set/validations).
  • Most of the View Objects are defined decoratively, but there are even methods to programmatically create and Alter VOs at RUN time.
  • View Objects are designed to manage collection of data i.e. main collection interface into the DataBase.
  • View Objects provide view-like shaping of the data. It leverages SQL to join tables and corresponding Entity Objects. 
  • The View Object allows us to do the action most often performed, query without the overhead of a full Entity Object which indirectly increase the performance of Oracle Application Framework pages. 
  • View Objects ensures better usability of business logic (as it delegates to other objects such as Entity Object or PL/SQL for Business Logic).
  • View Object contains only the attributes required for a specific purpose. So do not select more attributes i.e. columns than required for a Page.
  • View Objects are considered for a specific page and are not expected to be reused.
  • Never include business logic in View Object.

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)