Oracle Blogs

PERSONALIZATION TO CHANGE LOV (Example used AP invoice form> Lines> TAX CLASSIFICATION CODE column LOV)  Step 1: GO form and click on LOV That needed to be changed Step 2 : Click ALT+H+D+E to examine and copy that block and field Step 3 : Click ALT+H+O to open about oracle applicaiton.              Copy Form Name and PATH Step 4 : Go to that path above winscp in the path replace 'ap' with 'au' and search for the FORM name                 and download it into your local system Step 5: Open form in form builder ,in  DATA_BLOCKS go to block you found in examine the form and in that block find item(field) that you found in examine  >        > >  double click on item  >copy this LOV name and find it in LOV section of FORM BUILDER   >double click on TAX_CLASSIFCATION_CODE2  >copy the record group name > find the record group in ...

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); ...