CollectionCollection is an Ordered group of elements, all of the same type.Attributes of Collection1. FIRST2. LAST3. COUNT4. DELETE5. EXTAND6. TRIM7. NEXT8. EXIST9. PRIOR10. LIMITTypes of Collection1. Varray2. Nested Table3. PL/SQL Table or Associate ArrayVarray:-Varray stands of variable size array.Varray can be stored in the column of table.Syntax of Varray:- Type type_name is VARRAY(length) of data_type;Examples of ...
Operating_unitsOrg_idorganization_id
Difference between Org_id ,organization_id and operating_unit in Oracle Apps
posted on , by Adarsh
Let us say you are having Inventory Store.You have Inventory Stores in two different countries like India and USAYou have installed Oracle Apps single instance and entered all the suppliers information, customers data, tax rules etc.And your business requirement is like this, all the rules and the data corresponding to indian store shouldn't be applicable/available to American store and vice versa.So to meet the above requirements you will define two operating units one for ...
