Tweet
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…
All checks are done using aoljtest.jsp. The app front end connects to database suing $INST_TOP/fnd/secure/DBC- Database connector file
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.
[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…
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…
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.
http://metalink.oracle.com
Using Patches -> simple search with following details
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.
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.
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.
| 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 |
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 |
| 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 |
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.
The following is a brief Guideline on steps to follow to clone you Oracle Applications from PROD to TEST
Read more…
– Server A – Is a Live Server
– Server B – Is a Physical Standby Server
Both were configured for a data guard
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.
