Apps Technical - What are User Exits and what are different types of User Exits in Oracle Apps ?

GeekInterview.com > Interview Questions > Oracle Apps > Apps Technical

Go To First | Previous Question | Next Question

Apps Technical | Question 32 of 129

What are User Exits and what are different types of User Exits in Oracle Apps ?

Total Answers and Comments: 11

Last Update: June 24, 2009

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

Sorting Options

Page 1 of 2

« First

Last »

September 05, 2005 06:40:53

Prasad

RE: What are User Exits and what are different types of User Exits in Oracle Apps ?

User Exit is nothing but a colection of changable optin that it can be change in the way of our applicalion
In Apps 4 types of User Exits.
Saite Level
Application Level
Resposibility Level
User Level

User Level: It is Higer level it is applicable to the all users.
Application Level: It is applicable to that particular application only
Resposibility Level:
For that Particular resposibility

Site Level:Is lower level if we difiened if it is Site level it will appilicable to the all users..

Is this answer useful? Yes | No

October 19, 2005 11:36:12

Purushotham

RE: What are User Exits and what are different types o...

User Exists are 5 Types.

FND SRWINIT

FND SRWEXIT

FND FORMAT_CURRENCY

FND FLEXIDVAL

FND FLEXSQL

Is this answer useful? Yes | No

November 18, 2005 00:24:17

Anil

RE: What are User Exits and what are different types o...

As the name indicates user exits are the programs written in any of the language like Java C++ Pro C to perform certain action.

User exit when called from Report triggers moves the control from report to this outside program there it performs the action programmed and returns back to report environment.

The program which makes USER to EXIT from ongoing environment to perform certain action is USER EXIT.

Is this answer useful? Yes | No

November 18, 2005 01:31:29

abedin

Member Since: November 2005 Contribution: 4

RE: What are User Exits and what are different types o...

Types of user exits

FND SRWINIT sets your profile option values and allows Oracle AOL user exits to detect that they have been called by a Oracle Reports program.[Before Report trigger P_CONC_REQUEST_ID lexical parameter]

FND SRWEXIT ensures that all the memory allocated for Oracle AOL user exits has been freed up properly. [After Report trigger]

FND FORMAT_CURRENCY is used for MULTIPLE CURRNECY REPORTING (MRC) [formula Column P_MIN_PRECISION lexical parameter]

FND FLEXSQL this API is used for get ELECT/WHERE/HAVING/ORDER BY/GROUP BY from flex field

tables.

FND FLEXIDVAL this API is used for get descriptions from flexfields gets input from FND FLEXSQL.

Call this user exit to populate fields for display. You pass the key flexfields data retrieved by the query into this exit from the formula column. With this exit you display values descriptions and prompts by passing appropriate token (VALUE/DESCRIPTION/APROMPT/LPROMPT).

it will take inputs from columns of query the columns are defined by FND FLEXSQL.

Is this answer useful? Yes | No

November 30, 2005 06:36:56

chenna

RE: What are User Exits and what are different types o...

Hi Man

What r u saying? u r saying about profile levels.But he asked about userexits.There are main userexits.ok they are

FND SRWINIT
FND SRWEXIT
FND FORMAT_CURRENCY
FND FLEXIDVAL
FND FLEXSQL FND SRWINIT
FND SRWEXIT
FND FORMAT_CURRENCY
FND FLEXIDVAL
FND FLEXSQL

so don't misguide the people.

Is this answer useful? Yes | No

January 07, 2006 10:36:08

Himex

RE: What are User Exits and what are different types o...

Thank you chenna!!!

In fact I was also amazed to see that person has listed profile levels in the User Exit definition.

Please make sure what you are typing man.

Thanks once again chenna!!!!

:) :)

Is this answer useful? Yes | No

February 13, 2006 08:07:12

Bonthu N Reddy

RE: What are User Exits and what are different types o...

A user exit is a C subroutine written by you and called by Oracle Forms to do special-purpose processing. You can embed SQL statements and PL/SQL blocks in your user exit then precompile it as you would a host program

Cheers

Bonthu N Reddy.

Is this answer useful? Yes | No

February 21, 2006 00:06:19

Prasant

RE: What are User Exits and what are different types o...

user exits r 2 type

1.SRWINIT:To capture user profile like user id name org etc

2.SRWEXIT;to freez memory which is occupied by the user

Prasant

Is this answer useful? Yes | No

February 22, 2006 06:51:07

Sriram

RE: What are User Exits and what are different types o...

Hello

I coudn't understand whether you gave explanation for user Exit or Profile options? Please let me know whether both are same if same how? If same then whats the need of creating user exit separately. we can call FND_PROFILE options directly. Please give me a detailed mail.

Regards

Sriram

Is this answer useful? Yes | No

June 21, 2006 03:14:27

#10

Amit

RE: What are User Exits and what are different types o...

User exit are programs thats enables you to execute external procedure.

5 types of user exit are there in APPS.

FND SRWINIT--Used to set the profile option and environment vallue.

FND SRWEXIT--Used to release the profile option and environmental value

FND FORMAT_CURRENCY--Used to format the currency dynamically.

FND FLEXIDVAL--Used to populate the fields for display.

FND FLEXSQL--this user exit is called to create a SQL fragment usable by your report to tailer your SELECT statement that retrives FLEX FIELD value.

Is this answer useful? Yes | No

Page 1 of 2

« First

Last »

Go To Top

User Name		Remember Me?
Password

Question Bank