472,331 Members | 1,851 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,331 software developers and data experts.

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 5596
2,367 Expert 2GB
Try this:

Expand|Select|Wrap|Line Numbers
  1. SQL> ed
  2. Wrote file afiedt.buf
  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> 
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
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

Thanks in advance
Jan 4 '11 #5
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

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

Similar topics

by: ajpl71 | last post by:
We are in the process of upgrading our Apps11i from 11.5.9 - 9i to 11.5.10 - 10g in a multinode environment. We are using Suse8 as OS. We are...
by: kiran | last post by:
Hello, Please find the two requirements details as follows Oracle Apps Finance Functional Location: Houston, TX Duration: Long-term Start...
by: rajesh.us.it.recruiter | last post by:
Dear Professionals We have urgent requirements for J2EE, .Net, Siebel-CRM, Oracle Apps, SAP ERP, Mainframe, C++, Unix Professional on H1 Transfer...
by: ss137 | last post by:
Hi, I am unable to view the output of dunning letter in oracle apps. can any body help me regarding this.
by: prabhakar037 | last post by:
Hi all, This is my output while running my reports in oracle apps. What should i do to remove the unnecessary fonts, ...
by: Ora | last post by:
Hi all, Can any one help me in getting the list of users associated with a responsibility in Oracle Apps. Thanks,
by: rumasinha | last post by:
Hi, I first created a materialized view that was based on the org striped views like po_headers hence the automatic refresh was not happening....
by: vamsioracle | last post by:
hi i have a problem in oracle apps. Actually we use Orcle Financialsat two locations. we connect directly to server at one location and the...
by: Sharad Kadam | last post by:
I am fresher in Oracle, and i want to choose Oracle APPS as a carrer. I am working in VB.net for last 1 Year. I am from IT background. ...
by: vamsioracle | last post by:
Hi all I am working on a support project. I need to change logic in a fast formula in oracle applicationhs which was developed a long time back....
by: tammygombez | last post by:
Hey fellow JavaFX developers, I'm currently working on a project that involves using a ComboBox in JavaFX, and I've run into a bit of an issue....
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.