About the Authors |
|
xxi | |
About the Technical Reviewer |
|
xxiii | |
Acknowledgments |
|
xxv | |
Introduction |
|
xxvii | |
Chapter 1 Architecture |
|
1 | (34) |
|
Introduction to Oracle E-Business Suite |
|
|
1 | (1) |
|
|
2 | (1) |
|
Service Management Family |
|
|
2 | (1) |
|
Financial Management Family |
|
|
3 | (1) |
|
Human Capital Management Family |
|
|
4 | (1) |
|
Project Portfolio Management Family |
|
|
5 | (1) |
|
Advanced Procurement Family |
|
|
5 | (1) |
|
Supply Chain Management Family |
|
|
6 | (1) |
|
Understanding the Oracle E-Business Suite's Three-Tier Architecture Model |
|
|
7 | (4) |
|
|
11 | (1) |
|
Database Tier and EBS Data Model |
|
|
11 | (4) |
|
Understanding the EBS 12.2 Technology Stack Components |
|
|
15 | (4) |
|
Oracle EBS 12.2 File System Structure |
|
|
19 | (4) |
|
Application Tier File System |
|
|
23 | (9) |
|
Technology Stack Changes in EBS 11i/12.1/12.2 |
|
|
32 | (2) |
|
|
34 | (1) |
Chapter 2 Installation and Configuration |
|
35 | (68) |
|
New Features in Release 12.2's Rapidwiz Install Wizard |
|
|
35 | (2) |
|
Preparing for Installation |
|
|
37 | (5) |
|
|
37 | (1) |
|
|
38 | (1) |
|
|
38 | (1) |
|
|
39 | (1) |
|
Software Tools Requirements |
|
|
39 | (1) |
|
|
39 | (1) |
|
Operating System Packages |
|
|
40 | (2) |
|
Configuring the yum Repository for EBS 12 Package Installation |
|
|
42 | (7) |
|
Get the Repository File with Wget |
|
|
42 | (7) |
|
Oracle EBS 12.2 Stage Directory Structure |
|
|
49 | (5) |
|
|
51 | (2) |
|
Copy Patches to Existing Stage Area |
|
|
53 | (1) |
|
List Files in the TechPatches Directory |
|
|
53 | (1) |
|
Copy Patches to Existing Stage Area |
|
|
54 | (1) |
|
|
54 | (19) |
|
|
54 | (19) |
|
|
73 | (3) |
|
Key Points Related to Multinode Installation |
|
|
74 | (1) |
|
Rapidwiz Install: RAC Database Option |
|
|
74 | (1) |
|
Shared APPL_TOP in Oracle EBS 12.2 |
|
|
75 | (1) |
|
|
76 | (5) |
|
Post-installation Steps for the Application |
|
|
76 | (3) |
|
|
79 | (1) |
|
Post-installation Steps for the Database |
|
|
80 | (1) |
|
How to Deal with Failed Installations |
|
|
81 | (2) |
|
Rapidwiz Installation Process |
|
|
81 | (2) |
|
How to Deal with Corrupted/Lost Technology Stack Components |
|
|
83 | (19) |
|
Replacing the Oracle EBS Database Technology Stack (RDBMS Oracle Home) |
|
|
83 | (9) |
|
Replacing the Oracle EBS lOg AS (10.1.2: Tools) Technology Stack |
|
|
92 | (10) |
|
Replacing the Oracle Fusion Middleware Technology Stack |
|
|
102 | (1) |
|
|
102 | (1) |
Chapter 3 Oracle E-Business Suite Upgrades |
|
103 | (52) |
|
Introduction to the Oracle E-Business Suite Upgrade Process |
|
|
103 | (1) |
|
|
103 | (2) |
|
Preparation of an Oracle EBS 12.2 Upgrade |
|
|
105 | (3) |
|
Operating System and Server Upgrade |
|
|
105 | (1) |
|
Virtualization Considerations |
|
|
105 | (1) |
|
Space and Computing Capacity Considerations |
|
|
106 | (1) |
|
|
106 | (1) |
|
|
107 | (1) |
|
Upgrade Dependent EBS Integrated Applications |
|
|
107 | (1) |
|
Upgrading Oracle E-Business Suite: 12.2.0 to 12.2.5 |
|
|
108 | (18) |
|
Patching Utilities Used for Different Tech Stack Components |
|
|
110 | (1) |
|
|
110 | (1) |
|
Execution of checkMTpatch.sh |
|
|
110 | (3) |
|
Execution of checkDBpatch.sh |
|
|
113 | (2) |
|
Installation of the RDBMS Patches |
|
|
115 | (5) |
|
Applying Latest AD and TI0( Patches |
|
|
120 | (1) |
|
|
121 | (1) |
|
Installation of 12.2.5 Upgrade Patch |
|
|
121 | (3) |
|
|
124 | (2) |
|
Upgrading from 12.1.3 to 12.2.0 |
|
|
126 | (1) |
|
|
126 | (1) |
|
|
126 | (1) |
|
|
126 | (1) |
|
|
126 | (1) |
|
Upgrade Environment Details |
|
|
127 | (27) |
|
Oracle EBS Database Upgrade |
|
|
128 | (1) |
|
Oracle Application Upgrade |
|
|
129 | (1) |
|
Install 12.2.0 Tech Stack Components |
|
|
129 | (13) |
|
Prepare for 12.2.0 Upgrade Patch |
|
|
142 | (1) |
|
|
143 | (1) |
|
Configure the EBS Upgrade Using Rapidwiz |
|
|
144 | (6) |
|
|
150 | (1) |
|
|
151 | (2) |
|
|
153 | (1) |
|
EBS Upgrade Timing Summary |
|
|
153 | (1) |
|
|
154 | (1) |
Chapter 4 Oracle E-Business Suite 12.2 File System |
|
155 | (44) |
|
Oracle E-Business Suite File System Architecture Overview |
|
|
155 | (2) |
|
Understanding the Application Dual and Noneditioned File Systems |
|
|
157 | (9) |
|
Oracle EBS 12.2 Environment Variables |
|
|
166 | (11) |
|
Working with Environment Variables on the Application Tier and Navigating the Application File System |
|
|
177 | (6) |
|
Scenario 1: Starting the Application Services |
|
|
177 | (3) |
|
Scenario 2: You Want to Check the SMTP Server Settings in CONTEXT_FILE |
|
|
180 | (1) |
|
Scenario 3: You Want to Connect to the EBS Database Remotely from the EBS Application Tier Node |
|
|
181 | (2) |
|
Working with Environment Variables on the Database Tier and Navigating the Database File System |
|
|
183 | (6) |
|
Scenario 1: Restarting the EBS Database and the Database Listener |
|
|
185 | (2) |
|
Scenario 2: Modifying the Database Configuration Using AutoConfig |
|
|
187 | (2) |
|
EBS 12.2 Applications Log Files |
|
|
189 | (2) |
|
EBS 12.2 Database Log Files |
|
|
191 | (7) |
|
|
198 | (1) |
Chapter 5 Patching Concepts |
|
199 | (46) |
|
Introduction to Oracle Patching in EBS 12.2 |
|
|
199 | (2) |
|
Types of the Patches and Deciding the Patching Order |
|
|
201 | (19) |
|
|
203 | (7) |
|
The Patch Application Assistant Method |
|
|
210 | (10) |
|
Different Patching Utilities Under Oracle EBS 12.2 |
|
|
220 | (1) |
|
Patching WebLogic with BSU (BEA Smart Update) |
|
|
221 | (2) |
|
Patching the Application Tier Oracle Homes and the Database with Opatch |
|
|
223 | (2) |
|
Applying the Applications Patches with the ADOP Utility |
|
|
225 | (1) |
|
Introduction to Online Patching Utility (adop) |
|
|
226 | (11) |
|
Technological Changes for Supporting Online Patching |
|
|
227 | (2) |
|
Understanding Edition-Based Redefinition Usage in Online Patching |
|
|
229 | (5) |
|
Phases of Online Patching |
|
|
234 | (3) |
|
Backup Best Practices for EBS 12.2 Patching |
|
|
237 | (7) |
|
|
244 | (1) |
Chapter 6 Working with the Applications DBA Online Patching Tool (adop) |
|
245 | (106) |
|
|
245 | (2) |
|
Working with the adop Utility |
|
|
247 | (5) |
|
adop Command-Line Parameters and Options |
|
|
252 | (10) |
|
Executing the Patching Cycle |
|
|
262 | (13) |
|
|
263 | (3) |
|
List of Restricted Functionalities in the Online Patching Cycle |
|
|
266 | (1) |
|
|
267 | (2) |
|
|
269 | (1) |
|
|
270 | (2) |
|
|
272 | (1) |
|
|
273 | (2) |
|
|
275 | (4) |
|
|
279 | (3) |
|
Merging Oracle Application Patches |
|
|
282 | (7) |
|
Applying Patches in a Multinode Environment |
|
|
289 | (9) |
|
Adding a New Language, Patching for NLS and HRMS |
|
|
298 | (18) |
|
|
316 | (8) |
|
Patch Reporting Utilities |
|
|
324 | (26) |
|
|
350 | (1) |
Chapter 7 Managing FMW/WebLogic |
|
351 | (90) |
|
Introduction to Fusion Middleware in EBS 12.2 |
|
|
351 | (1) |
|
Architecture and Components |
|
|
352 | (7) |
|
|
359 | (1) |
|
FMW Directory Structure in EBS 12.2 |
|
|
360 | (4) |
|
Controlling Admin Server, Node Manager, and Managed Servers |
|
|
364 | (7) |
|
Using the FMW Control and the WebLogic Console |
|
|
371 | (26) |
|
WLST and Its Typical Usages in EBS 12.2 |
|
|
397 | (4) |
|
Best Practices for Tuning Fusion Middleware in EBS 12.2 |
|
|
401 | (2) |
|
Best Practices for FMW Performance and Managing the Configuration of WebLogic Server in EBS 12.2 |
|
|
403 | (14) |
|
Managing the Configuration of Oracle HTTP Server |
|
|
417 | (4) |
|
|
421 | (19) |
|
|
440 | (1) |
Chapter 8 AutoConfig to Manage EBS System Configuration Changes |
|
441 | (42) |
|
Introduction to the AutoConfig Utility |
|
|
441 | (1) |
|
Understanding Configuration Management Tools and Utilities |
|
|
442 | (8) |
|
|
442 | (1) |
|
|
443 | (1) |
|
|
444 | (1) |
|
|
444 | (1) |
|
|
445 | (2) |
|
Working with the Context File |
|
|
447 | (3) |
|
Running AutoConfig in Preview Mode |
|
|
450 | (8) |
|
|
453 | (1) |
|
|
453 | (5) |
|
Running AutoConfig for Configuration Changes |
|
|
458 | (6) |
|
Executing AutoConfig on the Database Tier |
|
|
463 | (1) |
|
Rolling Back AutoConfig Configuration Changes |
|
|
464 | (1) |
|
Using AutoConfig for Managing Customizations |
|
|
465 | (3) |
|
Customizing Existing AutoConfig Template |
|
|
466 | (2) |
|
Advanced AutoConfig Features and Utilities |
|
|
468 | (6) |
|
AutoConfig Command-Line Options |
|
|
469 | (1) |
|
Using Profiling with AutoConfig |
|
|
469 | (3) |
|
Running AutoConfig in Parallel Mode in Multinode Environment |
|
|
472 | (1) |
|
adconfig Execution on dbTier with parallel Option |
|
|
472 | (1) |
|
adconfig Execution on appsTier with parallel Option |
|
|
473 | (1) |
|
AutoConfig and Fusion Middleware Home |
|
|
474 | (6) |
|
|
475 | (5) |
|
Adding Custom Top to EBS 12.2 |
|
|
480 | (1) |
|
|
481 | (2) |
Chapter 9 SYSADMIN Fundamentals |
|
483 | (48) |
|
Introduction to Application Technology Layer |
|
|
483 | (1) |
|
|
484 | (9) |
|
Using the adadmin Utility |
|
|
487 | (4) |
|
Generate Applications Files Menu |
|
|
491 | (1) |
|
Maintain Applications Files Menu |
|
|
491 | (1) |
|
Compile/Reload Applications Database Entities Menu |
|
|
492 | (1) |
|
Maintain Applications Database Entities Menu |
|
|
492 | (1) |
|
|
493 | (1) |
|
Using Application DBA Reporting Utilities |
|
|
493 | (2) |
|
adutconf.sql: Utility for Displaying Application Configuration |
|
|
493 | (1) |
|
adident: File Version Identification Utility |
|
|
494 | (1) |
|
|
494 | (1) |
|
Oracle Application Diagnostic |
|
|
495 | (7) |
|
Application Diagnostic Responsibility |
|
|
498 | (4) |
|
Working with the SYSADMIN Responsibility |
|
|
502 | (2) |
|
Alert Manager Responsibility |
|
|
504 | (4) |
|
|
507 | (1) |
|
Workflow Admin Responsibility |
|
|
508 | (4) |
|
|
508 | (1) |
|
|
509 | (1) |
|
|
510 | (1) |
|
|
511 | (1) |
|
Working with Oracle Applications Manager |
|
|
512 | (11) |
|
|
516 | (1) |
|
|
517 | (1) |
|
|
518 | (1) |
|
Workflow Mailer Configuration |
|
|
519 | (2) |
|
|
521 | (2) |
|
User, Role, and Responsibility Management |
|
|
523 | (2) |
|
Managing Profiles and Profile Levels |
|
|
525 | (1) |
|
|
526 | (4) |
|
|
528 | (2) |
|
|
530 | (1) |
Chapter 10 Oracle EBS Concurrent Managers |
|
531 | (48) |
|
Introduction to Oracle Concurrent Processing |
|
|
531 | (1) |
|
Understanding Terms Concurrent Requests, Program, and Processes |
|
|
531 | (1) |
|
Service Management Architecture |
|
|
532 | (1) |
|
How the Service Manager Works |
|
|
532 | (3) |
|
Different Types of Concurrent Managers |
|
|
535 | (2) |
|
Internal Concurrent Managers |
|
|
535 | (1) |
|
|
535 | (1) |
|
Conflict Resolution Manager |
|
|
535 | (1) |
|
|
535 | (2) |
|
Understanding Concurrent Request Phases |
|
|
537 | (1) |
|
Parent Request and Child Request |
|
|
537 | (2) |
|
Working with Concurrent Requests (Standard Requests, Custom Requests, and Request Arguments) |
|
|
539 | (1) |
|
Submitting a Standard Concurrent Request |
|
|
539 | (6) |
|
|
545 | (5) |
|
|
550 | (1) |
|
Working with Concurrent Request Sets |
|
|
551 | (8) |
|
Managing Concurrent Manager Incompatibilities |
|
|
559 | (3) |
|
Creation of Custom Concurrent Manager |
|
|
562 | (4) |
|
Working with the Specialization Rule and Work Shifts |
|
|
566 | (3) |
|
Understanding Parallel Concurrent Processing (PCP) |
|
|
569 | (1) |
|
Role of ICM in Parallel Concurrent Processing |
|
|
570 | (1) |
|
Role of Service Manager (FNDSM) in PCP |
|
|
571 | (1) |
|
Role of Internal Monitor Process (FNDIMON) in PCP |
|
|
571 | (1) |
|
Using the CLI for Submitting Concurrent Requests |
|
|
571 | (1) |
|
Troubleshooting Concurrent Manager Issues |
|
|
572 | (2) |
|
|
574 | (1) |
|
Concurrent Manager Process log File |
|
|
574 | (1) |
|
Internal Manager Log File |
|
|
575 | (1) |
|
Using Concurrent Manager Recover Wizard |
|
|
575 | (1) |
|
Problems with Printing Reports |
|
|
576 | (1) |
|
|
576 | (1) |
|
Important Concurrent Manager Tables |
|
|
577 | (1) |
|
|
577 | (2) |
Chapter 11 Cloning Oracle EBS Systems |
|
579 | (62) |
|
Introduction to OracleApplication Cloning and Its Purpose |
|
|
579 | (1) |
|
Using Rapid Clone and Its Options |
|
|
579 | (3) |
|
High-Level Clone Process with AD and TKX Delta6 |
|
|
580 | (1) |
|
High-Level Clone Process with AD and TKX Delta7 |
|
|
580 | (1) |
|
|
580 | (1) |
|
|
581 | (1) |
|
adpreclone.pl and adcfgclone.pl Options |
|
|
581 | (1) |
|
Prerequisites for a New Clone Environment |
|
|
582 | (2) |
|
Prepare the Clone Systems |
|
|
582 | (1) |
|
|
582 | (1) |
|
|
582 | (1) |
|
|
582 | (1) |
|
Oracle EBS Inventory Requirements |
|
|
583 | (1) |
|
Validate AutoConfig on the Source System |
|
|
583 | (1) |
|
Execute and Maintain Snapshot Information from adadmin |
|
|
583 | (1) |
|
Cloning from a Single Node to a Single Node |
|
|
584 | (16) |
|
Steps of Rapid Clone EBS 12.2 on the Source and Target Systems |
|
|
584 | (1) |
|
|
585 | (1) |
|
Prepare the Clone on the Source System |
|
|
586 | (1) |
|
Execute the Clone Preparation Script on the Database Tier (dbTier) |
|
|
586 | (1) |
|
Execute the Clone Preparation Script on the Application Tier (appsTier) |
|
|
587 | (2) |
|
Configure the Clone on the Target System |
|
|
589 | (2) |
|
Create a Group and Users on the Target System |
|
|
591 | (1) |
|
Change Ownership of the Target System Directories |
|
|
592 | (1) |
|
Execute the Clone Configuration Script on the Database Tier on the Target System |
|
|
592 | (2) |
|
Execute the Clone Configuration Script on the Application Tier on the Target System |
|
|
594 | (6) |
|
Cloning from a Single Node to a Multinode |
|
|
600 | (8) |
|
Execute the Clone Preparation Script on the Source System |
|
|
601 | (1) |
|
Execute the Clone Configuration Scripts on the Database and Application Tiers |
|
|
601 | (7) |
|
Cloning from a Multinode to a Single-Node Clone Using Online Backup |
|
|
608 | (16) |
|
Prepare the Clone on the Source System |
|
|
610 | (1) |
|
Execute the adpreclone.pl Script on dbTier |
|
|
610 | (1) |
|
Perform a Full Database rman Backup |
|
|
611 | (1) |
|
Execute a Full Database Backup rman Script |
|
|
612 | (2) |
|
Execute the adpreclone.pl Script on appsTier (Run Edition) |
|
|
614 | (1) |
|
Configure the Target System |
|
|
615 | (1) |
|
Execute the adcfgclone.pl Script with the dbTechStack Option |
|
|
616 | (2) |
|
|
618 | (4) |
|
Configure the Target System Application Tier |
|
|
622 | (2) |
|
Cloning in RAC-Enabled Systems |
|
|
624 | (8) |
|
|
626 | (1) |
|
Execute the adclone.pl Script for Staging |
|
|
626 | (2) |
|
Configure the Clone on the Target System |
|
|
628 | (3) |
|
Execute adclone.pl on the Target System |
|
|
631 | (1) |
|
Adding Nodes and Configuring Shared APPL_TOP |
|
|
632 | (5) |
|
Points to Be Considered for Shared APPL_TOP Deployment |
|
|
632 | (5) |
|
|
637 | (1) |
|
Change Passwords for All Superusers |
|
|
637 | (1) |
|
Configure the Workflow Mailer |
|
|
637 | (1) |
|
|
637 | (1) |
|
|
637 | (1) |
|
|
638 | (1) |
|
Cancel Scheduled Concurrent Requests |
|
|
638 | (1) |
|
Troubleshooting Cloning Issues |
|
|
638 | (1) |
|
Log Files on the Source System |
|
|
638 | (1) |
|
Log Files on the Target System |
|
|
638 | (1) |
|
|
639 | (2) |
Chapter 12 An Introduction to Oracle EBS Security |
|
641 | (34) |
|
Configuring SSL/TSL with Oracle EBS 12.2 |
|
|
642 | (7) |
|
|
642 | (6) |
|
Configuration of the Web Tier (FMW) |
|
|
648 | (1) |
|
|
649 | (1) |
|
Using a DMZ and Reverse Proxy with Oracle EBS 12.2 |
|
|
649 | (11) |
|
DMZ Configuration with External and Internal Application Tiers (Option 1) |
|
|
650 | (1) |
|
DMZ Configuration with Reverse Proxy and External Application Tier (Option 2) |
|
|
651 | (1) |
|
DMZ Configuration with Multiple Internal/External Application Tiers Within the Intranet and DMZ (Option 3 and Option 4) |
|
|
652 | (8) |
|
Using TDE with Oracle EBS 12.2 Database |
|
|
660 | (5) |
|
Key Points for Transparent Data Encryption |
|
|
661 | (1) |
|
Transparent Data Encryption Column Level (CE) |
|
|
661 | (1) |
|
Configuration of TDE Wallet |
|
|
662 | (3) |
|
Users and Password Management in Oracle EBS 12.2 |
|
|
665 | (5) |
|
Use the FNDCPASS Utility for Changing Passwords |
|
|
666 | (1) |
|
Use AFPASSWD for Changing the APPS Password |
|
|
666 | (4) |
|
Securing the Database and Application Files |
|
|
670 | (2) |
|
|
671 | (1) |
|
Oracle EBS Security Profile Options |
|
|
671 | (1) |
|
|
672 | (2) |
|
|
674 | (1) |
Chapter 13 Oracle E-Business Suite 12.2 Performance Recommendations |
|
675 | (60) |
|
Introduction to Oracle EBS Performance Tuning |
|
|
675 | (1) |
|
EBS 12.2 Client-Side Performance Tuning |
|
|
676 | (3) |
|
EBS 12.2 Middle Tier Performance Tuning |
|
|
679 | (9) |
|
EBS 12.2 Database Structure and Performance |
|
|
688 | (2) |
|
Initialization Parameters |
|
|
690 | (8) |
|
Tablespaces, Data Files, and Redolog Files |
|
|
698 | (15) |
|
EBS 12.2 SQL Access Paths |
|
|
713 | (7) |
|
EBS 12.2 Network Performance Tuning |
|
|
720 | (1) |
|
EBS 12.2 Tuning the Concurrent Processing |
|
|
721 | (10) |
|
Performance Recommendations for Reporting, Workflow, and Application Debug Profiles |
|
|
731 | (3) |
|
|
734 | (1) |
Chapter 14 Oracle E-Business Suite 12.2 on Engineered Systems |
|
735 | (30) |
|
Introduction to Oracle Engineered Systems |
|
|
735 | (3) |
|
Exadata Fresh Installation |
|
|
738 | (3) |
|
|
741 | (6) |
|
Configuring and Managing EBS 12.2 on Exadata |
|
|
747 | (5) |
|
Benefits of Running EBS on Exadata Systems |
|
|
752 | (2) |
|
Oracle Database Appliance Implementations |
|
|
754 | (7) |
|
Installing EBS 12.2 on ODA Bare Metal |
|
|
755 | (3) |
|
Installing EBS 12.2 on Virtualized ODA |
|
|
758 | (3) |
|
|
761 | (2) |
|
|
763 | (2) |
Index |
|
765 | |