Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Month: November 2017

November 3, 2017 An Introduction to Financial Statement Generator (FSG)
Configurations-GLGeneral LedgerOracle Functional

An Introduction to Financial Statement Generator (FSG)

Financial Statement Generator

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.

Features

  • Standard reports are generally more detailed than FSG.s and many focus on transaction level detail.
  • FSG report shows off account balances in General Ledger only.
  • Oracle Financial Statement Generator builds reports using re-useable components.
  • In order to create a report you must first define each of the component parts, which may include:
    • Row Set
    • Column Set
    • Content Set
    • Row Order
    • Display Set
  •  You must combine at least a row set and a column set to produce the reports you need.
  • You may group reports into report sets.

Row Set

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.

Column 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.

Content Set

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.

Row Order

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.

Display Set

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

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.

November 1, 2017 unable to spawn jobq slave process, slot 0, error 1089
Errors/Workarounds10gErrors/Workarounds11gErrors/Workarounds12cOracle Database Material

ERROR

kkjcre1p: unable to spawn jobq slave process, slot 0, error 1089

(more…)

November 1, 2017 Temporary Tablespace and Datafile Management in Oracle database
Installation/Configurations10gInstallation/Configurations11gInstallation/Configurations12cOracle Database Material

Temporary Tablespace and Datafile Management in Oracle database

1.  For Finding temp file and temp tablespace with size

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; 

2. Add tempfile to existing temp tablespace

SQL>ALTER TABLESPACE temp ADD tempfile ‘/u02/apps/oracle/temp01_01.dbf’ SIZE 
2048m; 

3. Add new temp tablespace and make as default

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.

4. Making old Temporary Tablespace Offline

SQL>ALTER DATABASE tempfile ‘/u02/apps/oradata/temp01.dbf’ OFFLINE; 

5. Drop Temporary Tablespace 

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; 

6. Shrink Temporary Tablespace

SQL>ALTER TABLESPACE temp shrink tempfile ‘/u02/apps/oradata/temp01.dbf’ keep 10g;

November 1, 2017 A Brief Introduction to ADPatch
APPS DBAInstallations/Configurations-ApplicationsOracle APPS DBA

A Brief Introduction to ADPatch

AutoPatch (adpatch)

“AutoPatch (adpatch) is the utility you use to apply patches to the Oracle E-Business Suite file system or database.”

 

Modes Of adpatch

There Are Four Modes given Below In which ADpatch Can Be User

  1. Interactive mode
  2. Non-Interactive mode
  3. Test mode
  4. Pre-Install mode

 

Interactive Mode

It is the default mode of ADpatch. We can apply patch in this mode by going into patch directory and simply type adpatch in command prompt and hit enter.

 

Non-Interactive

You can apply Patch in this mode as:

$adpatch Interactive=no

It uses default files to store prompt values and can be applied from patch directory.

 

Test Mode

This mode is purposely used to check what exactly patch will do without actually changing anything.

We can apply patch in this mode as:

$adpatch apply=no

By default apply=yes

 

PreInstall Mode

This mode is used for any upgrade or consolidated update of utilities itself. It is suggested to apply pre-install patch first.

When we apply patch in preinstall mode, it updates all AD utilities before upgrade or update.

We can apply adpatch in this mode as:

$adpatch preinstall=y

 

Options used in adpatch

We have multiple adpatch options and based on the requirement we can use specific options.

Noautoconfig

This options is used to skip the autoconfig execution, whereas by default it executes the autoconfig and updates the configuration file if any template file is added. This option is helpful when we apply multiple adpatch and they are not merged.

$adpatch options=noautoconfig

 

Nocompiledb(without compiling database)

While we apply adpatch, It may create invalid objects and by default adpatch compiles the invalid objects after patch application. But in case you do not want to compile invalid objects to ensure the minimal autopatch time, you can apply adpatch as below:

$adpatch options=nocompiledb

 

Nocopyportion

This option is used to apply adpatch without copying the files present in copy driver. This can be applies as:

$adpatch options=nocopyportion

 

Nocompilejsp

Adpatch also compiles the java server pages(JSP) after completion of patch application and can be skipped using the option nocompilejsp as below:

$adpatch options=nocompilejsp

 

Nodatabaseportion

Nodatabaseportion option is used to skip the adpatch the activity of database driver. It can be used as:

$adpatch options=nodatabaseportion

 

Nogenerateportion

Nogenerateportion option is used to skip the adpatch activity of generate driver portion of the patch  and you can use the option nogenerateportion as below:

$adpatch options=nogenerateportion

 

Maintenance Mode disabled

This option is used to apply patch without enabling maintenance mode. It can be used as:

$adpatch options=hotpatch

 

Nolink

This option is used to skip the relinking and can be used as:

$adpatch options=nolink

 

Nogenform

This option is used to skip the generate form file. It can be used as:

$adpatch options=nogenform

 

Maintainmrc

This Option is used to execute the maintain MRC schema as part of patch. By default maintain MRC is done for standard patch and is disabled for documentation and translation patches.

$adpatch options=nomaintainmrc

 

Noprereq

This option is used to skip the pre-requisite Checks of Patches. This option can be used as below:

$adpatch options=noprereq