Monday, 11 November 2013

Basic details of Oracle E-business Suite & Major task of AppsDBA

Basic details of Oracle E-business Suite:

Introduction to Oracle E- Business Architecture

• Concepts and Architecture ICA
        -Two Tier/Three Tier Architecture
        -Fusion Architecture single node/multi node
• Introduction to oracle Apps Tier components
        -Apache IAS server,
        -form server,
        -concurrent processing server
• DB Tier component database server


Introduction to E-Business Suite 11i/ R12 File System and Directory Structure, EBS Data Model

Oracle EBS Application Modules:
• Business Specific Module and Technology Specific Module
• Installation of Oracle E-Business Suite applications 11i/R12
• Pre & Post Steps/Checklist of installation, Single/Multi node
• Installation. Creation of Oracle E-Business Suite Stage EBS Backup & Recovery
• Planning, Testing and Implementing EBS Applications and database backups and restores/recovery.


Major task of AppsDBA:

• Creation of Users
• Assigning Responsibilities to users
• Creation of Custom Responsibilities
• Creation of request group
• Creation of data group
• Creation of Custom Application
• Managing Concurrent Programs & Reports
• Administrating Concurrent Managers
• Creation of Custom Concurrent Manager
• Managing Profiles Options
• Structure of Profiles
• Seeded Profiles
• Custom Profiles
• Managing Flex Fields (KFF, DFF)
• Managing Printers
• Managing the Workflows activities (Notifications/Mailer)

Oracle EBS UTILITIES

• AD Administration (Adadmin)
• Auto Patch (Ad patch)
• AD Merge Patch (admrgpch)
• AD Controller (adctrl)
• AD File Identification (adident)
• AD Rilink (adrelink.sh)
• AutoConfig (adconfig.sh)
• AD Splice
• FNDCPASS
• FNDLOAD

Oracle Applications Manager (OAM)

• Oracle Applications Manager Features
• Managing/Monitoring EBS system through OAM console
• Introductions to Multi-Organization Concepts(Business Group, Legal Entities, Operation Unit, Inventory Organization)

Managing EBS Application Patches

• Introduction
• Structure of a Patch file & Patch drivers Searching Downloading & applying patches
• Pre & Post Steps Checks
• Patch History
• Monitoring & Troubleshooting Patch session
• Reducing Patching Time :- (Merging Patches, Patching Non- Interactively, Patching on Shared Apps Tier Using Distributed AD Features, Patching on Stage Instance)
• Troubleshooting Scenarios of Failed Patches and Hanging Patch Session.

Cloning:

• Cloning the existing EBS System Types & Methods of Cloning:-( Adclone, Rapidclone, OAMclone)
• Cloning Single Node to Single Node with Refresh / Partial Cloning
• Single Node to Multiple Node
• Multi Node to Single Node (With / Without Shared Apps Tier)
• Online Cloning / Hot Cloning and Troubleshooting Cloning Issues.

Performance Tuning:

• Proactive Performance Management:-
• Oracle EBS Health Management
• Effective EBS Configuration
• Routine/ Daily tasks
• Proactive Monitoring Troubleshooting Performance Issues
• Tracing forms and concurrent program session

Up gradation of Oracle E-Business Suite & Database:

• Upgrading EBS 10g database to 11g rel2 and Upgrading EBS 11.5.10.2 to R12, Upgrade Pre and Post steps, Troubleshooting Upgrade Issues

Troubleshooting:

• Resolving issues like Login & Connectivity Issues
• Files Corruption/Missing
• Performing AOL/J diagnostic test
• Gathering Diagnostic data using RDA tool

• Working with Oracle Support Services for raising SRs (Service Requests)


No comments:

Post a Comment