Wednesday, August 27, 2008
How is the Workflow Background Process / OTL Workflows for Employees setup?
Answer is provided at
Sucharitha.com > Forum > Oracle HRMS Application Help > Oracle Time & Labor > How is the Workflow Background Process / OTL Workflows for Employees
How to Validate Multiple OTL Batches at One Time Before Moving to BEE?
Check out the answer at Sucharitha.com > Forum > Oracle HRMS Application Help > Oracle Time & Labor > How to Validate Multiple OTL Batches at One Time Before Moving to BEE?
How to Add Lov to a Timecard?
check out the answer at
Sucharitha.com > Forum > Oracle HRMS Application Help > Oracle Time & Labor > How to Add Lov to a Timecard?
How to enable Date Tracking for the Oracle Time and Labor OTL product
Check out the answer @
Sucharitha.com > Forum > Oracle HRMS Application Help > Oracle Time & Labor > How to enable Date Tracking for the Oracle Time and Labor (OTL) product.
Thursday, July 19, 2007
Release 11i Documentation Titles (11.5.10)
Click on the link below and check for the document you want and post a comment if you need more information .
http://spreadsheets.google.com/pub?key=pd7jnzILIpyYazX-mzhfoPw
Wednesday, July 18, 2007
Troubleshooting Concurrent Manager (UNIX specific)
PURPOSE:
This template requires the essential matter for troubleshooting Unix Concurrent Manager Problems.
SCOPE & APPLICATION:
-------------------
This reference is intended for use by one who is familiar with the concurrent manager process.
Trouble shooting UNIX concurrent manager
----------------------------------------
1. Have you tried shutting down, running the cmclean script and re-starting the Concurrent Managers?
[YES] Check logfiles
[NO] Try it, customer may have been logged in as the wrong user or incorrectly typed the startup command.
You can run the cmclean.sql script within Note 134007.1 to reset the concurrent
Manager tables whilst the Concurrent Managers are down.
2. Are there any FNDLIBR processes still running even after the attempted shutdown?
Use command PS -ef | grep FNDLIBR
[YES] UNIX: Use kill -9 to clean them up
[NO] Continue troubleshooting
3. Are there any errors in the logfiles?
Logfiles are in $FND_TOP/log or $APPLCSF/$APPLLOG if defined.
Logfiles are usually named STD.MGR or the CCM name(i.e. PRDMGR.MGR)
[YES] Make note of the errors and search Metalink for these errors.
If no resolution is found, open a SR and upload the logfiles.
[NO] Have ct restart the Concurrent Manager from the command line to have a new log file created.
Command to start the CCM:
startmgr sysmgr=apps_schema_owner/password logfile=std.mgr
* This should create logfile std.mgr
* If no logfile exists, check for UNIX permissions and space on filesystem.
4. How many rows are in FND_CONCURRENT_REQUEST and
FND_CONCURRENT_PROCESSES tables?
Check the FND tables using the sql statements below. When these tables reach above 3-4K rows performance begins to suffer when viewing report output and the Internal Concurrent Managers often does not start due to the lengthy search through
FND_CONCURRENT_PROCESSES table. You may want to run Purge Concurrent
Request and/or Manager Data on a regular basis.
Please run diagnostic script found under Note 200360.1 for common problematic issues.
Upload the output from the diagnostic script to the SR for Oracle Support review.
5. Are any processes pending in the Internal or Conflict resolution Manager?
Pending jobs in either the Internal or Conflict Resolution Manager may prevent the Concurrent Manager from starting. The best course of action before starting the Concurrent Managers is to cancel any "Deactivate" or "Verify" jobs pending in the Internal Manager and to place any other pending jobs on hold.
Additional Information:
1. Number of records in the following Tables:
FND_CONCURRENT_REQUESTS
FND_CONCURRENT_PROCESSES
FND_DUAL
Command: Logged in SQLPLUS as APPLSYS(or demo - APPDEMO)
select count(*) from FND_CONCURRENT_REQUESTS
2. Sometimes it is necessary to rebuild the Concurrent Manager views.
This is non-destructive.
Concurrent Manger views can be rebuilt by running the following
Command at the command line: FNDCPBWV is a immediate concurrent
program that is a part of FNDLIBR.
UNIX & Windows NT
FNDLIBR FND FNDCPBWV apps/apps SYSADMIN 'System Administrator'
SYSADMIN
VMS:
FNDLIBR "FND" "FNDCPBWV" apps/apps "SYSADMIN" "System
Administrator" "SYSADMIN"
USEFUL SCRIPTS
--------------
Note 213021.1 Concurrent Processing (CP) / Apps Reporting Scripts
RELATED DOCUMENTS
-----------------
Note 74717.1: Troubleshooting Concurrent Manager Startup problems
Note 97798.1 ORA-904 when starting concurrent managers
Note 230121.1 Routine AFPEIM encountered an error while starting Concurrent Manager on Cloned instance
Note 1059201.6 Status pending with 'Inactive No Manager' cor Concurrent Requests
Note 113135.1 Conflict Resolution Manager FNDCRM Does Not Start; No
Error Message.
Note 123607.1 CONCSUB SYSADMIN 'System Administrator' GIVES INVALID RESPONSIBILITY ERROR
Note 2055375.6 RESET PMON METHOD (CHOICES: LOCK, OS, RDBMS)
Note 2069781.6 Basic Troubleshooting of the Concurrent Managers
Note 2120154.6 Unable to start the ccm after install - core dump
Note 171855.1 CCM.sql Diagnostic Script for Concurrent Manager
Note 185036.1 Unable to Startup or Shutdown the Concurrent Managers in 11.5.5 by Using the Syntax adcmctl.sh apps/<psswd> Start or Stop
Installation and Configuration using AutoConfig
Oracle E-Business Suite Release 11i with 9i RAC
Installation & Configuration Using AutoConfig
________________________________________
This document describe the steps required to install and setup an Oracle Applications Release 11i (11.5.10) environment with Oracle database 9i Release 2 (9.2.0.8) Real Application Cluster (RAC).
This document is divided into the following sections:
Section 1: Overview
Section 2: Environment
Section 3: Pre-requisites For RAC conversion.
Section 4: Installation/Configuration
Section 5: References
For complete information on the above sections click on the link below:
http://docs.google.com/Doc?id=dhs3fvh6_29fp7pz4
How to Implement Printing for Oracle Applications: Getting Started
The information in this article applies to:
Oracle Application Object Library - Version: 11.5.1 to 11.5.10
This problem can occur on any platform.
Printing, PASTA, SRW, Driver
Goal
How to get started on installing a printer(s) for Oracle Applications? What are the general steps for installing a printer?
Fix
I. PRINTER
The Oracle Applications printer name must be the same printer name that works at the Operating System (OS) command line on the server where the concurrent processing server resides. If files in Postscript format will be generated and printed from Oracle Applications, make sure to setup a raw OS print queue so that Postscript files will be passed to the target printer without any filtering or actions by the OS print queue or print command.
Any printer that can be controlled with embedded printer commands, such as
PCL, or supports the Postscript language can be used with Oracle Applications, see Note 353071.1 "Where Can I Find A List Of Supported Printers For Oracle Applications?"
II. PRINTER TYPE
A printer type lists which styles and drivers are available to the assigned printer.
Group printers according to make or family model and utilize a unique printer type name. All printers are not the same or possess the same capabilities and functions. Using only one printer type such as the "HPLJ4SI" type, with one set of printer drivers, to support all make and model of printers may not allow for fine adjustments to one particular printer or a group of printers. That is to say, a change or fine adjustment intended for a specific printer may adversely affect all printers on the instance using the same printer type or driver.
III. PRINT STYLE
A print style specifies the layout of the report’s output file. It is also matched with a driver that supports the same layout for printing.
In a full installation of Oracle Applications there are some 7,500 registered programs, of which 2,800 programs are defined as Oracle Reports. Approximately 70% of these Oracle Reports programs are designed as landscape reports--portrait and landwide are the next two widely used styles.
Therefore, setup the three most widely used styles (landscape, portrait, and landwide) for all printers and do not attempt to make corrections to the associated drivers on a "report by report" basis. Individual reports that do not work well with the three main print styles and printer drivers may need a special or custom style / driver to print correctly. Custom reports will typically require a custom print style or driver, see Note 357941.1 "Applications Product Support Guidelines Regarding Custom Reports and Programs"
Hint: For ease and convenience in release 11i, rather than creating new styles, use the existing styles “as is” or modify them as needed. The bulk of the printing instructions are contained in the printer driver and the SRW driver; therefore, the same print style can normally be re-used with several different printers and printer types.
IV. PRINT DRIVER
A printer driver provides the needed commands to initialize a printer and to invoke an OS print command or a print program or routine.
Oracle Applications provides a simple beginning set of printer drivers. These generic or plain drivers are working examples intended for the printer make or model stated in driver name and description. They may or may not work optimally with other printers. Oracle does not provide additional deliverable examples; therefore, outside of this set, a custom printer driver needs to be defined.
An initialization and reset string is needed to define a printer driver in Oracle Applications. The initialization string, also known as a "setup string", is printer dependent information. It instructs the printer on which printing characteristics are needed for the document to be printed. The printer’s vendor typically supplies the initialization string or provides information on how to construct printer-controlling commands.
Typically a simple initialization string can be found in the printer's user guide or technical reference manual. The back of the manual should have a section on supported printer command languages and/or commonly used printer commands and control characters, see Note 152285.1 "Building a Printer Initialization String for Oracle"
The best setup method is to create an initialization string using the printer command language utilized by your printer. An alternate setup method is to test existing printer drivers for compatibility with your printer. Unfortunately, the latter choice is a "trial and error" approach that may or may not achieve the desired printing appearance. For precision printing, like checks or pre-printed forms, the initialization string will likely require fine tuning, see Note 106186.1 "How to Test an Initialization String Outside of Oracle Applications".
V. SETUP STEPS
Existing printer types, styles, and drivers can be modified or a new record can be created. Adding a new record is the preferred approach. The printer type, styles, or drivers can have any name that best describe it usage. Additionally, it is more secured during upgrades than modifying seeded records; that is, Oracle seeded records can be overwritten by a patch or an upgrade process.
Concisely, the steps required to defined a printer for Oracle Applications are as follows:
1. Setup and verify the operation of the printer and print queue at the operating system level--test from the OS command line prompt.
2. Identify, select, or define a new Apps printer drivers that will support the specified printer make or model.
3. Identify, select, or define a new Apps printer type to register all needed printer styles and drivers.
4. Register an Apps printer name and associate an Apps printer type to the newly registered printer name.
For detailed setup instructions, please review the chapter titled "Printers" in the Oracle Applications System Administrator's Guide. Also see Note 123140.1 "How to Setup Printer for Oracle Applications 10.7 - 11.5.x" and Note 112172.1 "Oracle Applications Character Printing"
NOTE 1: Please keep in mind that Apps printer driver information is cached in memory, the concurrent manager will need to be bounced in order to make any recent changes take effect.
The following Notes may be helpful with common setup problems and oversights:
Note 262796.1 "Standard Reports Just Print the First Row or Double Space"
Note 359716.1 "Apps Reports Generate and/or Print With Incorrect Page Break Points"
Note 352384.1 "Reprint Does Not Correctly Print When The Original Request Is Formatted By Noprint"
Note 189708.1 "Oracle Reports 6i Setup Guide for Oracle Applications 11i"
VI. PASTA
Oracle Applications has a printing tool called PASTA that can help Administrator quickly configure a Postscript ready printer. Although Pasta is optional for most installations, it required for multilingual installations and installations using the Unicode / UFT8 character set, see Note 356501.1 "How to Setup Pasta Quickly and Effectively"
PASTA is the only viable solution when dealing with multiple languages and multiple printers in a UTF8 character set environment. Otherwise, an extensive amount of time will be spent identifying which fonts are supported by a particular symbol set and which symbol set matches up well with the Unicode super set. "Most printers can not handle UTF8 encoded data". As per the Printing chapter in the Oracle Applications System Administrator's Guide, "In order to print reports with the UFT8 character set, you 'must' configure PASTA".
Please reference the following notes for more information on PASTA:
Note 420019.1 - Pasta Overview
Note 356501.1 - How to Setup Pasta Quickly and Effectively
Note 239196.1 "PASTA 3.0 Release Information"
Note 240864.1 "Activating and Configuring IX Library"
Presently, the latest available PASTA patches:Patch 3325651 PASTA 3.0.4 RELEASE
References
Note 356501.1 - How to Setup Pasta Quickly and Effectively
Note 152285.1 - Building a Printer Initialization String for Oracle Applications
Note 106186.1 - How to Test an Initialization String Outside of Oracle Applications
Note 123140.1 - How to Setup Printer for Oracle Applications 10.7 - 11.5.x Quick Reference
________________________________________
Performance Tuning Overview in Oracle Apps 11i
If performance issue is with entire application questions you should have in mind :
Is your applications sized properly ?
Is initialization parameters set up correctly ?
Are there any runaway processes in oracle database tier or application tier ?
Is network connectivity between users & application server is fine , there is no delays ?
Latest techstack including jdbc drivers, forms, database, jdk can improve performance considerably Check if system level trace is enabled ?
Is Purge schedule ?
Is gather stats scheduled ?
If Issue is with only particular type of reports Check if there are no performance bugs with that module ?
Are you on latest patchset for that product ?
Is it standard report or custom ? (If custom enable trace & use tkprof, If standard then check in metalink if there is any issues reported by others)If Issue is only during particular time lets say during night Check what's running during that time .
Is it because of backups ?
Is it because all resource intensive requests running in night ?
If Issue is with specific users Check if trace is enabled at user level ?
Is user client machine performing well ?
Is connectivity from client machine to server fine ?
This is just overview or starting point to check Performance Issues in Oracle applications11i for Tuning Individual component like , Apache, JVM, Concurrent manager.
One of the common questions asked is how to schedule Gather Stats or How to schedule Purge ConcurrentProgram or Obsolete workflow data?
These are concurrent requests & if you have "System Administrator Responsibility" login with that ,then go to
Request -> View -> Select "Specific Request" and under "Name"
TextSearch for following requestsGather Schema Statistics ( supply parameter schema name , apps & others)Purge Concurrent Request and/or Manager Data ( supply retention period usually 90 days)Purge Signon Audit dataPurge Obsolete Workflow Runtime DataPurge Obsolete Generic File Manager Data.
If you want to understand How to proceed with Oracle Applications 11i tuning check Metalink Note 69565.1 .
How to apply apps patch using adpatch
Now you know basics of apps patch like type of patches & options available with patching, lets learn how to apply patches in oracle applications 11i .
Two broad ways to apply patch interactive & noninteractive(You will supply required parameters on command line & patch will apply without asking you any questions as you have already provided answers)
You being new to apps patching will prefer to interactive way of patching , let adpatch throw series of questions & you answer each of these .If you want to use any option with adpatch enter adpatch with options= seprated by comma (If you don't supply any options it will take default value set for that particular option like compiledb & compilejsp)You have to issue adpatch from application user (User you entered as applications/middle tier user usually applmgr if you insatlled using oracle standard documentation like )
adpatch options=nocompiledb,nocompilejsp Based on you AD verison it will ask you questions like with some suggested value
'/u01/applmgr/VIS11I/appl'Is this the correct APPL_TOP [Yes] Log file name & location....
Once patch is applied you might be interested in checking log files
If patch fails then you have to use utility adctrl to check for which worker it failed & check corresponding worker log file to see error message.
For more information on patches & patch basics follow metalink note # 181665.1
Difference between Oracle Apps 11i and R12
.Database: Database Version in 11i (11.5.9 & 11.5.10) was 9i Rel 2 where as in Release 12 its 10g R2 (10.2.0.2)
Application Tier: Tech Stack in Application Tier consist of iAS(1.0.2.2.2) & Developer 6i (Forms & Reports 8.0.6) but in Applications R12 it is build on Fusion Middleware (10g Web Server and 10g Forms & Reports)
Sub component in Application Tier:
A) HTTP Server or Web Server in R12 is Version 10.1.3 which is built on Apache version 1.3.34. In apps 11i it is Version 1.0.2.2.2 built on Apache Version 1.3.19
B) Jserv in apps 11i is replaced by OC4J (mod_jserv is replaced by mod_oc4j)
C) Forms Version 6i in Apps 11i is replaced by Forms 10.1.2.0.2 in R12
D) Reports Version 6i in Apps 11i is replaced by Reports 10.1.2.0.2 in R12
E) JDBC version is changed from version 9 in apps 11i to version 10.2.0 in Apps R12
F) modplsql or mod_pls is removed from Apps R12 (What will happen to my mod plsql applications- coming soon* )
G) Java processes use JDK/JRE version 1.5.0 in R12 against JDK version 1.3.1 or 1.4.2 in Apps 11i
H) For various environment variable changes check below picture

I) New top INSTANCE_TOP added in Release 12 for configuration and log files

How many patches makes an upgrade?
Rollup patches, one-off's etc would just be considered patching.
As for your other questions:
1) There is no set schedule for Family/Maintenance packs. At least there has not been in the past, with the only exception being HR/Payroll since it is required every year. I don't know what the plan is for R12.For 11i, I really wouldn't expect many more Family Packs, and there's definitely no more Maintenance Packs. 11.5.10.2 is it.
2) In the case of Maintenance Packs, the entire thing has been extensively tested by Oracle as one unit. With random Family Packs, if you put two of them on your system, there's no guarantee that they have been extensively tested together. Individually they would have been through that testing.
Tuesday, July 17, 2007
Clone Apps 11i Instance
Another important & useful utility under AD_TOP which Apps dba perform quite often isCloning Oracle Application 11i Instance.
Cloning is process of creating replica of your source apps 11i Instance ( lets say you have one apps Instance with name DEVELOPMENT and you want to create similar instance ( including same patches & user data) like DEVPRD then you will use adclone utility (Also called as Rapid Clone these days). In this case source Instance will be DEVELOPMENT and target Instance will be DEVPRD. There are lot for scenario in which you wish to clone your E-Business Suite 11i Instance , like you want to Test if everything is OK in Test & then after testing want to create Production instance or you want to move your Instance from one machine to other machine or if you are highly experienced Apps DBA you can use clone as staged environment during Upgrade to reduce downtime ( this concept is called as staged appl_top or staged patching/upgrade , p.s. this is different from shared APPL_TOP)
So here are some broad level steps you can use to clone apps instance .
Step1 . Prerequisites Steps you do before start cloning using rapid clone
a)Verify source and target nodes software versions
b)Apply the latest AutoConfig Template patch
c) Apply the latest Rapid Clone patches
Step2 . Clone Source to Target
a) Run preclone on DB tier
b) Run preclone on Apps or middle tier
c) Copy source file system to target file system
d)Configure db tier
e) Configure apps/middle tier
Step 3 Finishing Task
a) Update profile options
b) Update printer settings (If printers are not configured or you don't want to use printer you can skip this step)
c) Update workflow configuration settings (Important)
For more detailed steps check Metalink Note # 230672.1
Don't forget to leave me a comment about what you want to hear & any confusion if you have in apps 11i.
Startup Shutdown Apps Services Startup / Shutdown Apps
As you are aware by now there is Database Tier ( Database & DB Listener ) and Application Tier ( WebServer, Forms, Reports, Concurrent Manager, Discoverer, Apps Listener, OnetoOne Fullfillment Server )
Order of StartUp of Services Should be --> First DB Listener, Database & then Application Tier Services
Order of ShutDown of Services Should be--> First Application Tier Services then Database & DB Listener
Database Startup/Shutdown Scripts
AD --> is for Application
-----Application Tier Startup/Shutdown Scripts
OAD_TOP/admin/scripts/ SID_hostname
adalnctl.sh --> Apps Listener Control Script
Apps Architecture
This Topic is quite important and I recommend you to go through this thoroughly.
First get to know the terminology which you will encounter in the wonderful world of Oracle.
Server - is a process or group of processes and provides a particular functionality/service .For example, Database Server listen and process database requests, similarly Web Server listens for and processes HTTP requests.
Tier - is a logical grouping of services, may be on single machine or spread across more than one physical machine.For Example, Middle Tier in Oracle apps consist Form,Web,Report...Services. Forms & Report can be one machine 1 & Web Server can be on machine 2, still they will be part of same tier called as Application Tier or Middle Tier.
Node - is referred as Machine, Each tier may consist of one or more node and each node can potentially have more than one tier.
Desktop Tier - Oracle Applications/E-Business Suite is built on three tier Architecture with first Desktop Tier ic client machines accessing applications via browser(HTML based Self service applications) or Java Applet(Jinitiator) for Form based interface.
Application/Middle Tier - Second is Application Tier also called as middle tier consists of WebServer Forms, Reports, Concurrent processing, Discoverer and Admin Server. I suppose its known as Middle tier because it lies between our desktop & third tier called database tier.
Database Tier - Third is Database Tier contain Orale database server which store all your application data. I am sure if you are DBA you know it :)
Oracle Apps Patch Basics
Lot of you asked me about patch basics & even I was confused with Apps Patches terminology initially as I used to hear family pack, mink pack, maintenance pack, patchset, security patch and lot many other type of patches so I thought of introducing you with patching terminology & to Oracle terminology that impresses and confuses people like you & me.
OK lets now start with patch basics / terminology Standalone/Oneoff patches :
This is used to define patch created to fix single/particular problem.Mini Pack : This is group of oneoff patches for a particular product like INV, GL, AP and named like 11i.GL.E ( means this group of patches contain fix for 11i GL product (General Ledger till time E is released ) This is cummutative which means it will include 11i.GL.A, 11i.GL.B ....11iGL.D till 11i.GL.E earlier in 10.7 it used to called as patchset.
Family Pack : Group of mini packs in one family buldeled together is called as family pack. they are usually named as 11i_PF. Few example of falilies are SCM ( 11i.SCM_PF.G ), ATG ( 11i.ATG_PF.H ) _PF indicate Product Family Pack
Maintenance Pack : Group of family pack together is called as maintenance pack. So if you say your Verison is 11.5.10 then its maintenance pack 10 ( 3rd digit is maintenance pack ) so
To wind up things you can say few one off patch make mini pack , few mini pack related to same family bundeled together as family pack & all family pack fixed till that time are bundeled in Maintenance pack .
NLS Patch ( When you have more than one language , like english & arabic or french .. ) then apart from normal patch you have to apply patch for specific language Installed in your system called as NLS patch .
Let me know ...if you need more details. I can find out and post here as I am not a DBA.
Thursday, July 12, 2007
Welcome to ORACLE E - Business Suite
Oracle E-Business Suite is a fully integrated, comprehensive suite of business applications for the enterprise. Whether you implement one module at a time, multiple modules, or the complete suite — Oracle E-Business Suite provides better business information for effective decision-making and enables an adaptive enterprise for optimal responsiveness.
Human Resources Management System
The Oracle E-Business Suite Human Resources Management System family of applications automates the entire recruit-to-retire process, so you can align your workforce with strategic objectives. A single integrated data model provides an up-to-the-instant accurate view of human resources-related activities, including recruiting, performance management, learning, compensation, benefits, payroll, time management, and real time analytics.
Seamless Integration, Complete Flexibility Oracle Human Resources Management System is part of the Oracle E-Business Suite, integrating with other E-Business Suite applications, including Financials and Projects. Implement one or several application families — or implement the complete Oracle E-Business Suite for the fastest way to high-quality enterprise information.
Achieve Workforce Excellence With people-related costs averaging over 60% of total corporate expenditures, leading firms are paying increased attention to the contribution made by their workers and are developing a new model for HR. This model includes programs to improve the efficiency, effectiveness, and productivity of the workforce and the ability to manage locally or globally. To be fully effective, these programs require new processes supported by leading technologies. Oracle calls this new model Workforce Excellence and believes it is the ultimate goal of HR, regardless of company size, industry segment, or geography. The model is composed of four main phases: comply, automate, measure, and align.
Oracle E-Business Suite HRMS 12 Available now, Oracle E-Business Suite Human Resources Management System 12 includes key enhancements such as global transfers, checklists, and an uplifted user interface including more efficient flows for absence and salary administration.
1.Advanced Benefits
2.Daily Business Intelligence for HR
3.Human Resources
4.iRecruitment
5.Learning Management
6.Payroll
7.Self Service HR
8.Time and Labor
9.Tutor
10.Workforce Scheduling