Oracle ACE Pro
Oracle Solution Architect
Oracle E-Business Suite
Oracle Cloud Infrastructure
Oracle Fusion Middleware
Oracle Database Administration
Oracle Weblogic Administration
Oracle ACE Pro
Oracle Solution Architect
Oracle E-Business Suite
Oracle Cloud Infrastructure
Oracle Fusion Middleware
Oracle Database Administration
Oracle Weblogic Administration
First check the status of printer at unix level by issuing the following command:
$lpstat –a
Navigation : Install > Printer > Driver

Please provide the below values (depending upon your configuration) to set up.
Enter the Driver Name: ERW2PAPER
Enter the User Driver Name: HPLJ4- For Employers Paper W2
Description: Potrait printing for Employer’s Paper W2
SRW Driver: LW2

SRW drivers are read by Oracle reports when a report is run and insert control characters which tell the destination printer on where to insert the page breaks and font to be used. SRW driver is used when output file is sent to the printer
SRW driver files on unix are located in $FND_TOP/reports.
Navigation : Install > Printer > Style
Login to application using System Administrator or Application Administrator Responsibility.
Please provide the below values (depending upon your configuration) to set up.
Style Name : HPW
Seq: Enter unique sequence number
User Style: LANDWIDE – HPLJ4
SRW Driver: HPW , this should match with driver define page
Layout: Columns,Rows
Orientation: Columns and Rows inserted here override the height and width defined in SRW driver file

Navigation: Install > Printer > Type
Please provide the below values (depending upon our configuration) to set up.
Type: HPLJ4SI
Style: Style name
Driver Name: Driver name

Navigation : Install > Printer > Register
Login to application using System Administrator or Application Administrator Responsibility.

Please provide the below values (depending upon your configuration) to set up.

Printer: Printer Name
Type: Type defined earlier
Description: Useful description
The Financial Statement Generator (FSG) is a powerful reporting engine that supports interchangeable report objects, server-based processing for high performance, and report scheduling for efficient use of system resources. You can define reports on-line with complete control over the rows, columns and contents of your report.
A report component you build within Oracle by defining all of the rows in your report. For each row, you control the format and content, including line descriptions, indentations, spacing, page breaks, calculations, units of measure, precision and so on. For example, you might define a standard balance sheet row set.
A column set defines the format and content of the columns in an FSG report. In FSG, the commonly assumed attribute for a column definition is a time period (amount type), whereas the attribute for a row definition is an account assignment. Therefore, typical column sets include headings and subheadings, amount types, format masks, currency assignments, and calculation columns for totals.
A report component that you build within Oracle that defines the information in each report and the printing sequence of your reports. For example, you can define a departmental content set which prints one report for each department.
A report component that you use to modify the current order of rows and Accounting Flexfield segments in your report. You can rank your rows in ascending or descending order based on a selected column and rearrange the sequence of segments in your Accounting Flexfield. For example, if you want to review Total Expenditures in descending order by project, you can rank your rows in descending order by the Total Expenditures column and rearrange your segments so that project appears first on your report.
A Financial Statement Generator report component that you build within Oracle to control the display of ranges of rows and/or columns in a report, without reformatting the report or losing header information. You can define a display set which works for reports that use specific row and column sets. Or, you can define a generic display set which works for any report, regardless of its row and column set.
eXtensible Business Reporting Language (XBRL) is an open specification for software that uses Extensible Markup Language (XML) data tags, together with a taxonomy, to describe business reporting, including financial information. An XBRL taxonomy is a standard description and classification system for the contents of accounting reports.

SELECT file#,
status,
bytes / 1024 / 1024 “Size_MB”,
name
FROM v$tempfile;
SELECT file_name,
tablespace_name,
bytes / 1024 / 1024 / 1024,
status
FROM dba_temp_files;
SQL>ALTER TABLESPACE temp ADD tempfile ‘/u02/apps/oracle/temp01_01.dbf’ SIZE
2048m;
SQL>CREATE TEMPORARY TABLESPACE temp2 tempfile ‘/u02/apps/oracle/temp01.dbf’ SIZE 2g autoextend ON;
SQL>ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2;
Note: use “reuse” if datafile physically exists.
SQL>ALTER DATABASE tempfile ‘/u02/apps/oradata/temp01.dbf’ OFFLINE;
SQL>DROP TABLESPACE temp INCLUDING CONTENTS AND datafiles;
NOTE: Don’t drop immediatly, Check user is using TEMP tablespace by the Below Given Query, then you can drop
SELECT a.username,
a.osuser,
a.sid
||‘,’
||a.serial# SID_SERIAL,
c.spid Process,
b.tablespace tablespace,
a.status,
SUM(b.extents) * 1024 * 1024 SPACE
FROM v$session a,
v$sort_usage b,
v$process c,
dba_tablespaces d
WHERE a.saddr = b.session_addr
AND a.paddr = c.addr
AND b.tablespace = d.tablespace_name
GROUP BY a.username,
a.osuser,
a.sid
||‘,’
||a.serial#,
c.spid,
b.tablespace,
a.status;
SQL>ALTER TABLESPACE temp shrink tempfile ‘/u02/apps/oradata/temp01.dbf’ keep 10g;
All Rights Reserved