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

Showing Answers 1 - 25 of 25 Answers

Prasad

  • Sep 5th, 2005
 

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.. 
 
 

  Was this answer useful?  Yes

Purushotham

  • Oct 19th, 2005
 

User Exists are 5 Types.

  1. ? FND SRWINIT
  2. ? FND SRWEXIT
  3. ? FND FORMAT_CURRENCY
  4. ? FND FLEXIDVAL
  5. ? FND FLEXSQL

Anil

  • Nov 18th, 2005
 

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.

abedin

  • Nov 18th, 2005
 

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.

 

 

  Was this answer useful?  Yes

chenna

  • Nov 30th, 2005
 

   Hi Man,

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

  1.   FND SRWINIT
  2. ? FND SRWEXIT
  3. ? FND FORMAT_CURRENCY
  4. ? FND FLEXIDVAL
  5. ? FND FLEXSQL FND SRWINIT
  6. ? FND SRWEXIT
  7. ? FND FORMAT_CURRENCY
  8. ? FND FLEXIDVAL
  9. ? FND FLEXSQL

so don't misguide the people.

  Was this answer useful?  Yes