Running Report from Command Prompt
To run the pay_register.rdf custom report from the Command Prompt, enter the following command at the prompt:
C:> C:oracleproduct10.2.0db_2binrwbuilder.exe report="C:Documents and Settingsuser01DesktopReports Tuning Issuetest.aippay_register.rdf" userid=apps/apps@vis2.world tracemode=TRACE_APPEND tracefile=c:temppay_register01.txt traceopts=(trace_SQL,TRACE_PLS,trace_prf,trace_tms)
The report loads in Reports Builder.
1. Compile the packages by typing Shift+Ctrl+K.
2. Run the Paper Layout version of the report by Shift+Ctrl+R.
3. In the Payroll ID parameter field, enter 112.
4. In the Pay Advice Date field, enter 2003/08/29.
Running SQL Code in SQL Developer
1. Open the report in Reports Developer and double-click on the Data Model icon (not word).
2. Double-click the Q_1 box. The SQL code for the Q_1 query appears.
3. Copy all the SQL code and run it in SQL Developer.
4. For the p_payroll_id, enter 112
5. For the p_pay_advice_date, enter 29-AUG-2003
0 Comments.