Request ID Parameter LoV Not Populated for XML Publisher Report Program(R12).


When you submit the XML Report Publisher Program (XDOREPPB) you are prompted to select the Request ID for the data generation.The LoV for this parameter is not being populated due to an incorrect profile option reference.you select the appropriate data file to complete the request.
So,you must change the references to the incorrect profile option in the XDO_REPORT_REQUEST_ID value set


1) Go to System Administrator responsibility, open the Value Set form. Navigation: Application > Validation > Set.
2) Query the value set name as XDO_REPORT_REQUEST_ID
3)Click Edit Information.
4)Modify Where/Order By as Below
5) Save your work


Before Modification


WHERE ( ( FND_PROFILE.VALUE('CONC_REPORT_ACCESS_LEVEL') = 'U'
AND R.REQUESTED_BY = :$PROFILES$.USER_ID ) or
( FND_PROFILE.VALUE('CONC_REPORT_ACCESS_LEVEL') = 'R'
AND R.RESPONSIBILITY_ID = :$PROFILES$.RESP_ID ) )
AND R.PROGRAM_APPLICATION_ID = CP.APPLICATION_ID
AND R.CONCURRENT_PROGRAM_ID = CP.CONCURRENT_PROGRAM_ID
AND XDS.APPLICATION_SHORT_NAME=
( SELECT APPLICATION_SHORT_NAME
FROM FND_APPLICATION
WHERE APPLICATION_ID=CP.APPLICATION_ID)
AND XDS.DATA_SOURCE_CODE = CP.CONCURRENT_PROGRAM_NAME
AND R.OUTPUT_FILE_TYPE='XML'
AND R.STATUS_CODE not in ('E', 'D', 'T', 'X')
ORDER BY R.REQUEST_ID DESC

After Modification


WHERE (R.REQUESTED_BY = :$PROFILES$.USER_ID or
R.RESPONSIBILITY_ID = :$PROFILES$.RESP_ID )
AND R.PROGRAM_APPLICATION_ID = CP.APPLICATION_ID
AND R.CONCURRENT_PROGRAM_ID = CP.CONCURRENT_PROGRAM_ID
AND XDS.APPLICATION_SHORT_NAME=
( SELECT APPLICATION_SHORT_NAME
FROM FND_APPLICATION
WHERE APPLICATION_ID=CP.APPLICATION_ID)
AND XDS.DATA_SOURCE_CODE = CP.CONCURRENT_PROGRAM_NAME
AND R.OUTPUT_FILE_TYPE='XML'
AND R.STATUS_CODE not in ('E', 'D', 'T', 'X')
ORDER BY R.REQUEST_ID DESC


Metalink Ref:Note:404928.1