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.

in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me

4 Answers   CTS, iGate,

In what situation u create the BPA.

2 Answers   Accenture,

How can we import the data into a database using sql * loader?

0 Answers  

What are the Major differences bteween key flexfields ,descriptive flexfields

4 Answers   Sierra Atlantica, TechBulls,

what is the difference between credit memo and debit memo?...

2 Answers   Sony,

how to initialize applications?

2 Answers  

How to print multi currency,multi language in xml?

1 Answers  

While registering the concurrent program we first do the executable concurrent program and then define it . So why we need to give the application name twice in executable and as well as definitions

3 Answers   IBM,

What is responsibility and how u attach

5 Answers   Accenture,

The report output is 10 pages then how many times between pages report trigger will fire?

1 Answers   IBM,

WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

4 Answers  

Except the SRS window in which we can submit the concurrent program.

5 Answers   IBM, TCS,