AMX DAS-AMP4 Guide d'installation Page 1

Oracle® Application Management Pack for Oracle E-Business SuiteGuideRelease 12.1.0.2.0Part No. E39873-01November 2013

x5 Credentials6 Preferences7 Security8 Monitoring Oracle E-Business Suite9 Monitoring Configuration10 Diagnosing Issues11 Cloning an Oracle E-B

8-32 Oracle Application Management Pack for Oracle E-Business Suite GuideConcurrent Processing DashboardThe Concurrent Processing Dashboard provide

Monitoring Oracle E-Business Suite 8-33Overview TabThe General region lists the status of the Concurrent Processing Service• Status - The status is

8-34 Oracle Application Management Pack for Oracle E-Business Suite Guide• Type • Status • Incidents • Host The Incidents region lists any incident

Monitoring Oracle E-Business Suite 8-35Current Activity TabThe Concurrent Requests by Status region lists the number of requests for each status:•

8-36 Oracle Application Management Pack for Oracle E-Business Suite Guide• Requests Warning Rate (%)• Requests Error Rate (%)Click on the number fo

Monitoring Oracle E-Business Suite 8-37• Pending - These are sorted by running time in descending order.• Scheduled - These are sorted by their sch

8-38 Oracle Application Management Pack for Oracle E-Business Suite Guiderunning time are shown. For each program listed, the number of executions,

Monitoring Oracle E-Business Suite 8-39User-Defined Targets TabYou can add concurrent managers and programs as targets to monitor. Use this tab to

8-40 Oracle Application Management Pack for Oracle E-Business Suite Guide• Long-Pending Requests• Long-Running RequestsUse the Add button under Con

Monitoring Oracle E-Business Suite 8-412. For your new target, define the following:• Target Name Prefix - This value is determined by the system

 xiOracle Enterprise Manager Cloud Control Basic Installation Guide covers basic installation procedures that help you get started with Enterprise

8-42 Oracle Application Management Pack for Oracle E-Business Suite Guide• (Database) Password • ConnectString3. For metrics collection, you need

Monitoring Oracle E-Business Suite 8-43Metrics CollectedThe following metrics are collected:Basic InformationThis page lists metrics for the follow

8-44 Oracle Application Management Pack for Oracle E-Business Suite GuideLong Pending Requests• Request ID• Concurrent Program Short Name• Concurre

Monitoring Oracle E-Business Suite 8-45• Request Start Date• Username• Phase• Status• Pending Time• Concurrent ManagerRequests Completed with Error

8-46 Oracle Application Management Pack for Oracle E-Business Suite GuideRunning Requests• Request ID• Concurrent Program Short Name• Concurrent Pr

Monitoring Oracle E-Business Suite 8-472. For your new target, define the following:• Target Name Prefix - This value is determined by the system

8-48 Oracle Application Management Pack for Oracle E-Business Suite Guide• (Database) Password • ConnectString3. For metrics collection, you need

Monitoring Oracle E-Business Suite 8-49• Process StatusPending Requests• Request ID• Concurrent Program Short Name• Concurrent Program Name• Reques

8-50 Oracle Application Management Pack for Oracle E-Business Suite GuideConcurrent Processing MetricsThis section lists the concurrent processing

Monitoring Oracle E-Business Suite 8-51• Total Executions • Errored Executions • Errored Executions (%) Applications by Executions• Application Sho

xiirecord of changes.

8-52 Oracle Application Management Pack for Oracle E-Business Suite GuidePrograms by Errored Executions• Concurrent Program Name • User Concurrent

Monitoring Oracle E-Business Suite 8-53• User Name • Manager Name • Phase • StatusTop Running Requests• Request ID • Program Name • Program Short N

8-54 Oracle Application Management Pack for Oracle E-Business Suite GuideTop Users (Requests Submitted)• User Name • Number of RequestsUsers by Pen

Monitoring Oracle E-Business Suite 8-55Menu, selecting Monitoring, then selecting All Metrics.For Long Pending Requests, the following details are

Monitoring Configuration 9-19Monitoring ConfigurationConfiguring Monitoring of Oracle E-Business SuiteYou can change the configuration with which e

9-2 Oracle Application Management Pack for Oracle E-Business Suite Guideschema. You can either change the user name or password here and click Next

Monitoring Configuration 9-3The Available Targets section allows you to search for targets and add them to the availability computation list. You c

Diagnosing Issues 10-110Diagnosing IssuesDiagnosing IssuesPack DiagnosticsOracle Application Management Pack for Oracle E-Business Suite includes a

Introduction to the Oracle Application Management Pack for Oracle E-Business Suite 1-11Introduction to the Oracle Application Management Pack for O

10-2 Oracle Application Management Pack for Oracle E-Business Suite GuideHow to run a diagnostic testTo execute a diagnostic test, click on the Cre

Diagnosing Issues 10-3Field DescriptionShow Details You can select the extent of detail you want in the final report. •All - This option logs all i

10-4 Oracle Application Management Pack for Oracle E-Business Suite Guidethe Diagnostics dashboard, available from the Pack Diagnostics link on the

Diagnosing Issues 10-5Step SeverityTest Description Notes/Expected Results/Corrective MeasuresEBS WarningGet the Database Tier Operating System Use

10-6 Oracle Application Management Pack for Oracle E-Business Suite GuideStep SeverityTest Description Notes/Expected Results/Corrective MeasuresEB

Diagnosing Issues 10-7Step SeverityTest Description Notes/Expected Results/Corrective MeasuresEBS WarningGet key information required for AppsConte

10-8 Oracle Application Management Pack for Oracle E-Business Suite GuideStep SeverityTest Description Notes/Expected Results/Corrective MeasuresEB

Diagnosing Issues 10-9Step SeverityTest Description Notes/Expected Results/Corrective MeasuresEBS WarningGet key environment variables for Applicat

10-10 Oracle Application Management Pack for Oracle E-Business Suite GuideUser-Specific Tests for CloningStepSeverityTest Description Notes/Expecte

Diagnosing Issues 10-11Generic Diagnostic Tests for Patch ManagerStepTest Group Description Notes/Expected Results/Corrective MeasuresEMGCCheck per

1-2 Oracle Application Management Pack for Oracle E-Business Suite GuideEnterprise Manager itself allows you to monitor multiple Oracle E-Business

10-12 Oracle Application Management Pack for Oracle E-Business Suite GuideUser-Specific Diagnostic Tests for Patch ManagerStepTest Group Descriptio

Diagnosing Issues 10-13Generic Diagnostic Tests for Customization ManagerStepTest Group Description Notes/Expected Results/Corrective MeasuresEMGCC

10-14 Oracle Application Management Pack for Oracle E-Business Suite GuideStepTest Group Description Notes/Expected Results/Corrective MeasuresEBS

Diagnosing Issues 10-15StepTest Group Description Notes/Expected Results/Corrective MeasuresEMGCSummary A summary of all of the diagnostic tests th

10-16 Oracle Application Management Pack for Oracle E-Business Suite GuideGeneric Tests for User MonitoringTest Description Corrective ActionsCheck

Cloning an Oracle E-Business Suite System 11-111Cloning an Oracle E-Business Suite SystemCloning an Oracle E-Business Suite SystemOne of the key fe

11-2 Oracle Application Management Pack for Oracle E-Business Suite Guide• Configuring RAC databases• Customizing the listener names is supported i

Cloning an Oracle E-Business Suite System 11-3TermsThe following table lists some cloning terms used in this document.Term MeaningSource Oracle E-B

11-4 Oracle Application Management Pack for Oracle E-Business Suite Guide<ip-address> <Machine name with domain name> <Machine Name&

Cloning an Oracle E-Business Suite System 11-5privileges.The privileges listed below could be granted in many ways depending on the desired level o

Installing the Oracle Application Management Pack for Oracle E-Business Suite 2-12Installing the Oracle Application Management Pack for Oracle E-Bu

11-6 Oracle Application Management Pack for Oracle E-Business Suite Guide4. The following Named Credentials must be defined:• Host target type • A

Cloning an Oracle E-Business Suite System 11-7• Number of parallel threads/processes that will be used while zipping, transferring and unzipping th

11-8 Oracle Application Management Pack for Oracle E-Business Suite GuideAlso, note the following regarding zipping of files during the cloning pro

Cloning an Oracle E-Business Suite System 11-93. Enter general information for the cloning process. This step captures information related to the

11-10 Oracle Application Management Pack for Oracle E-Business Suite GuideIf the target database is a RAC database, the Target Database Details reg

Cloning an Oracle E-Business Suite System 11-114. Enter RAC Target database details, if applicable. This step only applies if the target database

11-12 Oracle Application Management Pack for Oracle E-Business Suite GuidePort fields are not populated (for example, if the cluster target instanc

Cloning an Oracle E-Business Suite System 11-13In the Available Target System Nodes region, choose the source host that can be used as a reference

11-14 Oracle Application Management Pack for Oracle E-Business Suite Guidethe default option.Then choose the source host that can be used as a refe

Cloning an Oracle E-Business Suite System 11-159. Enter Credentials.Smart Clone uses named credentials. You can select and test the named credenti

2-2 Oracle Application Management Pack for Oracle E-Business Suite GuideImportant: Uninstalling Oracle Application Management Pack for Oracle E-Bus

11-16 Oracle Application Management Pack for Oracle E-Business Suite GuideNote: Database schema credentials appear only when the source application

Cloning an Oracle E-Business Suite System 11-17The Credentials page for a Smart Clone procedure where the source applications system is single node

11-18 Oracle Application Management Pack for Oracle E-Business Suite Guideshipped Smart Clone procedure, see: Adding Custom Steps to a Smart Clone

Cloning an Oracle E-Business Suite System 11-19Running Scale-Up and Scale-Down Multi-Node Cloning ProceduresThis section describes using Smart Clon

11-20 Oracle Application Management Pack for Oracle E-Business Suite Guide"Start a Clone" list.2. Enter general information for the clon

Cloning an Oracle E-Business Suite System 11-21If the target database is a RAC database, the Target Database Details is rendered differently, as sh

11-22 Oracle Application Management Pack for Oracle E-Business Suite GuideProvide the following for the target database:• Apps Schema Username• App

Cloning an Oracle E-Business Suite System 11-23automatically render so that you provide names for the target database listeners in the required fie

11-24 Oracle Application Management Pack for Oracle E-Business Suite Guide• Details of the services on the nodes5. Enter target information on the

Cloning an Oracle E-Business Suite System 11-25If you want to delete a node from a service, select the node to be deleted and click the Delete butt

Installing the Oracle Application Management Pack for Oracle E-Business Suite 2-3Note: Unlike in a previous release, you do not need to install the

11-26 Oracle Application Management Pack for Oracle E-Business Suite GuideCommon Properties for Shared APPL_TOPWhen you click the Check Availabilit

Cloning an Oracle E-Business Suite System 11-279. Enter Credentials.Smart Clone uses Named Credentials. You can select and test the named credenti

11-28 Oracle Application Management Pack for Oracle E-Business Suite GuideNote: Database schema credentials appear only when the source application

Cloning an Oracle E-Business Suite System 11-29The Credentials page for a Smart Clone procedure where the source applications system is single node

11-30 Oracle Application Management Pack for Oracle E-Business Suite GuideDeployment Procedure, page 11-38.11. Schedule the deployment.12. Review y

Cloning an Oracle E-Business Suite System 11-31What's NextWhen a multi-node to multi-node applications tier cloning procedure is submitted, th

11-32 Oracle Application Management Pack for Oracle E-Business Suite Guide2. Enter basic information for your cloning procedure, including Clone Na

Cloning an Oracle E-Business Suite System 11-33For the RAC Target DB Node Specific Details:• Virtual Host Name - The virtual host name. Note that t

11-34 Oracle Application Management Pack for Oracle E-Business Suite GuideYou can choose the port pool for run file system and patch file system. Y

Cloning an Oracle E-Business Suite System 11-35If you choose Copy, select the Copy Method:• Shared File Copy Option - Choose this option if the sta

2-4 Oracle Application Management Pack for Oracle E-Business Suite GuideE-Business Suite target, the plug-in will not be upgraded on that agent. Fo

11-36 Oracle Application Management Pack for Oracle E-Business Suite Guide6. Enter the Schedule information.You can select "Immediate" t

Cloning an Oracle E-Business Suite System 11-37In the case of a RAC target database, specific information pertaining to RAC is also displayed.Note

11-38 Oracle Application Management Pack for Oracle E-Business Suite Guidefigure below illustrates these steps. 1. In the first manual step, a man

Cloning an Oracle E-Business Suite System 11-39directive step and add it to a copy of an out-of-the-box deployment procedure, refer to the Oracle E

11-40 Oracle Application Management Pack for Oracle E-Business Suite Guide3. Specify a name and other attributes for the directive.

Cloning an Oracle E-Business Suite System 11-414. Add parameters for the directive.

11-42 Oracle Application Management Pack for Oracle E-Business Suite Guide5. Select the "Software Library" location and the script to be

Cloning an Oracle E-Business Suite System 11-432. Select "Smart Clone" and click "Create Like".3. Enter a name and other gene

11-44 Oracle Application Management Pack for Oracle E-Business Suite Guide4. On the Procedure Steps tab, select the step before, inside, or after

Cloning an Oracle E-Business Suite System 11-455. Give the new step a name and enter additional information for the step.

Installing the Oracle Application Management Pack for Oracle E-Business Suite 2-52. Search using the search term Target Type "Oracle Applicat

11-46 Oracle Application Management Pack for Oracle E-Business Suite Guide6. Search for the directive and click Next.7. Map the parameters as requ

Cloning an Oracle E-Business Suite System 11-47supported in Smart Clone for Release 12.2.x.8. Save the custom step and then save the procedure.

11-48 Oracle Application Management Pack for Oracle E-Business Suite Guide9. You can now submit the newly-created deployment procedure.

Introduction to Change Management  12-112Introduction to Change Management IntroductionChange Management for Oracle E-Business Suite (formerly deli

12-2 Oracle Application Management Pack for Oracle E-Business Suite GuideMajor Benefits• Simplifies the mechanism of orchestrating changes across m

Introduction to Change Management  12-3requests and historical data. A common change control tracking dashboard is provided for tracking all change

12-4 Oracle Application Management Pack for Oracle E-Business Suite GuideThe Change Approval Dashboard allows users with the proper privileges to p

Introduction to Change Management  12-5• Enter the SMTP information as described below. To set the SMTP information in Oracle Enterprise Manager:Th

Patch Manager 13-113Patch ManagerIntroductionPatch Manager allows you to deploy patches across Oracle E-Business Suite instances from a single cons

Oracle Application Management Pack for Oracle E-Business Suite Guide, Release 12.1.0.2.0Part No. E39873-01Copyright © 2007, 2013, Oracle and/or its af

2-6 Oracle Application Management Pack for Oracle E-Business Suite Guide• omsPatchStageDir (OMS Stage Directory Location)• MOSEnabled/metalinkEnabl

13-2 Oracle Application Management Pack for Oracle E-Business Suite Guide• Leverages Oracle Enterprise Manager infrastructure for distributed proce

Patch Manager 13-3Patch RunsThe Patch Runs region of the Patch Manager Home lists the patch runs and their statuses for Oracle E-Business Suite Rel

13-4 Oracle Application Management Pack for Oracle E-Business Suite GuideNote that with Release 12.2, the adop patching process in Patch Manager is

Patch Manager 13-5• Cutover - This icon submits the cutover deployment procedure. It opens a window in which you can schedule the cutover. This fea

13-6 Oracle Application Management Pack for Oracle E-Business Suite GuidePrerequisites for viewing Patch Manager logsTo access the Patch Manager Lo

Patch Manager 13-7Abort DeploymentsThis region shows all of the executions of the "Abort an Oracle E-Business Suite Online Patch Cycle" d

13-8 Oracle Application Management Pack for Oracle E-Business Suite Guideicon. Records can be filtered by status using the "Show" list. T

Patch Manager 13-9target again. Custom patches, described in the next chapter, will always be moved from the OMS to the target because a developer

13-10 Oracle Application Management Pack for Oracle E-Business Suite Guide• Patch Run Name - Enter a user-friendly name for the patch run. You can

Patch Manager 13-11the same release level.Once selected, the system name will appear in the Target List with the following:• Applications System Na

Getting Started with the Oracle Application Management Pack for Oracle E-Business Suite 3-13Getting Started with the Oracle Application Management

13-12 Oracle Application Management Pack for Oracle E-Business Suite GuideThe following are shown on the Patch Details page: These are set in the P

Patch Manager 13-132. In the Search and Select window, Patch Oracle E-Business Suite, if you are downloading a patch or patches from My Oracle Sup

13-14 Oracle Application Management Pack for Oracle E-Business Suite Guide2. In the Search and Select window, you can search based on the followin

Patch Manager 13-15• Description - The description of the patch.• Files - The files to be downloaded for the patch.• Order - The order the patches

13-16 Oracle Application Management Pack for Oracle E-Business Suite Guide4. Specify Patch Options.Specify details for how the patch should be app

Patch Manager 13-17notifies other Enterprise Manager administrators that a maintenance procedure is being performed on the environment.• Disable Ar

13-18 Oracle Application Management Pack for Oracle E-Business Suite Guide• Disable File Generation - Tells adpatch not to run commands normally fo

Patch Manager 13-19You can choose to apply the patches immediately or at a later date.If you choose Immediately as the schedule type to have the pa

13-20 Oracle Application Management Pack for Oracle E-Business Suite GuideThe Review Page lets you review your patch run details, target list, patc

Patch Manager 13-21• WLS domain credentials• Description• Justification - Enter a justification that can be used by an approver deciding to approve

3-2 Oracle Application Management Pack for Oracle E-Business Suite GuideSystem Management PageThe System Management page gives you a bird's ey

13-22 Oracle Application Management Pack for Oracle E-Business Suite GuideYou can search for a patch based on the following criteria:• Patch Number

Patch Manager 13-23Preferences page.Selecting the "Merge Patches" option will merge the patches when running adop later. Selecting the &q

13-24 Oracle Application Management Pack for Oracle E-Business Suite GuideNote: For a controlled-release patch, a lock icon appears next tothe patc

Patch Manager 13-25With Oracle E-Business Suite Release 12.2 the adop patching process required two deployment procedures. The first deployment pro

13-26 Oracle Application Management Pack for Oracle E-Business Suite Guide• Schedule• Indefinite Grace PeriodFor the Prepare phase, specify Pause A

Patch Manager 13-27through finalize with the missed prerequisite then restart the original failed deployment procedure.Check the Indefinite Cutover

13-28 Oracle Application Management Pack for Oracle E-Business Suite GuideThe Review Page lets you review your deployment procedure details.Copying

Patch Manager 13-29• The Requester field has a default value of the original requester's user name. Change this value as appropriate.• The new

13-30 Oracle Application Management Pack for Oracle E-Business Suite GuideLogging, Health Checks, and TroubleshootingThis section describes logging

Patch Manager 13-31How to Change the Patch Run Purge PolicyEnterprise Manager periodically purges Patch Manager deployment procedure execution data

Getting Started with the Oracle Application Management Pack for Oracle E-Business Suite 3-3Oracle E-Business Suite instances are to standards. Navi

Customization Manager 14-114Customization ManagerIntroductionCustomization Manager automates the process of packaging, releasing and reporting cust

14-2 Oracle Application Management Pack for Oracle E-Business Suite Guideformat (RTF) for Microsoft Word, PDF, or Microsoft Excel.• Leverages Oracl

Customization Manager 14-3File ManifestThe file manifest contains a list of files to be included in a package.File Metadata RepositoryThe File Meta

14-4 Oracle Application Management Pack for Oracle E-Business Suite GuideApplications Standards ValidationCustomization Manager has a standards che

Customization Manager 14-5Important: When using the automatic header update feature with CVS, you must have a $Header placeholder within each sourc

14-6 Oracle Application Management Pack for Oracle E-Business Suite Guide• .msg • .odf • .pdt • .pkb• .pkh • .pks• .pl • .plb • .pls • .sh • .slt •

Customization Manager 14-7Uploading Existing Custom PatchesYou can upload a custom patch to Customization Manager repository:The upload option is p

14-8 Oracle Application Management Pack for Oracle E-Business Suite Guidewithin the file driver file for selected file types like forms, reports, a

Customization Manager 14-9Customization Manager Main PageThe main page for Customization Manager lists packages that are registered in the system.

14-10 Oracle Application Management Pack for Oracle E-Business Suite GuideThe following functions are available for a given package (depending on i

Customization Manager 14-11File Source MappingFile Source Mapping captures all the required metadata for retrieving custom files from a source cont

14-12 Oracle Application Management Pack for Oracle E-Business Suite Guidewhen no package is associated with it.To create a File Source Mapping:Per

Customization Manager 14-13Command" option. It is also important to ascertain that the user provided within the "host" credentials h

14-14 Oracle Application Management Pack for Oracle E-Business Suite Guide• Language • Branch - If your source control system requires it and if %b

Customization Manager 14-153. Enter the stage path. The stage path is the location of the directory, with write permissions, to where the files wo

14-16 Oracle Application Management Pack for Oracle E-Business Suite GuideName Description Related User Interface PageSample Value%product_code%Sub

Customization Manager 14-17E-Business Suite MappingCreating an E-Business Suite Mapping is an optional setup step. This mapping is used ifJava or P

14-18 Oracle Application Management Pack for Oracle E-Business Suite GuideSelect the Create button to create a new mapping.To create an E-Business

Customization Manager 14-19To create an E-Business Suite Mapping using the "Create Like" option:Select the Create Like button to create a

Discovering Oracle E-Business Suite with Cloud Control 4-14Discovering Oracle E-Business Suite with Cloud ControlPreparatory Steps for DiscoveryPri

14-20 Oracle Application Management Pack for Oracle E-Business Suite Guide• Package Name - Enter a user-friendly name for the package.• Product - E

Customization Manager 14-21#Product,SourcePath,FileName,Version,Type,DestPath,LangCodexxco,java\r12\reporter\cpserver,XXCOCustomCp.java,115.1,java,

14-22 Oracle Application Management Pack for Oracle E-Business Suite Guide• File Name - The name of the file. This would be substituted in the &quo

Customization Manager 14-23Important: Customization Manager strongly recommends that eachfile included within a customization package has an Oracle

14-24 Oracle Application Management Pack for Oracle E-Business Suite Guide• Enter the E-Business Suite information (Conditionally required). The E-

Customization Manager 14-25Manager. Note that this validation is done only if you use the Check Prerequisites button in the Patch Details page when

14-26 Oracle Application Management Pack for Oracle E-Business Suite GuideTo create a package using the Upload option:If you have any legacy custom

Customization Manager 14-27Updating a PackageTo update a package, find the package listing in the main Customization Manager page and select the ic

14-28 Oracle Application Management Pack for Oracle E-Business Suite Guideproduct created in Oracle E-Business Suite (not in Customization Manager)

Customization Manager 14-29For Release 12 (and higher) packages, enter in the prerequisite patch numbers that will be used in validation when the p

4-2 Oracle Application Management Pack for Oracle E-Business Suite GuideNote: For an AutoConfig-enabled Release 11i instance, running AutoConfig on

14-30 Oracle Application Management Pack for Oracle E-Business Suite Guide• Standards Check Results• Status• Language• Public (Choose whether you w

Customization Manager 14-31Saved, Failed, Released, and Obsoleted.• Product • Package Type • E-Business Suite Mapping Name – If applicable.• File S

14-32 Oracle Application Management Pack for Oracle E-Business Suite GuideView LogUse the View Log button to view the most recent Oracle Enterprise

Customization Manager 14-33Technology Stack DetailsThe Technology Stack details for a package provide a snapshot of the technology stack properties

14-34 Oracle Application Management Pack for Oracle E-Business Suite GuideUpdating Package MetadataPackage metadata can be updated to change the st

Customization Manager 14-35Standards Checker ResultsThe results of the standards checker can be accessed by clicking on the standards checker statu

14-36 Oracle Application Management Pack for Oracle E-Business Suite GuideCreating a Report To create a report, you can • Select a package from the

Customization Manager 14-376. Click Submit.To create a Comparison Report:A Comparison report allows you to compare two packages. For example, you

14-38 Oracle Application Management Pack for Oracle E-Business Suite GuideTo create an Instance Comparison Report:An Instance Comparison report all

Customization Manager 14-396. Click Submit.Viewing a ReportTo access reports, navigate to the Change Management tab > Package Report, or to the

Discovering Oracle E-Business Suite with Cloud Control 4-3Adding an Oracle E-Business Suite database:1. Navigate to Discovery Wizard.2. Click on

14-40 Oracle Application Management Pack for Oracle E-Business Suite Guide• Download - Click on the link provided to download a ZIP file containing

Customization Manager 14-41• File comparison to report missing files or version differences.• Technology Stack Details - For each given property, t

14-42 Oracle Application Management Pack for Oracle E-Business Suite GuideMaintaining the File Metadata RepositoryThe File Metadata Repository stor

Customization Manager 14-43• PL/SQL spec and body (all formats)• SQL files• Oracle Application Framework XML files• XDFThe information on a file ca

14-44 Oracle Application Management Pack for Oracle E-Business Suite Guide5. Enter the language for the file.6. Optionally enter a description.7.

Customization Manager 14-45• A custom application "definition" is de-coupled from registration. Once an application is defined, it can be

14-46 Oracle Application Management Pack for Oracle E-Business Suite Guide2. Specify an Application Short Name for your application. Note that onl

Customization Manager 14-472. Select the custom application you wish to discover and click Submit. You can use the Search feature to narrow down t

14-48 Oracle Application Management Pack for Oracle E-Business Suite Guide2. Enter in the Application Short Name for the application. You can use

Customization Manager 14-492. In the Auto-Correct Custom Application page, enter the following:• Custom Application's Schema Password. If you

4-4 Oracle Application Management Pack for Oracle E-Business Suite Guide• Versions of target metadata For more information on these checks, see: Pr

14-50 Oracle Application Management Pack for Oracle E-Business Suite Guide5. Click on the name of the request to view details.6. You can download

Customization Manager 14-51To register a custom application on an Oracle E-Business Suite instance:1. Navigate to the Custom Applications page. Cl

14-52 Oracle Application Management Pack for Oracle E-Business Suite GuideTo view details of custom application:View details of a custom applicatio

Customization Manager 14-53• List of packages that have been created for the custom application.To track details of a custom application request:A

14-54 Oracle Application Management Pack for Oracle E-Business Suite GuideTo execute a job to register or validate a custom application when the ch

Target Types A-1ATarget TypesTarget TypesThe following table lists details of the individual target types shipped in the management pack.Target Typ

A-2 Oracle Application Management Pack for Oracle E-Business Suite GuideTarget Type Applicable Oracle E-Business SuiteReleaseDescriptionOracle E-Bu

Target Types A-3Target Type Applicable Oracle E-Business SuiteReleaseDescriptionForms Listener for OracleE-Business Suite 11i11i Target representin

Pre-validation for Discovery B-1BPre-validation for DiscoveryPrevalidation Checks for DiscoveryThe following table lists the checks used in the pre

Discovering Oracle E-Business Suite with Cloud Control 4-52. Select the Oracle E-Business Suite database target and click on Discover. 3. Enter t

B-2 Oracle Application Management Pack for Oracle E-Business Suite GuideCategory Sub category Description Applicable Releases of Oracle E-Business

Pre-validation for Discovery B-3Category Sub category Description Applicable Releases of Oracle E-Business SuiteOS User Agent OS user and Oracle E

Supported File Types in Customization Manager C-1CSupported File Types in Customization ManagerSupported File TypesThe following table lists the su

C-2 Oracle Application Management Pack for Oracle E-Business Suite GuideFile Type Name Source Extension Description Object Actionxls xls Microsoft

Supported File Types in Customization Manager C-3File Type Name Source Extension Description Object Actionsql sql SQL script copy and execute as

C-4 Oracle Application Management Pack for Oracle E-Business Suite GuideFile Type Name Source Extension Description Object Actionsqlj sqlj SQLJ fi

Supported File Types in Customization Manager C-5File Type Name Source Extension Description Object Actionjs js Javascript file copyrpt rpt Oracle

C-6 Oracle Application Management Pack for Oracle E-Business Suite GuideFile Type Name Source Extension Description Object Actionmac maccopycfg c

Supported File Types in Customization Manager C-7File Type Name Source Extension Description Object Actiondocument htm htm used in document patche

 iiiContentsSend Us Your CommentsPreface1 Introduction to the Oracle Application Management Pack for Oracle E-Business SuiteOverview...

4-6 Oracle Application Management Pack for Oracle E-Business Suite Guide4. Enter the monitoring schema credentials for the database.5. Enter the us

C-8 Oracle Application Management Pack for Oracle E-Business Suite GuideFile Type Name Source Extension Description Object ActionXMLP PDF notransp

Supported File Types in Customization Manager C-9File Type Name Source Extension Description Object Actioncreate_view_ownersql Create View Owner S

C-10 Oracle Application Management Pack for Oracle E-Business Suite GuideFile Type Name Source Extension Description Object Actionfmt fmt Oracle F

Supported File Types in Customization Manager C-11File Type Name Source Extension Description Object Actioncoremif coremif XML file that contains

C-12 Oracle Application Management Pack for Oracle E-Business Suite GuideFile Type Name Source Extension Description Object Actiontpl tpl template

Supported File Types in Customization Manager C-13File Types Description Recommended destination path (relative to product top)sql, package_spec,pa

C-14 Oracle Application Management Pack for Oracle E-Business Suite GuideFile Types Description Recommended destination path (relative to product t

Supported File Types in Customization Manager C-15File Type Description Order Of Executionpackage_body Package body 7seed_data Custom seeded data S

Customization Manager Coding Standards D-1DCustomization Manager Coding StandardsCustomization Manager Coding Standards for FilesCustomization Mana

Discovering Oracle E-Business Suite with Cloud Control 4-7Discovering Oracle E-Business Suite as EM_MONITOR user (Recommended)Oracle E-Business Sui

D-2 Oracle Application Management Pack for Oracle E-Business Suite GuideStandard Name DescriptionJava Package Path Standard For Java files within a

Customization Manager Coding Standards D-3Standard Name DescriptionDrvx file location check Drvx files must be located under one of following direc

D-4 Oracle Application Management Pack for Oracle E-Business Suite GuideStandard Name DescriptionXDF Location Standard XDF files must be located un

Customization Manager Coding Standards D-5Standard Name DescriptionPkg Replace Check Use CREATE OR REPLACE PACKAGE for package creation. Do not omi

D-6 Oracle Application Management Pack for Oracle E-Business Suite GuideStandard Name DescriptionAdmin Dbdrv none checkAll files under [PROD_TOP]/a

Customization Manager Coding Standards D-7Standard Name DescriptionMview Parallel Standard Materialized Views should not be created with parallel c

D-8 Oracle Application Management Pack for Oracle E-Business Suite GuideStandard Name DescriptionJava class should not extend errorErrors are syste

Customization Manager Coding Standards D-9Standard Name DescriptionJDBC TimeStamp ComplianceThe proper column bind type should be used when sending

D-10 Oracle Application Management Pack for Oracle E-Business Suite GuideStandard Name Descriptiondbdrv: java UnzipFile.class must have correct syn

Customization Manager Coding Standards D-11Object Type Description File TypesTable A column type must be a built-in type or a user-defined type o

4-8 Oracle Application Management Pack for Oracle E-Business Suite GuideOptions for Customizing DiscoveryParameter Description Applicable Oracle E-

D-12 Oracle Application Management Pack for Oracle E-Business Suite GuideObject Type Description File TypesSynonym A table synonym must point to

Validation of Custom Applications: Examples E-1EValidation of Custom Applications: ExamplesValidation of Custom Applications: ExamplesThe following

E-2 Oracle Application Management Pack for Oracle E-Business Suite GuideIssue Recommendation for Release 11iThe file $APPL_TOP/admin/xxcustprod.txt

Validation of Custom Applications: Examples E-3Issue Recommendation for Release 11iThe entry for product xxcust is missing from FND_PRODUCT_INSTALL

E-4 Oracle Application Management Pack for Oracle E-Business Suite GuideIssue Recommendation for Release 11iThe database is missing user xxcustCrea

Validation of Custom Applications: Examples E-5Issue Recommendation for Release 11iEntry for the product xxcust in $APPL_TOP/admin/topfile.txt does

E-6 Oracle Application Management Pack for Oracle E-Business Suite GuideIssue Recommendation for Release 11iFile $APPL_TOP/xxcust/11.5.0/admin/driv

Known Product Limitations F-1FKnown Product LimitationsKnown Product Limitations1. Use of the native Oracle Enterprise Manager patch mechanism to

F-2 Oracle Application Management Pack for Oracle E-Business Suite Guide4. Creating copies of the out-of-box cloning procedures is not supported.

Third-Party Product License Information G-1GThird-Party Product License InformationThird-Party Product License InformationThis section includes thi

Discovering Oracle E-Business Suite with Cloud Control 4-9Parameter Description Applicable Oracle E-Business Suite ReleasesDelete Removed TargetsWh

G-2 Oracle Application Management Pack for Oracle E-Business Suite GuideSee http://www.gnome.ru/projects/vsdump_en.html The Office Open XML experim

Third-Party Product License Information G-3"Object" form shall mean any form resulting from mechanical transformation or translation of a

G-4 Oracle Application Management Pack for Oracle E-Business Suite GuideWork shall terminate as of the date such litigation is filed. 4. Redistrib

Third-Party Product License Information G-5the content of the NOTICE file.7. Disclaimer of Warranty. Unless required by applicable law or agreed t

G-6 Oracle Application Management Pack for Oracle E-Business Suite GuideCONDITIONS OF ANY KIND, either express or implied. See the License for the

Index-1IndexAAdministration of Oracle E-Business Suite, 8-14AD Patch Log, 13-30amp.propertiesreplaced by Preferences, 2-5APPS passwordchanging, F-2Au

Index-2saving a package, 14-29sharing a package, 14-41standards checker, 14-4, D-1updating a package, 14-27updating package metadata, 14-33DDeleting a

Index-3diagnostic tests, 10-10extending deployment, 13-29features, 13-1patch run, 13-8restarting failed workers, 13-30troubleshooting, 13-31upgrade co

4-10 Oracle Application Management Pack for Oracle E-Business Suite GuideConfigure column corresponding to each node. Customization at apps node le

Discovering Oracle E-Business Suite with Cloud Control 4-11PrerequisitesThe operating system user who runs command-line discovery must have the ful

4-12 Oracle Application Management Pack for Oracle E-Business Suite Guide./ebsdiscovery.sh inputfile=ebsList.txt omscred=omscred.conf logdir=/tmpAf

Discovering Oracle E-Business Suite with Cloud Control 4-13(;).For ENCRYPTED_PASSWORD=><encrypted apps password>, the encrypted password w

4-14 Oracle Application Management Pack for Oracle E-Business Suite GuideKey Supported ReleaseValid Values Description DefaultDISCOVER_WORKFLOW_SER

Discovering Oracle E-Business Suite with Cloud Control 4-15Key Supported ReleaseValid Values Description DefaultSRVLT_URL_FROM_CTXFILE11i Y or N W

iv5 CredentialsSetting Named Credentials... 5-1Set

4-16 Oracle Application Management Pack for Oracle E-Business Suite GuideKey Supported ReleaseValid Values Description DefaultWLS_ADMIN_PWD12.2 or

Discovering Oracle E-Business Suite with Cloud Control 4-173. Click Delete. By default, the system deletes application server targets (like the HT

Credentials 5-15CredentialsSetting Named CredentialsIn Enterprise Manager, as part of the target type definition, you can define the types of crede

5-2 Oracle Application Management Pack for Oracle E-Business Suite GuideCreating a Named Credential for Oracle E-Business Suite Applications LoginF

Credentials 5-3Creating Named Credentials to Access the DatabaseFollow these steps to create a named credential to access the Oracle E-Business Sui

5-4 Oracle Application Management Pack for Oracle E-Business Suite GuideThe following examples illustrate creating named credentials for database a

Credentials 5-5Example: Creating a Named Credential for the Oracle E-Business Suite Database APPLSYS SchemaUse the following steps to create a cred

5-6 Oracle Application Management Pack for Oracle E-Business Suite Guide5. Define your Credential Properties. Specify the username and password fo

Credentials 5-7instances of Oracle E-Business Suite or to a specific instance. So if you choose Targetfor the scope, you need to select Oracle E-Bu

 vRunning Scale-Up and Scale-Down Multi-Node Cloning Procedures...11-19Running Smart Clone for Oracle E-Business Suite

5-8 Oracle Application Management Pack for Oracle E-Business Suite Guide2. Select 'Host' as the Authenticating Target Type. 3. Select &

Credentials 5-9just a particular instance. To set these credentials, navigate to Setup (menu) > Security > Preferred Credentials in Enterpris

5-10 Oracle Application Management Pack for Oracle E-Business Suite GuideTo set these credentials, navigate to Setup (menu) > Security > Pref

Credentials 5-11Note: In Release 12.1.0.1.0, these credentials were named "Oracle E-Business Suite Infrastructure".Setting Preferred Cred

5-12 Oracle Application Management Pack for Oracle E-Business Suite GuideFile Source Mapping.• Oracle E-Business Suite Node - Set the "OS Cred

Preferences 6-16PreferencesSetting PreferencesUse Preferences in Enterprise Manager to configure some of the features in the management pack. Navig

6-2 Oracle Application Management Pack for Oracle E-Business Suite GuideSet the following for Patch Manager:• Default Hotpatch in Patch Manager• De

Preferences 6-3• ampCloneCommonTopParallelThreads • um_dashboard_no_of_rows (Number of Rows in tables of User Monitoring)• um_session_sampling_inte

Security 7-17SecurityPrivileges and Roles for Managing Oracle E-Business SuiteOracle Application Management Pack for Oracle E-Business Suite uses t

viReleasing and Sharing a Package... 14-41Maintaining the File M

7-2 Oracle Application Management Pack for Oracle E-Business Suite Guidebelow. Please note the following in regard to privileges:• The user SYSMAN

Security 7-3Target PrivilegesName Included Privileges DescriptionCreate splice request (none)•To create a request to register a new custom applicat

7-4 Oracle Application Management Pack for Oracle E-Business Suite GuideTarget Type Level PrivilegesName Included Privileges DescriptionCreate spli

Security 7-5Code Name Included PrivilegesDescriptionEBS_ACP_SUPER_USERChange Management Super User•Resource privilege "Approve release pac

7-6 Oracle Application Management Pack for Oracle E-Business Suite GuideRequired Privileges and RolesSpecific privileges are required to access the

Security 7-7Specific Privileges for FeaturesThe default roles EBS_SUPER_USER, EBS_ACP_SUPER_USER provide privileges on alltargets. If these roles a

7-8 Oracle Application Management Pack for Oracle E-Business Suite Guide• Approver: Approve Patch Manager request • Super User: BothAll above privi

Security 7-9All above privileges can be provided either "Common to All Targets" or "Specific to Target" by adding a target in R

Monitoring Oracle E-Business Suite 8-18Monitoring Oracle E-Business SuiteNavigation and OverviewOnce discovered, an Oracle E-Business Suite instanc

 viiSend Us Your CommentsOracle Application Management Pack for Oracle E-Business Suite Guide, Release 12.1.0.2.0Part No. E39873-01Oracle welcomes

8-2 Oracle Application Management Pack for Oracle E-Business Suite GuideTopology of the Oracle E-Business SuiteThe Configuration Topology Viewer pr

Monitoring Oracle E-Business Suite 8-3Upon service failure, the potential causes of failure, as identified by root cause analysis, are highlighted

8-4 Oracle Application Management Pack for Oracle E-Business Suite GuideSetting Thresholds for MetricsMetrics collected can be compared to predefin

Monitoring Oracle E-Business Suite 8-5Home Page of the Oracle E-Business Suite SystemGeneral Section The general section gives the following basic

8-6 Oracle Application Management Pack for Oracle E-Business Suite GuideSystem Name The name of the Oracle E-Business Suite instance.Version The ve

Monitoring Oracle E-Business Suite 8-7has been disabled in the Oracle E-Business Suite system for any reason, then these metrics will not be update

8-8 Oracle Application Management Pack for Oracle E-Business Suite GuideCritical Components of ServicesService Critical componentsConcurrent Proces

Monitoring Oracle E-Business Suite 8-9Performance Metrics for ServicesService Metric DescriptionConcurrent Processing ServiceConcurrent Requests Su

8-10 Oracle Application Management Pack for Oracle E-Business Suite GuideUsage Metrics for ServicesService Metric DescriptionConcurrent Processing

Monitoring Oracle E-Business Suite 8-11Incidents for ServicesYou can set thresholds for tracking the performance and usage of services. Incidents a

8-12 Oracle Application Management Pack for Oracle E-Business Suite GuideService Status Information on the Home PageStatus Whether the status is up

Monitoring Oracle E-Business Suite 8-13Targets Running on NodesThis section shows the targets running on each node in which the Oracle E-Business S

8-14 Oracle Application Management Pack for Oracle E-Business Suite GuideAdministration of Oracle E-Business SuiteStarting and Stopping ServicesYou

Monitoring Oracle E-Business Suite 8-15Privileges need to start and stop services An administrator must have the EM_ALL_ADMINISTRATOR role to run t

8-16 Oracle Application Management Pack for Oracle E-Business Suite GuideConfiguration of Oracle E-Business Suite You can get the details of how th

Monitoring Oracle E-Business Suite 8-17Here you can see the links to see the last collected configuration of all member targets grouped as nodes, h

8-18 Oracle Application Management Pack for Oracle E-Business Suite Guidedifferent times. The same applies to any member target of Oracle E-Busines

Monitoring Oracle E-Business Suite 8-19Compliance Standards for Oracle E-Business Suite The Oracle Enterprise Manager Compliance Management solutio

8-20 Oracle Application Management Pack for Oracle E-Business Suite GuideCompliance Standard Rules mapped to the standard SeverityTurn on ModSecuri

Monitoring Oracle E-Business Suite 8-21Monitoring User SessionsWhen a user logs in to Oracle E-Business Suite, the system creates sessions in the d

 ixPrefaceIntended AudienceWelcome to Release 12.1.0.2.0 of the Oracle Application Management Pack for Oracle E-Business Suite Guide.This book is

8-22 Oracle Application Management Pack for Oracle E-Business Suite Guide• Form sessions can be monitored only when the site-level profile Sign-On:

Monitoring Oracle E-Business Suite 8-23Searching for User SessionsYou can search for Oracle E-Business Suite user sessions usingDatabase Session ID

8-24 Oracle Application Management Pack for Oracle E-Business Suite GuideMonitoring JVM UsageNote: This feature is not supported for Oracle E-Busin

Monitoring Oracle E-Business Suite 8-25Setup StepsFor Release 12 systems, ensure that you have set up the monitoring configuration for each "o

8-26 Oracle Application Management Pack for Oracle E-Business Suite GuideTo disable the metric collection, run the following commands:emcli modify_

Monitoring Oracle E-Business Suite 8-27Obtaining the CA certificate(s)1. In Microsoft Internet Explorer, connect to the HTTPS URL of the Web site

8-28 Oracle Application Management Pack for Oracle E-Business Suite GuideManagement Server (OMS). You can click on the Refresh icon in the upper ri

Monitoring Oracle E-Business Suite 8-29A Note on Oracle Forms 6iEven though your Oracle Forms configuration may be running in SSL, Cloud Control do

8-30 Oracle Application Management Pack for Oracle E-Business Suite Guide5. Edit the "URL to measure application response" as appropriat

Monitoring Oracle E-Business Suite 8-31You can go to the following sections and its subsections in Oracle Applications Manager:• Database • Concurr