When you submit the XML Report Publisher Program (XDOREPPB) you are prompted to select the Request ID for the data generation program. The LoV for this parameter is not being populated due to an incorrect profile option reference.

To work around this issue, you must change the references to the incorrect profile option in the XDO_REPORT_REQUEST_ID value set as follows:

1. Using the System Administrator responsibility, open the Value Set form. Navigation: Application > Validation > Set.
2. Query value set name XDO_REPORT_REQUEST_ID.
3. Click Edit Information.
4. Modify Where/Order By as follows:
   

Current:

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

Modified to:

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

Reference Note:404928.1