Thursday, July 20, 2017

Oracle Form: Restricting Lookup form to one Lookup type

Hi Folks,

I had a requirement from business .
Business wants me to change the 'Define Lookup' form that should only show a particular lookup type and attach it with a new Responsibility .

Steps To Achieve this requirement.

1) First find the function name , that needs to be manipulate.
    Navigation
   
            System Administrator --> Application  --> Menu

And here is the form Prompt ''Order Management"
                   Function Name "Order Management QuickCodes" (This Function have to be manipulate)




  2)- Go to Function Screen
        Navigation
           
                  System Administrator --> Application  --> Function

Search Above Function in function screen by searching User function Name as "Order Management QuickCodes".

Then Here we get the Actual Function Name : ONT_FNDLVMLU.




3 )-  Now the actual Work starts here to create new function with the same properties of the original one but tweak the Parameters Field.

        New Function Name : ONT_FNDLVMLU_CSR
        User Function Name : Order Management QuickCodes CSR

(CSR is something Custom i had to add, You can give any relevant name to new function).


Then Change the values in Parameter Field .

VIEW_APPLICATION="ONT" LOOKUP_TYPE ="XXX_CUSTOM_LOOKUP_TYPE"



Then Save this function.

4)- Add this function to your responsibility , and check the values . This new function will only show 1 lookup type name as  "XXX_CUSTOM_LOOKUP_TYPE".


Happy sharing
:)

Clear BNE Cache for WebADI Changes

It Sometime happens that WebAdi Changes doesn't reflect once migrated in controlled instances. Here are the quick steps(Generally perfor...