تقرير حول كتابان في Oracle E-Business Suite
هذان الكتابان هما تلبية لطلب الاخ عبد الله كتاب فى Oracle E-Business الكتاب الاول في ادارة اوركل اي بزنس سوت administering Oracle E-Business Suite والثاني في development, customization, and extensibility of Oracle E-Business Suite
What Is Oracle E-Business Suite?
Oracle E-Business Suite is a software package that allows organizations to manage key business processes; it is known on the market by various names such as Oracle Enterprise Resource Planning (ERP), Oracle Apps, Oracle Applications, Oracle Financials, e-Biz and EBS (E-Business Suite). In this book we refer to it as either E-Business Suite, or Oracle Applications. In the past, it was a common practice for businesses and organizations to develop in-house software to automate their business processes. Most of the software that was developed in-house largely matched the precise needs of the business. However, the fundamental business flows and processes such as accounting, procurement, human resource/employee management, and order management are based on common principles across all organizations. For example, most organizations require a system to make purchases from suppliers and a system to make payments to the suppliers, events known as transactions that need to be accounted for in the financial reporting. Enterprise Resource Planning (ERP) software prepackages different types of these functionalities into out-of-the-box software package, so that customers who purchase such software packages do not have to develop the same software applications time and again.Product FamiliesOracle E-Business Suite is a product offering that covers almost all of the business flows widely used in most organizations. Businesses can implement as many modules as necessary due to the modular but still integrated nature of the E-Business Suite architecture. This allows unified information to be available across the enterprise; it also reduces information technology (IT) expenses and helps run business more efficiently.On the contrary, managing heterogeneous software solutions developed in-house that use different systems and technologies can be extremely costly and complex. Any time you update one system, you must go back and review all the integration points and potentially update the interfaces between the systems. Oracle E-Business Suite is engineered to work as an integrated system on a common IT infrastructure.
You can directly pass information from one application to another without incurring ncremental integration costs.
The product offering in E-Business Suite is organized into product families.
Some of the key product families are as follows:You can directly pass information from one application to another without incurring ncremental integration costs.
The product offering in E-Business Suite is organized into product families.
- Financials
- Procurement
- Customer Relationship Management (CRM)
- Project Management
- Supply Chain Planning and Management
- Discrete Manufacturing
- Process Manufacturing
- Order Management
- Human Resources Management System (HRMS)
- Applications Technology
الكتاب الاول
Oracle 11i E-Business Suite From the Front Lines
Chapter 1 - Introducing Apps
Chapter 2 - 11i, 8i, and 9i New Features
Chapter 3 - The Surrounding Environment
Chapter 4 - Apache
Chapter 5 - JServ
Chapter 6 - Other Services
Chapter 7 - Printing
Chapter 8 - AD and Other Utilities
Chapter 9 - Installation and Migration
Chapter 10 - Patching
Chapter 11 - Cloning
Chapter 12 - Concurrent Managers and Concurrent Programs
Chapter 13 - AutoConfig, Oracle Application Manager, and Other Management Tools
Chapter 14 - Odds and Ends
الكتاب الثاني
Oracle E-Business Suite Development and Extensibility Handbook
1 Introduction to Oracle E-Business Suite
What Is Oracle E-Business Suite?
Product Families
Professional User Interface
Web User Interface
Configurations, Personalizations, Extensions, and Customizations
Configurations
Personalizations
Customizations and Extensions
Concept of E-Business Suite Environments
Concept of Common Entities and Common Data
Examples of Common Entities
Summary
2 E-Business Suite Architecture
Architecture Overview
E-Business Suite System Architecture
Client or Desktop Tier
Application Tier
Oracle Home Directories and File System in Oracle Applications
File System in Oracle Applications
File System in R11i
File System in R12
Environment Files in Oracle Applications
Database Tier
Summary
3 Application Object Library (AOL)
Applications in E-Business Suite
An Example: Attaching a Concurrent Program to an Application
Profile Options in Oracle Applications
Example Use Case for Profile Options
Creating Custom Profile Options
Descriptive Flexfields (DFFs)
Descriptive Flexfield FAQs
Key Flexfields (KFFs)
Key Flexfield FAQ
Lookups in Oracle Apps
Security of Lookups
Validating Flexfield Segments Against Lookups
Using Lookups for Custom Development
Value Sets
Value Set of a Validation Type Table
Message Dictionary 65
The Purpose of Message Dictionary 65
How a Message Is Created 65
Displaying a Message from Different Tools 66
Table Used by Messages Dictionary 67
Auditing in Oracle Apps: User Audits and Data Change Audits 67
Audit of End Users’ Activity 68
Audit of Data Changes 69
Row Who Columns 70
Common Debugging Framework in Oracle Applications 71
API to Capture Debug Messages in Custom Code Autonomous Transaction in Debugging 73
Debugging an API from SQL*Plus 73
Summary 74
4 Multiple Organizations Feature
Overview of Multi-Org 76
Multi-Org in R11i 77
Setting the Multi-Org Context in SQL*Plus 80
Multi-Org in Release 12 81
Technical Details of the MOAC Design 82
Summary 87
5 Development of Concurrent Programs
What Is a Concurrent Program? 90
Types of Concurrent Programs 91
How to Define a Concurrent Program 93
Creating a Hello World Concurrent Program 94
Examples of Concurrent Programs 102
Host Program 102
SQL*Loader Concurrent Programs 111
PL/SQL Program 113
Java Concurrent Program 116
Best Practices 120
Summary 122
6 Forms in Oracle Applications
Oracle Forms Tool: An Overview 124
Forms 125
Blocks 126
Items 126
Triggers 126
Property Palette 127
Forms Delivered by Oracle E-Business Suite Location of the Form Files on Server 128
Custom Forms in E-Business Suite 129
Preparing the Desktop for Custom Forms Development Steps for Developing Custom Forms in E-Business Suite Extending Forms Using CUSTOMpll 132
Example of an Extension Using CUSTOMpll 134
Best Practice for CUSTOMpll 139
Extending Forms Using Forms Personalization Examples of Forms Personalizations 145
Comparison Between Forms Personalization and CUSTOMpll Best Practices When Implementing Forms Personalizations Further Readings on Forms Personalizations 155
Summary 155
7 Reports Development and Customization in Oracle Apps
Data Model 158
Reports Delivered by Oracle Apps 161
Dynamic ORDER BY Clauses 162
Multi-Org Initialization 163
Reports Customization and Custom Reports Development 163
Reports Customization Example 165
Best Practices for Developing Reports in E-Business Suite 171
Summary 174
8 BI Publisher in Oracle Applications
Comparison Between BI Publisher and Oracle Reports BI Publisher: Introduction and Example 177
BI Publisher Example Using an XML File 178
Integration of BI Publisher with E-Business Suite Oracle Reports Integration with BI Publisher 184
Using a Data Template with BI Publisher 188
Using BI Publisher with OA Framework 194
Converting Oracle Reports Output to BI Publisher Bursting in E-Business Suite 206
Good Practices for Developing BI Publisher
Reports in E-Business Suite 209
Summary 210
9 OA Framework: Concepts, Development, and Extensions
PL/SQL-Based Web Pages 213
AK Developer 214
OA Framework with AK Developer Repository 216
Current Technology: OA Framework with MDS 216
Comparison Between Oracle Forms and OA Framework OA Framework Architecture 220
MDS: Pages in OA Framework 220
Controller in OA Framework 222
Business Components for Java 225
Where to Write Code 231
JDeveloper: Development Methodology 231
JDeveloper and Desktop Configuration 232
Concepts of OA Framework Personalizations Admin Personalizations 244
User-Level Personalizations 248
OA Framework Extensions 250
Identifying the Type of Required Extension 252
View Object Extension 253
Entity Object Extensions 254
Application Module Extension 255
Controller Extension 255
OAF Extensions: Fully Worked Example 259
OA Framework Extensions Tips 280
Summary 288
10 Custom Look and Feel
UIX: CLAF Enabling Technology 290
UIX Custom Style Sheets 293
UIX Custom Icons 293
UIX Custom Renderers 294
How to Create CLAF in Oracle Applications Creating Custom Styles and Icons 298
Best Practices 310
Summary 311
11 Oracle Workflow
Architecture Overview and Key Components Oracle Workflow Builder 316
Understanding Workflow Definition 316
An Example: Creating a Workflow Process 329
Workflow Engine 342
Embedding OA Framework Regions in WF Notifications 345
Directory Service 350
Business Events in Oracle Applications What Is a Business Event? 353
Business Events System (BES) 354
An Example: Converting Existing Workflow 355
Best Practices 358
Workflow Builder: Design Time 359
Performance Considerations 361
Deployment Considerations 362
Summary 363
12 Oracle XML Gateway
XML Gateway Main Components Explained by Example Practical Examples 378
Example of Creating an Inbound Message 378
Example of Creating an Outbound Message 395
Message Monitoring and Debugging 406
Summary 409
13 Moving AOL Objects Between Instances
Brief History: Before FNDLOAD 412
Basics of FNDLOAD 412
Advantages of FNDLOAD 413
FNDLOAD Command 414
Understanding the Loader Configuration (LCT) File
Using FNDLOAD for Non-AOL Objects 421
Using FNDLOAD: Best Practices 422
Summary 423
14 Integration Between E-Business Suite and SOA
Integration Through Oracle Adapter for Oracle Applications An Example of Exposing a Business Event to SOA Example Process Overview and Required Software Step-by-Step Walkthrough 428
New SOA Enabling Features in Release 121 Subscribing an External Web Service to a Business Event Oracle Integration Repository Enhancement in R121 Summary 441
15 SQL Performance Coding Guidelines
SQL Coding Guidelines 446
SQL Processing Overview 447
Overview of Cost Based Optimizer (CBO) 448
SQL Tuning Tools 454
SQL Coding Guidelines 459
SQL Tuning Tools: Common Signs of Inefficiency Summary 466
Index
تعليقات
إرسال تعليق