Bind references are used to replace a single value in SQL or PL/SQL. Specifically, bind references may be used to replace expressions in SELECT, WHERE, GROUP BY, ORDER BY, HAVING,CONNECT BY, and START WITH clauses of queries. Binds may not be referenced in the FROM clause.
An example is:
SELECT Col1,Col2
FROM XX_table
WHERE Col1 = :P_col1
Lexical references are placeholders for text that you embed in a SELECT statement. You can use lexical references to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY , ORDER BY , HAVING, CONNECT BY, and START WITH. You cannot make lexical references in PL/SQL. Before you reference a lexical parameter in a query you must have predefined the parameter and given it an initial value.
An example is:
SELECT Col1,Col2
FROM &ATABLE
Monday, November 26, 2007
Common Reporting Tools
Oracle Reports: Fixed format reports delivered with the 11i release were built on this tool. This is the most used tool for reporting on Oracle Applications. Most of reports customizations are built with this tool. Once customized the output of the report can be in Excel (Not group By Report), word, Acrobat documents or text format.
Oracle Discoverer: is an intuitive tool for creating reports and performing on-line analysis. Discoverer uses the EUL (End User Layer), a meta data definition, which hides the complexity of the database from the end user and provides easy to use wizards for creating reports to suit individual needs. The flexibility of this tool allows the user to create cross tab reports that perform like pivot tables in Excel.
Oracle XML Publisher: is a new Oracle tool for reporting. It enables users to utilize a familiar desktop tool, like MS Word or MS Excel, to create and maintain their own report. At runtime, XML Publisher merges the custom templates with the concurrent request extracts data to generate output in RTF, PDF, HTML and EXCEL.
RXi Report: (Variable reports) – variable format reports delivered with the E-Business 11i. With this tool a user has the ability to print the same report with multiple layouts. The user can also choose which columns he requires on a particular report. This tool is most used on Oracle Financials Applications
FSG Reports (Financial Statement Generator): is a powerful report building tool for Oracle General Ledger. Some of benefits of using this tool are that a user can generate financial reports, and schedule reports to run automatically. The only drawback of this tool is that it is only available for the general ledger responsibility and can be used to see only financial account balances.
Business Intelligence System (BI): is a set of tools to provide high level information for the managers (decision makers) to run their business such as the profitability of a particular business unit. The information this tool provides helps managers to take the right decision with the daily data that is uploaded on their systems
Oracle Discoverer: is an intuitive tool for creating reports and performing on-line analysis. Discoverer uses the EUL (End User Layer), a meta data definition, which hides the complexity of the database from the end user and provides easy to use wizards for creating reports to suit individual needs. The flexibility of this tool allows the user to create cross tab reports that perform like pivot tables in Excel.
Oracle XML Publisher: is a new Oracle tool for reporting. It enables users to utilize a familiar desktop tool, like MS Word or MS Excel, to create and maintain their own report. At runtime, XML Publisher merges the custom templates with the concurrent request extracts data to generate output in RTF, PDF, HTML and EXCEL.
RXi Report: (Variable reports) – variable format reports delivered with the E-Business 11i. With this tool a user has the ability to print the same report with multiple layouts. The user can also choose which columns he requires on a particular report. This tool is most used on Oracle Financials Applications
FSG Reports (Financial Statement Generator): is a powerful report building tool for Oracle General Ledger. Some of benefits of using this tool are that a user can generate financial reports, and schedule reports to run automatically. The only drawback of this tool is that it is only available for the general ledger responsibility and can be used to see only financial account balances.
Business Intelligence System (BI): is a set of tools to provide high level information for the managers (decision makers) to run their business such as the profitability of a particular business unit. The information this tool provides helps managers to take the right decision with the daily data that is uploaded on their systems
Install 11i
Installing Oracle Applications , Become Apps DBA II
Install Oracle Apps
Install Oracle 11i (11.5.10.2) on Linux
In today’s post I will cover things you need to install Oracle Apps 11i (11.5.10.2) on Linux.
Software
1. Software for Oracle 11i can be downloaded from edelivery.oracle.com(46 zip files) or you can order disks via metalink account.
2. Unzip these files and this should create five directory startCD, oraAppDB, oraApps, oraDB, oraiAS
O. S. Requirement
1. Linux Package : make sure you have ar, gcc, g++, ld, ksh, make, X Display Server
2. Disk Space : 26 GB for Application Tier & 65 GB for Vision Database (31 GB for fresh database). Hence total 57 GB for fresh DB & 91 GB for Vision Instance.
3. If you are installing apps 11.5.10.2 from Staging area you need another 24GB (No need if you are doing install from inserting CD’s on prompt)
4. O.S. User : Create two operating system user, avis11i (Application Tier) & ovis11i (Database Tier) both belonging to group DBA. You can use single user as well for both Application Tier & Database Tier
5. JDK : No need to install JDK 1.4.2 on solaris, Linux or windows as 11i Installer will install it. For other operating system you need to install JDK 1.4.2
6. For full list of RPM’s required on Red Hat Enterprise Linux Visit Metalink Note # 303859.1
Things you must do/know before installation
A) set environment variable LD_ASSUME_KERNEL=2.4.19 for root user
B) gcc -v (Should be of version 3.2.x) For any other version
mv /usr/bin/gcc /usr/bin/gcc.orig
mv /usr/bin/g++ /usr/bin/g++.orig
ln -s /usr/bin/i386-redhat-linux-gcc32 /usr/bin/gcc
ln -s /usr/bin/i386-redhat-linux-g++32 /usr/bin/g++
C) If your installation fail some time restart installation by option restart like
“rapidwiz -restart”
D) If you try to access apps from linux machine from browser other than Mozilla (like KDE)you will get error message that “You have insufficient privileges for current operation”
E) Installer should be started from root user
Starting Installation
1. Go to Staging directory /stage_location/startCD/Disk1/rapidwiz/
2. ./rapidwiz
3. Create base directory under which you wish to install database & apps tier with proper permission (owner) (Five main directory - [SID]appl,[SID]comn,[SID]ora owned by application user (avis11i) & [SID]db, [SID]data owned by database o.s. user (ovis11i) )
Post Install
1. Set environment variable in O.S. user profile
/install_base/[sid]appl/APPSORA.env (For Application Tier User, avis11i)
/install_base/[sid]db/SID_hostname.env (For Application Tier User, ovis11i)
2. For start/stop services of Oracle Apps 11i visit
11i Startup/Shutdown Scripts
Error/Issues during 11i Install
Issue : RW-50004: Error code received when running external process. Check log file for details. Running Database Install Drivers for VIS Database
Check Logsat : $install_base/[sid]db/9.2.0/appsutil/log/[SID]_[hostname]/MMDDHHMM.log
Error while running adlnkoh.sh, log for adlnkoh.sh at $install_base/[sid]db /9.2.0/install/make.log
In make.log file libgcc_s.so : undefined reference to `dl_iterate_phdr@GLIBC_2.2.4`
Fix : This issue is very well explained in Note : 363600.1 ‘dl_iterate_phdr@GLIBC_2.2.4′Error on Linux Running Rapidwiz
References:
303859.1 Requirements for Installing Oracle 9iR2 on RHEL 4
http://download.oracle.com/docs/cd/B25516_18/current/acrobat/r115102ins.pdf
Install Oracle Apps
Install Oracle 11i (11.5.10.2) on Linux
In today’s post I will cover things you need to install Oracle Apps 11i (11.5.10.2) on Linux.
Software
1. Software for Oracle 11i can be downloaded from edelivery.oracle.com(46 zip files) or you can order disks via metalink account.
2. Unzip these files and this should create five directory startCD, oraAppDB, oraApps, oraDB, oraiAS
O. S. Requirement
1. Linux Package : make sure you have ar, gcc, g++, ld, ksh, make, X Display Server
2. Disk Space : 26 GB for Application Tier & 65 GB for Vision Database (31 GB for fresh database). Hence total 57 GB for fresh DB & 91 GB for Vision Instance.
3. If you are installing apps 11.5.10.2 from Staging area you need another 24GB (No need if you are doing install from inserting CD’s on prompt)
4. O.S. User : Create two operating system user, avis11i (Application Tier) & ovis11i (Database Tier) both belonging to group DBA. You can use single user as well for both Application Tier & Database Tier
5. JDK : No need to install JDK 1.4.2 on solaris, Linux or windows as 11i Installer will install it. For other operating system you need to install JDK 1.4.2
6. For full list of RPM’s required on Red Hat Enterprise Linux Visit Metalink Note # 303859.1
Things you must do/know before installation
A) set environment variable LD_ASSUME_KERNEL=2.4.19 for root user
B) gcc -v (Should be of version 3.2.x) For any other version
mv /usr/bin/gcc /usr/bin/gcc.orig
mv /usr/bin/g++ /usr/bin/g++.orig
ln -s /usr/bin/i386-redhat-linux-gcc32 /usr/bin/gcc
ln -s /usr/bin/i386-redhat-linux-g++32 /usr/bin/g++
C) If your installation fail some time restart installation by option restart like
“rapidwiz -restart”
D) If you try to access apps from linux machine from browser other than Mozilla (like KDE)you will get error message that “You have insufficient privileges for current operation”
E) Installer should be started from root user
Starting Installation
1. Go to Staging directory /stage_location/startCD/Disk1/rapidwiz/
2. ./rapidwiz
3. Create base directory under which you wish to install database & apps tier with proper permission (owner) (Five main directory - [SID]appl,[SID]comn,[SID]ora owned by application user (avis11i) & [SID]db, [SID]data owned by database o.s. user (ovis11i) )
Post Install
1. Set environment variable in O.S. user profile
/install_base/[sid]appl/APPSORA.env (For Application Tier User, avis11i)
/install_base/[sid]db/SID_hostname.env (For Application Tier User, ovis11i)
2. For start/stop services of Oracle Apps 11i visit
11i Startup/Shutdown Scripts
Error/Issues during 11i Install
Issue : RW-50004: Error code received when running external process. Check log file for details. Running Database Install Drivers for VIS Database
Check Logsat : $install_base/[sid]db/9.2.0/appsutil/log/[SID]_[hostname]/MMDDHHMM.log
Error while running adlnkoh.sh, log for adlnkoh.sh at $install_base/[sid]db /9.2.0/install/make.log
In make.log file libgcc_s.so : undefined reference to `dl_iterate_phdr@GLIBC_2.2.4`
Fix : This issue is very well explained in Note : 363600.1 ‘dl_iterate_phdr@GLIBC_2.2.4′Error on Linux Running Rapidwiz
References:
303859.1 Requirements for Installing Oracle 9iR2 on RHEL 4
http://download.oracle.com/docs/cd/B25516_18/current/acrobat/r115102ins.pdf
Subscribe to:
Posts (Atom)
Posts
