Oracle Reports (MOSC)

MOSC Banner

Report recompiled in 11.1.2.2 from 10.1 only runs for default site_code

edited Jun 9, 2015 1:24PM in Oracle Reports (MOSC) Question

Hello, we are validating the successful compilation of our existing reports into 11gR2.  We have one set of reports that takes a site_code parameter value to filter the data.  These reports always run for the default site, regardless of which menu item was selected.  The menu item value itself is coded with the site and report name.  It is parsed to setup the report (shown below).  The correct reports, 7 different versions, are run correctly, but not for the site chosen .  The code snippets to retrieve the report version and site are below:

report_name := :control.report_tlist;  -- selected item from available reports;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center