Integrating mod_plsql reports with apps so I can synch users. Is there a way?

Hi,
I have successfully crossed all hurdles on my current projects except
this last one.
The scenario:
Create materialized views in a schema outside of apps, for a mini data
warehouse. Check.
Create reports using mod_plsql referencing the materialized views that
users will be able to access. Check.
Create a VPD or FGAC package to ensure that users can only see what
they are supposed to see by using system context to track the user.
Check (sort of, read on).
Add links to the Oracle apps menu so that a user will be able to click
a link in their menu after they've logged on that will take them to the
reports. Check (sort of, read on).

Where I'm stuck.

The user wants to be able to login to apps, click on the link in their
menu and go to the reports. The reports should know who the user is and
correctly constrain their access to just the data they should be able
to see.

I COULD do this, passing a session_id (established on login to Oracle
Applications for that user) to the mod_plsql report that would then
establish the context for that session for that user in the schema that
the report lives in. However, as far as I can tell, and this is where
you may come in, I'm not able to establish a dynamic parameter value to
be part of the html string in the function definition when you set
things up in Oracle apps menu.

Currently I don't see how I can pass a user specific session_id from
the Oracle Apps menu to my mod_plsql report that resides in a different
schema. The alternate solution would be to somehow retrieve the user_id
from the mod_plsql side of the equation, but I don't see how to do that
either. I did note that the mod_plsql reports appear to be wrapped in a
login jsp that times out, requiring user re-login after a certain
amount of time which is exactly what I would want, but how do I get the
mod_plsql report to convince the jsp page to cough up the user?

My deadline is looming. Any suggestions would be much appreciated.
Thanks.
Kurt

.

Relevant Pages

  • Re: Weird problem with reports !?!
    ... The problem does occur with Access, even when other apps have not problem printing. ... You might try uninstalling that network printer, and installing it again to see if that works. ... > did something with printers but no-one else using the database is ... > Went to her PC and opened the database, I cannot do anything with> reports. ...
    (microsoft.public.access.reports)
  • Re: need to update fp2.6 app
    ... "Straightforward" conversions of 2.x apps to VFP are rarely straightforward. ... Expect to make a lot of changes regarding reports though - the DOS ... If you're happy with the DOS app, you could probably keep it forever. ...
    (microsoft.public.fox.helpwanted)
  • Re: Showdown: Spyware Search & Destroy SHAMED by Super Utilities for me today
    ... SU doesn't appear on either the lists of "trustworthy" ... apps nor the list of rouge apps at this site: ... Art -- I admittedly didn't consider the possibiity ... it didn't produce a long list of suspicious reports. ...
    (alt.comp.anti-virus)
  • Re: Best AV prog for XP = KAV 5 right?
    ... VB reports are as useless as most of the apps they ... >Mark, ...
    (comp.security.misc)
  • Custom Provider Crystal Asking for wrong Table
    ... I'm writing my own OLE DB provider for use in Crystal Reports and other ... If I connect to my OLE DB Provider in Visual ... Studio it shows the schema correctly. ...
    (microsoft.public.data.oledb)