Wednesday, August 6, 2014

Oracle Forms Personalization Examples

Oracle Forms Personalization Examples


Note: You can find FNDLOAD command which you can use to download/upload form personlization from my blog- 'FNDLOAD command to download/upload form personlization'

How to check form personalization made to form-

Navigation-
Open form and goto menu
Help >Dignostics>Custom Code>Personalize

 
 
How to restrict specific records/data from saving into application and fetch error-
 
Open form on which you want to apply form personalization.
Goto form personlize section like mentioned above.
 
Here for testing used material release form. You have to find out objects and columns according to your form.
 
Suppose I dont want allow inter org release transfers by checking values entered by user on forms-
 
Please verify steps done below carefully for inter org release not allowed -
 
Define sequence and provide description.
Select triggering event,trigger object,condition and mode.
 



 


${item.mrp_orders.release_status.value}=1 and ${item.mrp_orders.SOURCE_ORGANIZATION_CODE_SRC} is not null and ${item.mrp_orders.ORDER_TYPE}=5

Now you have to define action steps, if condition satisfies-
Like message,rollabck some values on form etc
 
Define Message-
 
 
Rollback values of some field-

























Raise exception-























Create LOV(List of values) on specific field depending on values entered for some fields on form-

Please check steps done below carefullyfor supplier -



Define action steps-
 


 SELECT DISTINCT MTP.PARTNER_NAME,
  MTP.PARTNER_ID
  FROM MSC_ITEM_SUPPLIERS MIS,
  MSC_SYSTEM_ITEMS MSI,
  MSC_TRADING_PARTNERS MTP,
  MSC_TRADING_PARTNER_SITES MTIL,
  MSC_PLAN_ORGANIZATIONS MPO
WHERE 1=1
AND MIS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MIS.SUPPLIER_ID       = MTP.PARTNER_ID
AND MTP.PARTNER_ID        = MTIL.PARTNER_ID
AND MIS.ORGANIZATION_ID   = MSI.ORGANIZATION_ID
AND MPO.ORGANIZATION_ID   = MSI.ORGANIZATION_ID
AND MIS.PLAN_ID  = -1
AND MPO.ORGANIZATION_CODE=:MRP_ORDERS.ORGANIZATION_CODE
AND MSI.ITEM_NAME=:MRP_ORDERS.ITEM_SEGMENTS
ORDER BY MTP.PARTNER_NAME

Apply LOV to source_vendor field-
 


How to change field name on form-

Suppose you want to change name of field 'User Name' to 'User', then check below steps done carefully-

























Open that form and goto personlize section of that form as shown earlier in this blog-

Define sequence-






















After above steps once done goto action tab-

Choose property type and then target object.
Change value to 'User' as shown below-









Apply changes

Then again open form, you can see that changes are now reflecting-
See below-
 

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete