How can we view the data asociated with Request ID

[Former Member]

Hi All,

I have data loaded in an ODS there are multiple files loaded in this ODS. Now i want to view data for a perticuler request OR i want to know how can we know the data associated with a perticular request.

Please help me out.

Thanks & Regards

Amit Kumar

[Former Member]

Hi,

In the manage tab -> Request -> copy the ODSR_XXXX request , goto change loag, give this request number and choose the record mode = blank.

you can view the records loaded.

This is possible only if the change log is not deleted.

Regards,

Ramesh

[Former Member]

Copy the request number (not request ID) from the ODS manage screen, Goto RSRQ give the request number and execute. it shows the monitor screen- now goto PSA from the top and check the data. But this possible only if you are loading data to PSA also along with ODS.

Otherwise, Goto Display Data of ODS from the right click on it -- in the selection screen give the Request ID that you want to check the data. Then it displays only that request data.

Hope this helps.

Veerendra.

Edited by: denduluri veerendra kumar on Dec 1, 2009 12:40 PM

Edited by: denduluri veerendra kumar on Dec 1, 2009 12:43 PM

[Former Member]

Hi,

Thanks for Quick reply.

I have checked the option when we used to go to the selection screen request ID does not appear and also if we used to select it from 'Field Selection for Output Screen' it does not get appear on selection screen.

Can you please suggest somthing else to do so.

Thanks

[Former Member]

Hi,

It is starnge,

when you select the change log table from the manage of ODS, it should appear.

else goto se16 give the change log table name and chk there

Regards,

Ramesh