Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.








Showing posts with label R12. Show all posts
Showing posts with label R12. Show all posts

Friday, December 19, 2008

Printer and Pasta configuration on Oracle Applications

Setting up printer in Linux OS (Remote printer configuration)
- Run printtool as root
Illustration I: Printtool Command in Linux


Click new from the popup


Adding a New Print Queue
Here I gave name as HPLaser2105 and short description as HPLaserJet printer in Abdulla Machine (Just to identify)

Defining a Print Queue
You select queue type from the drop-down combo box (Networked Windows (SMB))

Select Queue Type
You click specify from the window.
Select Windows SMB

Here is the configuration window
Configuration - Printer residing Machine
It is finished with configuring. (It will be like (specified))
Configuration - Note the word (Specified)
Next Select printer model, Here I selected PCL6/PCL XL Printer
Note for PCL from Provider


Next Test Print from the printer (It should be printed!) else review the steps.
Test Page Print
After configuration the printer configuration will be like this.
Finish Printer Configuration
You should share, and make the printer as default by clicking edit.

Now the Applications Configuration:
Login as sysadmin and navigate to system administrator then Install:Printer
Then navigate to Driver. Here I created HPLASER2105 (Printer type)
Selected SRW driver as L
Driver method as command and driver method parameters as Spool File
Arguments as
: lp –c –d$PROFILES$.PRINTER –n$PROFILES$.CONC_COPIES –t"$PROFILES$.TITLE" $PROFILES$.FILENAME
To test the argument, please run this command in os command
$lp –c –d -n1 –t"Print Test"
Here I used (example)
lp –c –dHPlaser2105 –n1 –t"Print Test" sqlnet.log


Command Line : Printer command for Linux (telnet)

The printer should work. This is the command we are going to pass as argument in Oracle Apps

Define Printer Driver from SYSADMIN -> Install Print. Provide SRW Driver as L for Landscape
You next navigate to
Install printer -> style
You query for Landscape with SRW driver as L

Look for SRW Driver L for Landscape
Then move to Printer Types
Here you have to define a new type called Hplaser2105 and description as PCL

Create a new Printer TYPE
You select as HPPD, HPW, LANDSCAPE, LANDWIDE,PORTRAIT, PORTRAITLASERCHECK, RL1PAPER styles and correspondence driver files with HPLJ4.

Now. You register the printer
Install:Printer-> Register

Registering Printer
Here I have defined the printer as HPLASER2105, Selected type as HPLASER2105 and Description as Windows Remote Printer Configuration.

Set Profile option for Printer at site level – Most important.

That’s all, we completed. Now
1. Bounce the concurrent Service. It is most important. Whenever, you are doing modification with printer, you should do bouncing the concurrent service.

2. Now run a concurrent request to print a report

3. Here Selected Active users


Print Test with any report (Here I used Active Users)
Click Options.
There you select copies as 1.


Then submit with OK
Now, the concurrent manager should complete with status completed normal. Review the log file.
If any thing happened in middle, please review the steps. Thats All.. Finished Printer configuration in Oracle Applications.

Installing PASTA (FNDPSTAX)
Pasta is Oracle Application utility to convert text report files to Post Script so that these can be printed by PostScript Printers. Executable name for Pasta is FNDPSTAX. For various printing options via Pasta, you can use pasta configuration file called as pasta.cfg

The pasta.cfg is there in $FND_TOP/resource.

Copy the Pasta.cfg to Pasta_(Your printername).cfg. (Oracle recommends to copy the name to your printer name) PASTA makes it easy to customize your printing configuration very easy. So use the OS Printer name to define the Pasta.
1. Replace printer_name parameter in pasta.cfg as one with your OS printer name. Here my printer name is HPlaser2105
The command lp –c –d{printername} should print with command line.
Please check before you make changes with your pasta.cfg.
Screen Shot.
Save and exit.
Login to Oracle Apps as System admin
Navigation Path: Install -> Printer ->Driver -> create a driver, PASTA_PORTRAIT. There will be default PASTA-DRIVERS in built with Oracle Apps, We can use them.
For Portrait -> use SRW driver as P
For LANDSCAPE -> use SRW driver as L
For LANDWIDE -> use SRW driver as LW
You please check the Spool File and program name as FNDPSTAX.
Next:
Install -> Printer -> Type
Here I have created PASTA_POSTSCRIPT_HPLASER2105 with all the drivers.
Then you register.
Install -> Printer -> Register.
Save and Exit.

Restart your concurrent Manager (Important)


Check with Active Reports
You please note, the language I selected As Arabic and PASTA as the printer. Submit the request, It should completed normal. In case any problem in the middle, then review the steps.
Cheers!!!

Wednesday, December 17, 2008

Character Set Conversion

Changing The Character Set In Oracle Applications

Oracle Applications supports the installation of additional languages along with the base installed languages. In case you are doing the installation of these languages at the time of oracle applications installation rapidwiz will make sure you select a compatible character set. In case you plan to install a new language to an already installed instance of Oracle Applications you need to make sure that the database and application character set support the new language.

Changing the character set of Oracle Applications will happen at two places, firstly at the
database level
and then at the application file system level.

Although most of the character set conversion have a different set of process to follow which have been individually documented in various metalink notes. In this post i am will talking about the set of steps that generally hold true for most of the cases.

The main steps that would be required to perform the character set conversion in Oracle Applications are

  • Run the Character Set Scanner utility to identify data conversion issues.

  • Export the identified objects marked for conversion.

  • Perform the Database conversion by user the alter database command.

  • Run adadmin to identify and perform the file system character set conversion.


For the sake of ease I am taking a
US7ASCII
instance running on (you guessed it rite ;) a Redhat Linux and converting it into a UTF8.Although US7ASCII being a binary subset of UTF8 would not really require much of the conversion.

Character Set Scanner utility


Though the change from US7ACII to UTF8 could be done with only using the '
alter database command
' we will use the character set scanner utility CSSCAN to scan for any change required.

Installing the CSSCAN schema
.

Before using the cssan you must install the schema as a user with
DBA privilages
.This is done by executing the csminst.sql script located at $ORACLE_HOME/rdbms/admin

cd $ORACLE_HOME/rdbms/admin
$sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.6.0 - Production on Tue Oct 17 16:00:16 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
SQL> START csminst.sql


Executing CSSCAN


The CSSCAN executable is located at the
$ORACLE_HOME/bin
. After executing the script you must connect to the Database as a user with DBA privileges. The CSSCAN utility prompts you with options to scan a table, schema or the enter database. We choose to scan the entire database in our case.

The CSSCAN displays your current character set version and prompts you to enter the new character set version.


$ csscan
Character Set Scanner v1.1 : Release 9.2.0.1.0 - Production on Tue Oct
17 16:03:15 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Username: system
Password:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

(1)Full database, (2)User, (3)Table: 1 > 1
Enter new database character set name: > UTF8
Enter number of scan processes to utilize(1..32): 1 >



After the successful completion of the scan three report files will be created
scan.txt,scan.out and scan.err.


In my case I have exported the database objects with exceptions as specified in the scan.out and plan to import it back after the database conversion is done.

Changing the Character Set At Database Level

Shutdown all application services and the database and listener.You must do a clean shutdown of your database and start it up in restricted mode before changing the character set.Also you must not have any active sessions before issuing the alter database command.

SQL> alter database character set internal_use UTF8;
alter database character set internal_use UTF8


Import Back Database Objects.

After a successful character set conversion at the database level now you can import back the objects and rebuild the indexes specified the in scan.out report.

Changing the Character Set Application Level


Run adadmin and choose Maintain Applications Files menu. Under this choose the convert character set conversion option.

Here you will be presented with three choices.

1. Scan the APPLTOP for exceptions
2. Scan a CUSTOM directory for exceptions
3. Convert character set
4. Return to previous menu



You must choose the first option and after that in case of Custom directory you could choose the second option. This will scan the APPL_TOP and make a list of application files which would require conversion.

After the scan is complete you can choose to convert the character set.

Repeat the above steps on all your APPL_TOPs in case of a multi node instance.


Thursday, December 11, 2008

Enable Event level Trace in Oracle Applications

February 11, 2008

We need to generate the trace for some application user (either Apps 11i or E-business suite R12). In this case when a user connects to an application its very difficult to track the session.

For this reason we have a profile option, which can be set to generate trace file for any event we want within the application.

Follow the below steps for enabling the event level tracing within an application.

1) Login to application and go to “System Administrator” responsibility.

2) Navigate to “Profile -> System”

3) In the user field, enter the name of user you want to enable tracing for. This will be your application user.

4) On the profile search screen search for “Initialization SQL Statement - Custom” profile.

5) When the profile is shown you can set the value as

begin

fnd_ctl.fnd_sess_ctl(”,”,’TRUE’,'TRUE’,'LOG’,'ALTER SESSION SET EVENTS=”10046 TRACE NAME CONTEXT FOREVER, LEVEL 12” tracefile_identifier=”AppsTrace_10046”’); end;

All the quotes are single quote here. You can just copy and paste the profile value.

6) DO NOT SAVE THE PROFILE

7) In another browser window, login as the user you are going to trace and prepare to reproduce the problem

8 ) Once you are ready to reproduce the problem, go back to the Applications Forms and Save the profile change

9) Reproduce the problem

10) Back in the Applications form, set profile to null so it does not trace anymore and Save the change

11) The trace will be located in the user_dump_dest. The trace can be identified using the trace identifier we have set - “AppsTrace_10046″. If you have set some different identifier, then you can search using that key word.



February 11, 2008

Custom Top in Oracle Application - Creation & Registering

CUSTOM TOP (Registering Custom Application)
Balaji R S

These are all the steps to register a custom top and custom application with Oracle Apps
Create xxncm as custom top, user, schema, application name....

Steps:
Created the directory structure for your custom application files under $APPL_TOP/xxncm
cd $APPL_TOP
mkdir xxncm
mkdir xxncm/11.5.0
mkdir xxncm/11.5.0/admin
mkdir xxncm/11.5.0/admin/sql
mkdir xxncm/11.5.0/admin/odf
mkdir xxncm/11.5.0/sql
mkdir xxncm/11.5.0/bin
mkdir xxncm/11.5.0/reports
mkdir xxncm/11.5.0/reports/US
mkdir xxncm/11.5.0/forms
mkdir xxncm/11.5.0/forms/US
mkdir xxncm/11.5.0/$APPLLIB
mkdir xxncm/11.5.0/$APPLOUT
mkdir xxncm /11.5.0/$APPLLOG

Added entry XXNCM_TOP=/apps/oracle/visappl/xxncm in Enviornment file.

export XXNCM_TOP
You can source all the environment files before proceeding.

Create new tablespace for database objects

create tablespace xxncm datafile '/apps/oracle/visdata/xxncm.dbf' size 10M;

Create schema

SQL> create user xxncm identified by xxncm default tablespace xxncm
temporary tablespace temp quota unlimited on xxncm quota unlimited on temp;

SQL> grant connect, resource to xxncm;

Register your Oracle Schema

Login to Applications with System Administrator responsibility

Navigate to
Application–>Register

Application = Custom Application

Short Name = xxncm

Basepath = xxncm_TOP

Description = Custom Application

Register Oracle User

Naviate to
Security–>Oracle–>Register

Database User Name = XXNCM

Password = XXNCM

Privilege = Enabled

Install Group = 0

Description = Custom


Rapidwiz Actions while Installation of Oracle Applications (R12)

Installation Steps (Rapid Install R12)
$ ./rapidwiz
Rapid Install Wizard is validating your file system......

4 dvd labels found
Rapid Install Wizard will now launch the Java Interface.....
$

Configuration file written to:
oracle/R12/db/tech_st/10.2.0/appsutil/conf_r12test.txt
Configuration file written to:
/oracle/R12/apps/apps_st/appl/admin/ap6155rt/conf_r12test.txt
Configuration file written to:
/oracle/R12/inst/apps/r12test_ap6155rt/conf_r12test.txt
Database logfile
/oracle/R12/db/tech_st/10.2.0/appsutil/log/r12test_ap6155rt/01050832.log
Appltop logfile
oracle/R12/inst/apps/r12test_ap6155rt/logs/01050832.log
$

In the session, I have been given two logs.
1) DB log file
2) Application Side Log file

If you read the DB log file and application log file you will come to know installation
uses Rapid Cloning method. Hence the installation takes less than 100 minutes. Its really Rapid Install...!!!

25 Steps that Happens during rapidwiz

1) It prompts you the details of the installation
2) It dumps all the values you have fed in log files for reference
3) Instantiates context template files
4) It builds the DB side context xml
5) It checks the ports availability
6) It performs OS User and Group Checks
7) It does Port Uniqueness Check
8) File System Check whether file system is writable
9) File Space check
10) Host Domain check It uses ping utility to check the reachability of the host
11) It copies DB techstack and configures (oracle.apps.ad.clone.ApplyDBTechStack)
12) It installs the DB either vision or prod depending on the selection and does apply portion of DB(oracle.apps.ad.clone.ApplyDatabase)
13) Performs character set conversion. In our case I have selected UTF8, default was US7ASCII
14) Bounces DB
15) Runs DB side Autoconfig
16) Brings up the DB listener ( End of DB portion of install)
17) MidTier iAS stack installation(adrunias.sh)
18) registration(oracle.apps.ad.clone.ApplyAppsTechStack phase reg),configuration (phase cfg) of Mid Tier
19) Installing Appltop
20) copying appltop context file
21) registering appltop( oracle.apps.ad.clone.ApplyApplTop phase reg)
22) Autoconfig MidTiernode
23) starts the MT services
24) Test of installation ( DBC File, env file tests, HTTP test, Help page test, Virtual Directory test), JSP ping test, Login page test
25) Summarizes the installation in screen
Review the installation logs for errors........

Related Posts Plugin for WordPress, Blogger...

Let us be Friends...

Share |

Popular Posts

Recent Comments