Change EBS Apps Ports

Posted by Sagar Patil

If concurrent ma nagers are running then see the process using ps- ef | grep FND : Normally can take upto 5 minutes to kill all processes so be patient.

To abort all procsses = kill -9 `ps -ef | grep FND | awk `{print $2}’`

Status of each concurrent requests are hosted at FND_Concurrent_requests & Fnd_concurrent_queues. Running is R and complegted is set as C in this tables. Read more…

Healthcheck of EBS Components Using AOL

Posted by Sagar Patil

All checks are done using aoljtest.jsp. The app front end connects to database suing $INST_TOP/fnd/secure/DBC- Database connector file

Read more…

An experience with Oracle EBS Patching :Upgrade from 12.0.2 -> 12.0.4

Posted by Sagar Patil

Hierarchy : One off Patch -> Mini pack -> Family pack & Finally Maintenance Pack

Maintenance pack : Upgrade from one version to another . 12.0.2 -> 12.0.4

Family pack – Fixing the functional modules.FIN.B – Latest family pack for release 12 . FIN is financial B where B denotes the version -. For 11i HRPF.K – K is level of Module.

One off – One off issue

Mini Pack : Small functionality

Enhance functionality like VAT change. – One off else MINI pack. Apps patch is done by adpatch utility. Also look into readme file. “adpatch” is like opatch so can be copied from CD.

Read more…

How to bounce & Debug Apache /Forms : Log files

Posted by Sagar Patil

[applmgr@ebs scripts]$ pwd
/oracle/u01/VIS/inst/apps/VIS_ebs/admin/scripts

[applmgr@ebs scripts]$ adapcctl.sh stop

You are running adapcctl.sh version 120.6.12000000.2

Stopping OPMN managed Oracle HTTP Server (OHS) instance …

adapcctl.sh: exiting with status 0

adapcctl.sh: check the logfile /oracle/u01/VIS/inst/apps/VIS_ebs/logs/appl/admin/log/adapcctl.txt for more information …

[applmgr@ebs scripts]$ adapcctl.sh status

You are running adapcctl.sh version 120.6.12000000.2 Read more…

Using adadmin to compile an Apps environment

Posted by Sagar Patil

While installing apps 12 under OEL 5, I came across a problem and one of the suggestion made was to relink/compile an apps setup to see if that resolves the problem…

Read more…

Disk Space Required for EBS 11i & 12

Posted by Sagar Patil

Release 12  Disk Space Required

Read more…

Multi Node to Single Node Cloning

Posted by Sagar Patil

With Oracle Applications 11.5.10 the ability to clone from a multi node to a single node system using rapid clone has now been certified.

Read more…

Best way to check patches on Metalink

Posted by Sagar Patil

http://metalink.oracle.com
Using Patches -> simple search with following details

Read more…

How to deploy form on server

Posted by Sagar Patil

Generally, in Oracle Applications

- All *.fmb located at $AU_TOP/forms/US

- All *.fmx will be located at their respective Product top’s/forms/US.

Read more…

Introduction to Oracle Payables : Concepts

Posted by Sagar Patil

Payables Workbenches
Oracle Payables includes two fully integrated workbenches, the Invoice Workbench and the Payment Workbench. You can perform most of your transactions in Payables using the Invoice Workbench or the Payment Workbench. You enter, adjust, and review invoices and invoice batches in the Invoice Workbench. You create, adjust, and review payments and payment batches in the Payments Workbench.
Payables workbenches let you find critical information in a flexible way. For example, in the Invoice Workbench, you can find an invoice based on supplier, purchase order number, status, or other criteria. Then, for that invoice, you can review distributions, scheduled payments, payments, holds, and other detailed invoice information. You can also perform matching, submit invoice validation, apply and release holds, or initiate payment. You can query an invoice then perform several transactions without having to find the invoice again. You can also keep multiple windows open at one time.

Read more…

Oracle HRMS Overview : Concepts

Posted by Sagar Patil

Product Overview
Oracle Applications for Human Resources enable an organization to hire, train, and deploy, assess, motivate and reward its people more effectively than ever before, turning HR into a strategic-level function and key contributor to an organization’s success. By automating its administrative duties, providing self-service for non-HR professionals, and managing information more efficiently, HR professionals can devote their energy and creativity to delivering the maximum value for the organization’s investment in people.

Read more…

AD and Other Utilities

Posted by Sagar Patil
Utility Execution command Action Performed
AD Administration Adadmin Driver program that performs maintenance tasks on the apps layer and within the database.
Auto Patch Adpatch Applies patches in several modes. Can also be used to add new languages and products.
Auto Upgrade Adaimgr Upgrades to the latest version of Oracle E-Business Suite.
Rapid Install AD Controller Adctrl Allows for the monitoring of status of workers spawned by Auto Upgrade, AD Admin, or Auto Patch and allows for the restarting of failed tasks.
FNDLOAD AD File Identification Adident Identifies version and translation level of one or more Apps files. Similar to Grep.
AD Splicer Adsplice Registers off cycle products.
File Character Set Converter Adncnv Converts text files from one character set to another.
AD Configuration Adutconf.sql Access standard information about the installed configuration of the Apps layer.
Auto Configuration Adautocfg AutoConfig. Provides central help to manage various configuration files.
AD Relink Adrelink Relinks executable programs with server libraries.
AD Merge Patch Admrgpch Merges several patches into single integrated patch without guaranteeing to take into account dependencies.
License Manager Adlicmgr.sh Licenses products, country specific functionalities, or languages.
AD Java Clone Utility Adclone

Read more…

How to start database and Apps

Posted by Sagar Patil

(Release 12)

Login as database user
cd $ORACLE_HOME/appsutil/scripts/<SID_hostname>

Read more…

Oracle RDBMS Release Nomenclature

Posted by Sagar Patil

Before 9i

8 RDBMS Version Number
1 New Features Release Number
5 Maintenance  Release Number
1 Generic Patch Set Number
2 Platform Patch Set Number

Read more…

E Business Suite Release 10.7/11.0.x/11i.5.x/12 Component Details

Posted by Sagar Patil
Release Info List of Products RDBMS Version Middle Tier  Details
10.7
Client/Server
Nearly 40 Products RDMS 7.3.4.x Application Server 3.2.0 Forms 2.5/4.5
Reports 2.5
NO Java
11.0.x
Client/Server
Nearly 50 Products RDBMS 8.0.5.0 Application Server 3.0.2 Forms 2.5/4.5
Reports 2.5
NO Java
11.5.1/11.5.2
3 Tier
RDMS 8.1.6, Oracle Home Software Directory Webservers
WebDB 2.2/2.5
Jserv1.1
JRE1.1.8
JDK 1.1.8
Forms 6i (6.0.8.x)
Reports 6i(6.0.8.x)Workflow 2.5
Jinitiator 1.1.7.27
11.5.3
3 Tier
RDMS 8.1.6
Oracle Software Directory 8.0.6
9iAS 1.0.2.1
Webservers
WebDB 2.2/2.5
Jserv1.1
JRE1.1.8
JDK 1.1.8
Forms 6i (6.0.8.8.0)
Reports 6i(6.0.8.8.0)Workflow 2.5
Jinitiator 1.1.7.27
11.5.4
3 Tier
RDMS 8.1.7.1
Oracle Software Directory 8.0.6
9iAS 1.0.2.1
Apache 1.3.9 (iAS) JSP
Jserv1.1
JRE1.1.8
JDK 1.2.2/1.3
Forms 6i (6.0.8.12.1)
Reports 6i(6.0.8.12.1)Workflow 2.5
Jinitiator 1.1.8.7
Self Service Framework 5.2.3C
11.5.5
3 Tier
Nearly 161 Products RDMS 8.1.7.1
Oracle Software Directory 8.0.6
9iAS 1.0.2.1
Apache 1.3.9 (iAS) JSP
Jserv1.1
JRE1.1.8
JDK 1.3
Forms 6i (6.0.8.14.2)
Reports 6i(6.0.8.14.2)Workflow 2.5
Jinitiator 1.1.8.13
Self Service Framework 5.2.3C
11.5.6
3 Tier
Nearly 175 Products As Above As Above As Above As Above
11.5.7
3 Tier
Nearly 179 Products RDMS 8.1.7.3
Oracle Software Directory 8.0.6.3
9iAS 1.0.2.2.2
Apache 1.3.19 (iAS) JSP
Jserv1.1
JRE1.1.8
JDK 1.3
Forms 6i (6.0.8.18.2)
Reports 6i(6.0.8.18.2)
Discoverer 4.4.41
Oracle Graphics 6.0.8.18
Oracle Portal 3.0.9.8.1
Workflow 2.6
Jinitiator 1.1.8.16
Self Service Framework 5.2.2.E
11.5.8
3 Tier
Nearly 191 Products RDMS 8.1.7.4
Oracle Software Directory 8.0.6.3
9iAS 1.0.2.2.2
Apache 1.3.19 (iAS) JSP
Jserv1.1
JRE1.1.8
JDK 1.3.1_02
Forms 6i (6.0.8.18.2)
Reports 6i(6.0.8.18.2)
Discoverer 4.4.41
Oracle Graphics 6.0.8.18
Oracle Portal 3.0.9.8.1
Workflow 2.6
Jinitiator 1.1.8.16
Self Service Framework 5.2.2.E
11.5.9
3 Tier
Nearly 197 Products RDMS 9.2.0.3
Oracle Software Directory 8.0.6.3
9iAS 1.0.2.2.2
Apache 1.3.19 (iAS) JSP
Jserv1.1
JRE1.1.8
JDK 1.3.1_02
Forms 6i (6.0.8.21)
Reports 6i(6.0.8.21)
Discoverer 4.4.46
Oracle Graphics 6.0.8.18
Oracle Portal 3.0.9.8.4
Workflow 2.6.2+
Jinitiator 1.1.8.16
Self Service Framework 5.7H
11.5.10
3 Tier
RDMS 9i Rel 2
Oracle Software Directory 8.0.6.3
9iAS 1.0.2.2.2
HTTP /Web Server Version 1.0.2.2.2 built on Apache Version 1.3.19
JSP
Jserv1.1
JRE 1.3.1 or 1.4.2
JDK 1.3.1 or 1.4.2
JDBC 9
Forms Version 6i
Reports Version 6i
Release 12
3 Tier
RDMS 10g R2 (10.2.0.2)
Applications R12 it is build on Fusion Middleware 9iAS (1.0.2.2.2)
HTTP /Web Server 10.1.3 built on Apache version 1.3.34
Jserv is replaced by OC4J
mod_jserv is replaced by mod_oc4j
JDBC 10.2.0
JDK 1.5.0
JRE 1.5.0
Forms 10.1.2.0.2
Reports 10.1.2.0.2

Read more…

Monitoring Oracle E-Business Suite.

Posted by Sagar Patil
  1. Database monitoring
  2. Apache monitoring
  3. Forms monitoring
  4. Concurrent Manager monitoring
  5. Server monitoring
  6. Network monitoring
  7. Additional monitoring and troubleshooting

Read more…

How do users interact with Oracle Applications – Part 2

Posted by Sagar Patil

Oracle Applications is installed on the servers of a company and every user from the CEO down to a factory staff is given a user name and password. They use their browsers to connect to the servers in their LAN and typically get a menu called responsibilities to choose from. Once they choose their responsibility, accordingly they get another menu of functions they can perform. For example if it is a Purchasing user, he may be able to create RFQs (Request for quotations), Purchase Requisitions, Purchase Orders, Receive material etc. Hence whatever that is happening at the factory ground needs to be entered in a particular form in APPS. If something is not right, APPS will not allow the process to flow further. Hence mistakes will be arrested at each step. Besides there are dozens of reports in a variety of formats for Business Intelligence and better understanding of what is actually happening for the decision makers.
So now, you understand how Oracle apps is used, but how is it structured?
The following image represents the directory structure of APPS.

Read more…

Steps to clone Oracle Applications database from PROD to TEST

Posted by Sagar Patil

The following is a brief Guideline on steps to follow to clone you Oracle Applications from PROD to TEST
Read more…

Installing Oracle Applications R11.5.10.2 Under Windows

Posted by Sagar Patil

How to Recover Standby from Primary Database

Posted by Sagar Patil

– Server A – Is a Live Server
– Server B – Is a Physical Standby Server
Both were configured for a data guard

Read more…

Creating Data Guard Primary/Standby on 2 Windows Servers

Posted by Sagar Patil

Oracle Data Guard is the management, monitoring, and automation software infrastructure that creates, maintains, and monitors one or more standby databases to protect enterprise data from failures, disasters, errors, and corruptions.

Read more…

Top of Page

Top menu