| P_CONC_REQUEST_ID [message #225081] |
Sat, 17 March 2007 02:07  |
artisinha84
Messages: 6
Registered: February 2007
Location: hyderabad
|
Junior Member |
|
|
Hi,
Plz Can anybudy tel me The use of P_CONC_REQUEST_ID when we develop a report.Plz tel me ans ASAP.
Thanks In Advance
Arti
|
|
|
|
| Re: P_CONC_REQUEST_ID [message #225083 is a reply to message #225081] |
Sat, 17 March 2007 02:33  |
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India
|
Member |
|
|
Hi Arti,
This is Kittu here.
This P_CONC_REQUEST_ID used by the concurrent manager to pass request id of concurrent program through this parameter to the report builder.
Thats it....
If you want more search in metalink...
Kittu.
|
|
|
|
|
|
| Re: P_CONC_REQUEST_ID [message #225087 is a reply to message #225086] |
Sat, 17 March 2007 04:10 |
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India
|
Member |
|
|
Arti,
Without this parameter i don't think you can run ur report in apps, concrnt mannager will try to pass this id to ur report,which i belive makes the reprot to run in apps.
try without it n see...if possible let me know the ur knowledge.
Kittu.
|
|
|
|
| Re: P_CONC_REQUEST_ID [message #225089 is a reply to message #225086] |
Sat, 17 March 2007 05:00 |
adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway
|
Senior Member |
|
|
Arti,
For audit purposes Oracle has something called WHO-columns that provide information about who did what when. The standard five WHO-columns are CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY and LAST_UPDATE_LOGIN.
In some tables Oracle has provided some additional enhanced WHO-columns: PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE and REQUEST_ID that are used to log information about any concurrent program that creates or updates the record.
Strange as it may sound you can actually use an Oracle Report to alter data. In these cases the report will need to know the REQUEST_ID in order to provide the correct information for the WHO-columns.
--
Aleksander Dragnes
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
