Saturday 19 January 2013

No Entries Found For List Of Values For Parameter Operating Unit When Running Reports

This relates to Organization Parameter while Submitting Concurrent Program.All Standard Programs by default will give Organization values while Submitting.
But Custom Program by default will be null.Its a oracle bug Bug 5587132. Solution given as below. (NOTE 837615.1)
UPDATE FND_CONCURRENT_PROGRAMS
SET MULTI_ORG_CATEGORY='S'
WHERE CONCURRENT_PROGRAM_NAME = '<your program name>'

Or Through Application.

To update the settings to Multiple do the following:
Responsibility: System Administration (Take note use System Administration and not System Administrator)
Navigation: Concurrent > Programs
Select Program name
Click on Go.
Click on Update to update the details of report.
Click on Request tab.
Select Operating Unit Mode = 'Multiple'. and save it.
Repeat this for other reports where you encounter the same issue.

No comments:

Post a Comment