Oracle Blogs

Custom PLL file path  example : $AU_TOP/12.0.0/resource ------this  is the to be used and pasted in custom pll   v_lov LOV;   rg_name VARCHAR2(40);   rg_id RecordGroup;   v_sql  varchar2(5000);   result Number;   rec_id RecordGroup;   --    -- Real code starts here    --change lov of tax classifcation code in sales order form 19-11-2024      -------------------   --    begin      null;      begin     IF (event_name = 'WHEN-NEW-ITEM-INSTANCE' AND form_name= 'OEXOEORD') THEN     IF (block_name = 'LINE') THEN     rg_id := FIND_GROUP('TAX_CODES_RG');     v_lov := FIND_LOV('TAX_CODES');     v_sql := 'select TAX_CLASSIFICATION_CODE,TAX_CLASSIFICATION from zx_output_classifications_v1';     rec_id := CREATE_GROUP_FROM_QUERY('PO_GRP_548741',v_sql); ...

  Documentation of Custom   Forms: Step-1 ->Open the form Builder application and connect it with the server ->now delete the module and open the template.fmb which is standard ->Rename Template file with ur form name and save as form.fmb(form name) ->Now click on Data Block and delete DetailBlock ->Now click on Canvas and delete Blockname ->Now click on windows and delete Blockname Step-2 ->Now click on data Block and click (+) symbol which we can find on the left side on the top ->Now Create the new Data Block Use the Data Block Wizard and click ok ->Then click on next ->now click on table or view and click next ->give ur custom table name and click on enforce data integrity so that we can find the columns of our table and move all the items to database items and click next ->then click on next ->give the data block name which we want to display and click on next ->click on data block and call the la...

 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