Wednesday, August 3, 2011

Multi Org Structure

Major implementation projects usually includes complex organizational structures like having different hr groups or different ledgers etc.
Oracle. And different scenarios may occur like; a person accesses data in a different company or doing work of a different company. To manage these kind of complex structures Oracle offers a hierarchical structure and Multi Org Access Control setups:
Business groups
Primary ledgers
Legal entities
Operating units
Inventory organizations

Detailed information about multi org structure in Oracle below documents can be examined:
Multi Org Access Control (MOAC) in Oracle Purchasing [ID 397362.1]
Oracle® E-Business Suite Multiple Organizations Implementation Guide Part No. E13423-03

Oracle Enterprise Manager

Lastly i have seen the usage of Enterprise Manager for EBS performance management, it provides a GUI for maintaining database activities.

Then i made a little research and saw the below information in Oracle's internet site.

"It' s usage is not limited to applications management the list is below;
Application management,
Middleware management,
Database management,
Hardware management,
Heterogeneous management,
Application performance management,
Lifecycle management,
Configuration and change management,
Application management

The benefits listed in the site is below also;
*149% ROI for IT Management Investments—Manage the entire Oracle stack using a single console, eliminating unnecessary tools.
*Faster transactions, better user experience—Improve business performance with a unique solution encompassing real user experience management, business transaction management, and business service management. Learn more about Business-Driven Application Management.
*Prevent 80% of customer problems—Be more proactive than even before. Manage your IT, interact with Oracle on support-related issues, exchange ideas and learn from your peers at other companies, and implement recommendations and fixes – all within a single console. Learn about integrated systems management and support."

Warning eMails

To control critical issues and secure the environment emails are used very often. To send an email via Oracle there are various methods; workflow, trigger or alert. Alerts play an important role because they can be easily defined by technical or functional consultants though it has the disadvantage limited ability. For example alert mails have a plain format and does not offer options. On the other hand it provides some flexibility such as; periodic or event alert, alert action levels. Periodic alerts check the query and takes the required action though event alerts take action at the moment of event (Work like a trigger). Alert action levels are listed below for an example and defines the resulting actions of alert;

Ex1: (From 11i eBusiness Suite Instructer Guide)
"Inform the account manager of invoices on hold" alert
• Detail Action: Send a separate e-mail message for each invoice that meets the search
criteria of invoices on hold.
• Summary Action: Send a single e-mail message listing all invoices that meet the search
criteria, or send one summary for each vendor.
• No Exception Action: Send an e-mail message stating that nothing in the database is on
hold.

summary example:
Invoice Number Hold Type Hold Reason
=**= Enter summary template below this line =**=
**&Invoice_Number &Hold_Type &Hold_Reason
=**= Enter summary template above this line =**=

Ex2: "Indexes near maximum extents" alert can be checked for a relevant example; it sends a list of indexes near maximum extents as summary or sends an email stating that there is no index near the maximum extent.