Monday, July 11, 2016

Entity Objects and Entity Association

Entity Objects and Entity Association

Entity Objects
  • The entity objects are used if one wishes to do some insert/update operations.
  • Entity Objects represents a Data Base Row of a table.
  • Entity Objects will be based on the View (Oracle View), Synonyms or snapshots.
  • We need to create Entity Object if we want to perform DML operations on the OAF Page.
  • All the Entity Objects end with the EO.

Example:  employeeEO
  • When we create Entity Object (EO) one subclass will generate.
Employee

We have two types of Entity Objects
  1. PL/SQL based Entity Objects
  2. Java based Entity Objects

Note that we have two types of tables in Oracle Apps they are Custom Tables and Seeded Tables.
If we want to perform the DML operations on the standard (Seeded) table then we go for PL/SQL based Entity Object and if we want to perform the DML operations on the custom table then we go for Java Based Entity Object.

Entity Association
  • Entity Association is the relationship between two Entity Objects having one common column.
  • All the Entity Association ends with the AO (Association Object).
Example:  EmpDeptAO
  • If we want to perform DML operations on Master Detail page then we go for Entity Association.
  • If we want to common know column between two tables then we will go for Entity Association.

No comments:

Post a Comment

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...