Oracle Blogs

 Populate Values in oracle forms dynamically  step 1 : create trigger event when new item instance step 2 : in actions select type as property as shown in figure and write sql statement to get values dynamically. ex sql query to be written in value :   =(  SELECT        k.concatenated_segments FROM apps.per_all_people_f p,      apps.per_all_assignments_f a,      apps.pay_people_groups ppg,      apps.hr_all_positions_f hap,      gl_code_combinations_kfv k WHERE     p.person_id = a.person_id       AND a.people_group_id = ppg.people_group_id       AND hap.position_id(+) = a.position_id       and k.code_combination_id = a.default_code_comb_id       and p.employee_number in (:ADDITION_DIST.ASSIGNED_TO_NUMBER))

Command to create fmx in Oracle Forms frmcmp_batch userid=apps/apps module=/u02/oracle/VIS/fs1/EBSapps/appl/au/12.0.0/forms/US/RRR.fmb output_file=/u02/oracle/VIS/fs1/EBSapps/appl/au/12.0.0/forms/US/RRR.fmx module_type=form

  PL/SQL It is a programming language which is used to define our own logics. It is used execute block of statements at a time and increase the performance. It supports variables and conditional statements and loops. It supports object oriented programming and supports composite data types. It supports handle the error handling mechanism.   Block It is one of the area which is used to write a programming logic. This block is have 3 sections. Declaration Section Executable Section Exception Section 3.      Declaration Section §   It is one of the section which is used declare variables, cursors and exceptions and so on. §   It is optional section. 4.      Executable Section §   It is one of the section which is used to write a program coding. §   It is mandatory section. 5.      Exception Section §   It is one of the section which is used to handl...