To use the Start Reports functionality in Smart Materials Web, you must configure DBA settings and possibly specify commands as described in this section.
BI_START_REPORT_SERVER
The DBA setting BI_START_REPORT_SERVER must be set that it points to the Oracle Reports server, for example, http://dor-mds-as02.net.com/reports/rwservlet.
REPORT_SERVER
With the Application Server specific DBA setting REPORT_SERVER you define the report server name. The name of the report server is required if you want to use the Oracle report server architecture for running reports. The report server name is generated with the following syntax: ReportsServer_ + <your_machine_name> + _asinst_1. For example, with the machine name dor-mds.as02, the report server name would be ReportsServer_dor-mds-as02_asinst_1.
You can find the name in the Oracle Enterprise Manager (http://<your_machine_name>:7001/em) at the Farm_ClassicDomain/Reports node. Or, you can find it on the file system underneath Oracle/Middleware/asinst_1/ReportsServerComponent.
There must be at least one active value for this setting. If there are more than one active value, you can select the report server name when you run any report.
DEFAULT_TNS_NAMES_ENTRY
This Application Server specific DBA setting defines the default TNS name entry (host string for database).
The value for this dba setting should be the tns name of the database that Smart Materials Web is using.
If the tns name is not specified with this dba setting, you might get a login prompt after starting a report.
Optional BIR Command
The reports started from Smart Materials Web use the parameter commands defined in the Command box on the Parameters screen (see Administration > Parameters) as usual, to show the allowed values for the parameter in the selection list if the parameter query type is Query. Since the Smart Materials reports use :GLOBAL and :CTRL variables which are set during the Smart Materials Classic session, these variables cannot be used for the reports started from Smart Materials Web. To resolve this problem, all standard report parameters which use any of the mentioned variables have an alternative command assigned that is used when starting the report from Smart Materials Web. These alternative commands are displayed in the BIR Command field on the Parameters screen.
If you use any of the values listed below in the Original Value column in your own (custom) reports, you should define a BIR command for the concerning parameters, considering the following instructions.
Original Value |
Replace with |
---|---|
:CTRL.proj_id |
m_sys.w_pck_login.proj_id |
:GLOBAL.proj_id |
m_sys.w_pck_login.proj_id |
:CTRL.user |
m_sys.w_pck_login.proj_id |
:GLOBAL.user |
m_sys.w_pck_login.proj_id |
:CTRL.nls_id |
m_sys.w_pck_login.data_nls |
:GLOBAL.nls_id |
m_sys.w_pck_login.data_nls |
:CTRL.m_usr_id |
m_sys.w_pck_login.usr_id |
:GLOBAL.username |
m_sys.w_pck_login.usr_id |
:CTRL.us_id |
m_sys.w_pck_login.us_id |
:GLOBAL.us_id |
m_sys.w_pck_login.us_id |
:CTRL.dp_id |
m_sys.w_pck_login.dp_id |
:GLOBAL.dp_id |
m_sys.w_pck_login.dp_id |
:CTRL.standard_id |
m_sys.w_pck_bireport.get_standard_id |
:GLOBAL.standard_id |
m_sys.w_pck_bireport.get_standard_id |
:CTRL.standard_code |
m_sys.w_pck_bireport.get_standard_id |
:GLOBAL.standard_code |
m_sys.w_pck_bireport.get_standard_id |
m_pck_ppd_defaults.get_project_default(’<PROJECT_DEFAULT_CODE>’) |
m_sys.w_pck_bireport.get_project_default(m_pck_admin.current_proj_id ,’<PROJECT_DEFAULT_CODE>’) |
Example:
This is the original command used when starting the report from Smart Materials:
select a.cg_group_code, b.short_desc
from m_commodity_groups a, m_commodity_group_nls b
where b.group_id = a.group_id(+)
and b.nls_id(+) = :CTRL.NLS_ID
and ( a.dp_id IN (SELECT g.dp_id
FROM m_us_id_display_disciplines g
WHERE g.us_id = :GLOBAL.US_ID
AND g.display_ind = 'Y' ) or a.dp_id = :Global.dp_id)
/*S.10.02 Commodity Group */
And this is the alternative BIR command which will be used when starting the report from Smart Materials Web:
select a.cg_group_code, b.short_desc
from m_commodity_groups a, m_commodity_group_nls b
where b.group_id = a.group_id(+)
and b.nls_id(+) = m_sys.w_pck_login.data_nls
and ( a.dp_id IN (SELECT g.dp_id
FROM m_us_id_display_disciplines g
WHERE g.us_id = m_sys.w_pck_login.us_id
AND g.display_ind = 'Y' )
or a.dp_id = m_sys.w_pck_login.dp_id)
/*S.10.02 Commodity Group */
In case you use other Forms parameters (for example, :block.item_name), you might contact the support for assistance which appropriate package call should be used instead.