OID Resource Access Descriptors in Forms and Reports

November 30 0
Advertisement
Dear Colleage,
In my Forms application (Oracle Application Server 10g (version 9.04), I call Reports from certain Forms. I have have SSO activated in both Forms and Reports. I have also defined two RADs (Resource Access Descriptors) in the OID called RKMSPROD and RKMSTEST, i.e. for the production DB and test DB respectively. I successfuly configured my formsweb.cfg file with [RKMSPROD] and [RKMSTEST] and can access the the corresponding DB using the URL parameter, e.g. CONFIG=RKMSTEST.
Question 1
========
Is the DB connection associated with the RADs (i.e. RKMSPROD or RKMSTEST in my case) implicitly passed on to the Reports server when I start a report job via the built-in RUN_REPORT_OBJECT or do I have to explicitly add the SSOCONN=RKMSTEST parameter before using the built-in RUN_REPORT_OBJECT?
Question 2
========
If I have to set the SSOCONN, how can I find out programatically, which RAD is currently active? I am using the same forms to access the two different DBs.
Best regards,
Charles
Advertisement
Connect info is passed when making the RUN_REPORT_OBJECT call. No changes to Reports is needed. The only requirement is that both Forms and Reports have SSO enabled. The same information used to connect to Forms will be used to connect to Reports.
More details are described in the Forms/Reports Integration White Paper:
http://www.oracle.com/technology/products/forms/pdf/10g/frm10gsrw10g.pdf
Specifically refer to the section titled "Using the Run_Report_Object () Built-in" on page 20.
OID Resource Access Descriptors in Forms and Reports

Dear Colleage, In my Forms application (Oracle Application Server 10g (version 9.04), I call Reports from certain Forms. I have have SSO activated in both Forms and Reports. I have also defined two RADs (Resource Access Descriptors) in the OID called

Get Resource Access Descriptor from OID in Java

Hi, I'm trying to get my ADF program to read DB credentials from a Database RAD - Resource Access Descriptor defined for my SSO users in OID (version 10.1.2.1.0). Examples are rare and sometimes they refer to deprecated functions or librairies. If so

OIM Custom reports - User Resource Access History

HI, I am working on OIM custom reports . I was trying to get custom user resource access history( i.e., need to include information like field changed, its old value , its new value etc are the extra info I need in the report ). To achieve this I had

How do you use Default Resource Access Information?

I have some 10g Forms & Reports that I want to use with SSO and they will all be connecting to the database with the same connection info. I know how to configure a Default Resource Access Information, but how do you use this with Forms & Reports?

How to choose different SSO/OID resource name - when start application?

Background We are new to 10g(10.1.2.0.2) We have an environment where we have a front end 10g application (set of screens, menus, reports etc) that we like to be able to run against different backends. Eg one database for one set of data and another

Android MS RDP - RPC Error: Your connection was denied because of a Resource Access Policy (TS_RAP). Please contact your server administrator. (2147965402).

I love iTap Mobile.  Paid for the app.  Sorry to see them discontinue it, but now I know why.  Microsoft bought them out!  But even though free, I am getting an error: RPC Error: Your connection was denied because of a Resource Access Policy (TS_RAP)

Unable to review the resource access information

Hi, I am new to portal. I am runing Oracle Portal Version: 10.1.2.3.0 (Build: 263). I am able to review or edit my resource access information. However, I only see the blank information when I try to modify the other users. Could somebody let me know

OracleXe - how to create a database access descriptor (DAD)

Hi folks, I am trying to figure out how to create a DAD (database access descriptor) so I can access my pl/sql server pages which are installed on my oracleXe database. I have searched the docs and this forum and OTN but haven't found any information

Using ops$ accounts with Database Access Descriptors

Hi, I have installed and configured the Photo Album demo under 9i on Windows 2000 with no problems. I wish to use the operating system via oracle ops$ accounts to provide access to the Db through the Database Access Descriptor using the Gateway Datab

OID resource goes to Disabled Status after running the post process event handler

Hi, We have an event handler on post update operation. The event handler using the user manager API to do some modification. We are using the "Lock()" function of User Manager API to lock the user based on attribute value. After running the even

Architecture purity vs. Resource access optimization

I'm working on a rather complex application with a number of pattern implementations like DAO and Service, but I'm not an experienced developer, so I often find myself in situation, when I can't decide, whether to pursue more strict pattern implement

Request OID group access in OIM

Hi All, I have OIM (11.1.1.5.2) and the OID Connector (9.0.4.14) installed. Is it possible for a user to request access to a specific group in OID using the OIM Self Service Console? Regards, user10233157Yes, This is possible. You need to create requ

Unable to Access BI InfoSet in Crystal Reports using SAP Info sets driver

Hi, I am looking to develop a report on top of BI InfoSet in Crystal Reports. However using the the SAP InfoSets driver I am only able to visualize 'Classic InfoSet' and 'SAP Query'. It does not show the option to import the regular InfoSet as a data

Can I access Infoset variable from Crystal Reports

Hi, In order to connect Crystal Reports 2008 to the SAP environment I have the Integration kit. I have learnt that Crystal also offers InfoSet driver to connect to SAP. If I need to access SAP BI- Infoset variables inside Crystal Reports is it possib

Access denied error for BW Report iView..Please help :(

Hello All, I have created a BW Report iView..containing a Bex query. Have created the required BW system object too. When I preview this iView, it asks me for BW system authentication....since am not mapped to this BW system. Its alright till here...

Unable To Print or Access Page Setup in Crystal Reports 2008

I have Win 7 32 bit, and installed Crystal Reports 2008 last week (v12.0.0.683 from the Help window). Every time I open a report, and from the Preview tab clicking File -> Print, or File - > Page Setup, I immediately receive a Windows message that &

The process cannot access the file during Crystal Report export

We are exporting crystal reports into PDF using  ExportToHttpResponse (code snippet below)       // Getting the type of the report file which has been selected by the user. (which will be REPORT CLASS type) Type objType = Type.GetType("WebApplication

Accessing Lotus Notes from Crystal Reports in AIX

Hi BO world We've installed the BO Enterprise Server  on an AIX 5.3 platform and we want to connect this BO server to a Lotus Domino Server (version 8 on a Windows Server Platform ) to show the data on Crystal Reports. The problem is that we can't fi

Accessing BO XI Desktop intelligence reports through ASP 3.0

<p>I am trying to view BO XI Desktop intelligence reports through a customized application in ASP 3.0. The examples that I have come accross are all related to Crystal reports and none is related to BO XI ".rep" files. Please let me know i

ABAP User Roles and Query for accessing particular T- codes and Reports

dear Gurus I have one problem, i want to know about ABAP User Query ,i have one requirement my user wants to Lock all the HR Std versus Customized reports in T- code SQ01,other department peoples also see the Payslips and Hr personal reports which is