469,342 Members | 6,283 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,342 developers. It's quick & easy.

How to get the form_id or function_id or function_name?

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.
Dec 29 '10 #1

✓ answered by 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.

6 5349
amitpatel66
2,367 Expert 2GB
Try this:

Expand|Select|Wrap|Line Numbers
  1. SQL> ed
  2. Wrote file afiedt.buf
  3.  
  4.   1  SELECT fff.function_name,
  5.   2         ff.form_name,
  6.   3         ffft.user_function_name,
  7.   4         fff.function_id,
  8.   5         ff.form_id,
  9.   6         fff.application_id
  10.   7  FROM   fnd_form ff,
  11.   8         fnd_form_functions fff,
  12.   9         fnd_form_functions_tl ffft
  13.  10  WHERE  ff.form_id = fff.form_id
  14.  11  AND    fff.function_id = ffft.function_id
  15.  12* AND    ffft.language = 'US'
  16. SQL> 
  17.  
  18.  
Dec 30 '10 #2
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!
Dec 30 '10 #3
amitpatel66
2,367 Expert 2GB
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.
Jan 4 '11 #4
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
Jan 4 '11 #5
amitpatel66
2,367 Expert 2GB
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.
Jan 5 '11 #6
thanks a lot amitpatel66.... have a good life!
Jan 5 '11 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by vamsioracle | last post: by
5 posts views Thread by Sharad Kadam | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Purva khokhar | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.