Answer / rahul

User Exit plays very important role in Oracle apps with of
help this we can capture value at runtime with profile option.
And P_CONC_REQUEST_ID is mandatory if we using User Exit
otherwise it gives error in report p_conc_request_id not
found . If we not using User Exit then its not mandatory.
Further we can develop report without using User Exit and
P_CONC_REQUEST_ID.

Answer / chandrasekkhar

Hi This is Chandrasekhar,

Actually we have 5 types of user exist.
This is the Oracle Reports predefined program.
FND SRW INIT,FND SRW EXIT,FND FLEX SQL,FND FLEX IDVAL and
FND FORMAT CURRENCY.Thease are the user exist.
Using this Oracle will stop the Processoing and control
will jump to 3GL and it gets the some data and it will
finish the remaining process
it's initialize and freze the user profile values.
FND FLEX SQL,FND FLEX IDVAL these two we will use the while
developing the KFF SEGMENT REPORT.
Using FND FORMAT CURRENCY ,we can get the mixed currency
values based on this profile.

If you need more ,Please contact me .

Thanks & Regards
Chandrasekhar

Answer / sivasankar

Hi,
Use of user_exit:

user_exit is the program,transfer the data from third
generation language to oracle report builder.

P_CONC_REQUEST_ID:This is default parameter.This is
optional one.
Use:generate the concurrent program Request_id.

we can develope without user_exit and p_conc_request_id

if any queries please let me know.

Thanks & Regards,
Siva

Answer / ganesh

Hi All!

User Exit is a program, which stops the execution of
process and transfer the controls to other Third generation
Language. After that it executes the remaining excution
process.
P_conc_request_id is the system parameter.It is used to
generate the concurrent request id.

If we used user_exits in report builder we should use
p_conc_rquest_id, because it is mandatory.

Answer / emmanuel

As per the oracle apps standards we have to define a
mandatory parameter P_CONC_REQUEST_ID. This will capture
the request_id when you submit the c/p program. User_exits
are mandatroy SRW INIT and SRW EXIT is manadatory. when you
run a report in apps. srw init it will assign the all user
profiles to your report and SRW exit it will freaae the
memory which is occupied by the user exits.

How ever we can run a report with this these also. when u
run a reports on multi org all these mandatroy fileds are
compulsary

Answer / samurti

I have checked the above issue while running with and
without providing p_concurrent_request_Id and/or user_exit
here is the result

1) When I have removed "p_concurrent_request_Id", the
concurrenr request is in error

2) When I have removed user_exit i got no error report runs
correctly.

However, It is recommended to go for user_exits as we are
in multi-org environment and want to set profile and
environment related to oracle apps to result in proper
data.

Answer / krishna

Hi siva,
Thanks for response.If it is the optional then what is the
use of these parameters and I developed the report with
passing these parameters it is running fine.I saw lot of
oracle standard reports,in all that reports they are
passing these parameters.

Answer / senapati

if we are using views in report query then user_exits are
mandatory.

Answer / vinay kumar

user_exit is used to set the profile options
User Exit is a program, which stops the execution of
process and transfer the controls to other Third generation
Language. After that it executes the remaining excution
process.
we can develope without user_exit and p_conc_request_id
for single organization for multi org we must use this to set
the profile option

Answer / d.simhachalam

There are 5 Different types of user exists.
1. FND SRW INIT
2. FND SRW EXIT
3.FND FLEX SQL
4.FND FLEX IDVAL
AND 5. FND FORMAT CURRENCY
Using FND FORMAT CURRENCY we can use the different currency
values based on the countries.
For ex in US. the format for currency is 1,000,000.00
in some countries 1.000.000,00
USING SRW EXIT it will freeze the memory
USING SRW INIT, it will assign all the user profiles to your
report.
P_CONC_REQUEST_ID is not mandatory it is an optional.
It is a parameter, while using the user parameters, it is
used as standard for oracle to use it. Without using the
P_CONC_REQUEST_ID there is no standard implemented in the
project.

name at least five reports in oracle inventory related to transaction ?

3 Answers   Scan Steel,

what do u mean by debit/credit memo invoices?

3 Answers   ACC, Convergys, Mascon,

we have select statement in that two exceptions that returns no value. In that which exception will raise?

2 Answers  

What r the type Models in the system parameters of the report?

1 Answers  

difference b/w procedures&functions

2 Answers   Oracle, TCS,

Are you familiar with internet architecture of oracle apps 11i?

0 Answers  

what is the difference between oracle 8i and 9i?

1 Answers  

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

0 Answers  

in procedure how to return a value

4 Answers  

what is trace file? what is the use of that?

4 Answers  

What is responsibility?

5 Answers  

types of invoices?

7 Answers   BelAir Store, Convergys, Wings Biotech,