How to get the form_id or function_id or function_name?

[Cessaar]

Hi Masters:

in Oracle Apps i need to get the function_id, function_name or form_id to create a customized code... how can i get that?

thanks in advance
Cesar L V.

[amitpatel66]

Try this:

SQL> ed
Wrote file afiedt.buf
 
  1  SELECT fff.function_name,
  2         ff.form_name,
  3         ffft.user_function_name,
  4         fff.function_id,
  5         ff.form_id,
  6         fff.application_id
  7  FROM   fnd_form ff,
  8         fnd_form_functions fff,
  9         fnd_form_functions_tl ffft
 10  WHERE  ff.form_id = fff.form_id
 11  AND    fff.function_id = ffft.function_id
 12* AND    ffft.language = 'US'
SQL> 
 
 

[Cessaar]

thanks a lot, amitpatel66...

in the oracle applications (EBS)... i trying to create a personalization, how can i get the function_id or the function_name?... because in the application, i have 2 diferent functions using the same form... and i need only one fuction applies that personalization...

excuse my english...
thanks a lot for your (very appreciated) time
happy new year!

[amitpatel66]

You can open the particular form to which the function is assigned that you want to customize then you can do your customization using forms personalization.

I am not sure what you are exactly trying to achieve.
If you can provide more information would help.

[Cessaar]

a Lot of Thanks, AmitPatel66...

but i have 2 functions (example: function1 and function2) who calls the same Forms (example: ARXFORM1), so... i create the personalization on ARXFORM1, so, if you only access function1 the personalization applies....

my problem is: accessing function2, the personalization applies too, and i dont want this.

how can i "split" or what condition i need to create in the personalization to differenciate the accessing function

---EXCUSE MY POOR ENGLISH!
Thanks in advance
Cesar

[amitpatel66]

Is your fmb a custom one or a standard one? Then I am afraid you will need to create a copy of that fmb with different name and assign the same to another function and apply the personalization to the same.

[Cessaar]

thanks a lot amitpatel66.... have a good life!