Himex

• Jan 7th, 2006

 

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

   :)     :)

 

Bonthu N Reddy

• Feb 13th, 2006

 

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.

Prasant

• Feb 21st, 2006

 

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

Sriram

• Feb 22nd, 2006

 

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

Amit

• Jun 21st, 2006

 

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.

srikanth.kotipalli

 Profile Answers by srikanth.kotipalli 

• Jun 24th, 2009

 

User_Exit is used to pass control from one oracle products to another. In Oracle Apps we use user_exit in before_report trigger to establish link between the report and apps environment that is we use 'FND SRWINIT' for the apps initialization for the report.

Bharat Bhatia

 Profile Answers by Bharat Bhatia 

• Jan 4th, 2015

 

We can integrate Oracle reports with Oracle Application Object Library, and run them as concurrent programs from your forms or through standard request submission.

These are the user exits available in Oracle Reports that makes AOL integration.

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

Siddharth

• Feb 5th, 2015

 

User Exists are 4 types in oracle apps.
def: user Exists represent the user way of changeable option in oracle applications.

1 . Site leve
2. application level
3. Responsibility level
4. user leve

chandu

• Jun 4th, 2015

 

these are not user exits
user exits are
FND SRWINIT
FND SRWEXIT
FND FORMAT_CURRENCY
FND FLEXSQL
FND FLEXID VAL
these are profile values

Naresh Bandla

• Jun 24th, 2015

 

User Exits are Which makes User to Exit on going environment to perform certain actions.
There are Five types of User Exits
----------------------------------------------
1. SRW.USER_EXIT(FND SRWINIT)
The SRW.USER_EXIT(FND SRWINIT) is used in AOL report and is used to setup your user profile. If you are in a muilti_org environment, this ensures that your report display data from the users organization and this is set in Before Report Trigger(R11i) (OR) after parameter form trigger(R12i).. Create a lexical parameter P_CONC_REQUEST_ID with the datatype Number. The concurrent manager passes the concurrent request ID to your report using this parameter.
2. SRW.USER_EXIT(FND SRWEXIT’)
You call SRW.USER_EXIT in after report trigger to make sure that all the memory allocated for AOL is freed up.
3. SRW.USER_EXIT(FND FORMAT_CURRENCY ‘)
Used to Format the Currency Value column.Is used for MULTIPLE CURRNECY REPORTING (MRC) [formula Column P_MIN_PRECISION lexical parameter]
4. SRW.USER_EXIT(FND FLEXIDVAL’)
This API is used for get descriptions from flexfields gets input from FND FLEXSQL
5. SRW.USER_EXIT(FND FLEXSQL’)
This API is used for get ELECT/WHERE/HAVING/ORDER BY/GROUP BY from flex field tables.