Month: September 2011

MOAC – DRIVING EFFICIENCIES IN TRANSACTION PROCESSING By David Barnacle Bsc(Hons) ACMA

In release 12, an exciting new feature was introduced across the sub ledgers and it was called Multi-Org Access Control or MOAC.
A lot of our customers have followed Oracle’s lead and adopted shared service centres (SSC). In these centres, to drive down costs in processing business transactions, the back-office functions (financial and administration) have been consolidated. For example a shared service centre in a single country could deal with all the processing expenses across Europe, or even the world. SSC models are increasingly being used in the Public sector in an attempt to be more efficient, and to push down the cost of daily transactions.

You may not have implemented a formal shared service centre, but you can still reap the benefits from Multi-Org Access Control.
Multi – Org architecture was introduced in version 10.7 to allow businesses with complex enterprise structures, often over many countries, to conduct their business transaction in a single Oracle database instance. Financial transaction in the sub ledgers were secured by operating units, and users gain access to each operating unit via a different responsibility. If a user needed to process transactions in a new operating unit, then they would need another responsibility.

MOAC allows companies to gain processing efficiencies because users can more easily access, process and report on data across multiple operating units from a single responsibility without compromising data security or system performance. For example, an order processing clerk can open one sales order form and then process orders for all countries without the need to switch responsibilities or data entry forms.

The following diagram summarises the set up and processing steps for using MOAC.

moac diagram

In the Human Resource responsibility, you can define a new security profile and assign to this new profile all the operating units needed for a responsibility to access. To make this new security profile available, you then must run the HR report called ‘Run Security list Maintenance’. The new security profile is then attached to a responsibility by the new profile option called ‘MO: security Profile’.

A number of reports and forms have been enhanced to allow cross – organisational reporting. Multi – org preferences allows the user to control and limit the number of operating units they have access to, based on their work environment.

The MOAC feature delivers the following benefits:

1. Reduce setup and Maintenance of many responsibilities

2. Speed up data entry

3. Obtain a global consolidated view of information

4. Process data across multiple operating units from a single responsibility

5. Increase operational efficiency and reduce transaction processing costs.

The setup and use of MOAC is covered in the OU course R12.x Oracle E-Business Suite Essentials for Implementers. The course also covers common setup components such as Flexfields and is the prerequisite course for any follow on application fundamentals course. The course content is also tested in the first examination of the e-business certification program.

About the Author:

David Barnacle
David Barnacle joined Oracle University in 2001, after being the lead Implementer, of a very successful European rollout of the e-Business suite. He currently trains a wide family of applications specializing in the supply chain and financial areas. He enjoys meeting students and likes to learn how each Customer will configure the software suite to meet their own challenging business objectives.

Interesting Error

We just upgraded one of our 10.2.0.3 dbs to 11.2.0.2 plus some patches.  Today an interesting ORA-07445 was thrown to the alert.log:

ORA-07445: exception encountered: core dump [__intel_new_memcpy()+382] [SIGILL] [ADDR:0x3FE5CAE] [PC:0x3FE5CAE] [Ille…

world clock

with z as (
select
distinct
tn.tzname as “timezone”,
cast(
from_tz(
cast(sysdate as timestamp),
dbtimezone
) at time zone tn.tzname
as date) as “time there”
from V$TIMEZONE_NAMES tn
)
select
“time there”,
listagg(“timezone”, ‘, ‘) within group (order b…

Oracle Database Appliance

Hardware and Software Engineered to Work Together
自从Oracle收购了SUN,不仅仅得到了MySQL,Java,Solaris等,还得到了SUN的硬件产品,真正成为了一家软硬通杀的服务提供商。这几年,接连推出了基于SUN的硬件产品打造的数据库一体机Exadata X2,中间件一体机Exalogic等等,更是将软硬件结合的思路发挥到了极致。其中最郁闷的非HP莫属,从原来的合作伙伴到竞争对手,Exadata采用SUN的硬件,Oracle抛弃安腾处理器,甚至CEO都跳槽去了Oracle。
最近,Oracle推出了廉价的数据库一体机ODA(Oracle Database Appliance),这个产品同样是软硬件结合战略下的产物,目标是为中低端用户提供廉价,简单,高可用的数据库一体机,并与Exadata形成高低搭配,Exadata与小型机和高端存储竞争,ODA则占领使用PC服务器的中低端市场。
我们来看看这个机器的硬件特点:

Oracle在4U的空间内,搭建了一个两节点的RAC系统。其中内置了两个配置双路X5675CPU+96G内存的服务器,共享20块600G SAS磁盘,4块73G的SSD,内置万兆交换机用于RAC节点互联(Exadata的节点互联是采用Infiniband)。其中SSD用于存放redo log,提升性能。

Oracle的最大特点是软硬件结合,这套系统使用Oracle Linux,Oracle database 11gR2 RAC,以及专门用来配置和管理的Appliance Manager,用来提升管理性和易用性。
使用ODA与用户自己使用PC搭建数据库相比,用户无需购买SAN存储和万兆交换机,就可以实现一套高可用的RAC系统。软硬件一体机的另外一个最大的特点就是配置简单,即插即用,Oracle帮你搞定一切。不过,这个优点在有些用户看来也许是缺点,因为不够灵活,黑盒子不够透明等等。
但是,对于大部分用户而言,简单,易管理,高可用就是最基本的要求,看来ODA还是挺符合这些需求的。当然,价格也是一个重要因素,ODA的目标用户应该都是中小型用户,不差钱的用户通常都会买小型机,高端存储或者Exadata,如果定价合理,相信还是有很大的市场的。
有一点值得注意,ODA将整套系统全部封装在一个盒子里,无形中增加了风险,在异常情况下可能会导致整个系统不可用,比如断电或存储损坏等等。所以,考虑到可用性的问题,一套肯定是不够的,至少要再买一套做DataGuard。不过,这样做代价就有点高了,考虑到ODA肯定比自己买PC服务器贵,可以考虑自己购买PC来做DataGuard,降低使用成本,提升可用性。
–EOF–

EXISTS

Most of us know the SQL keyword EXISTS as the condition with a subquery you use in a WHERE clause. But if you look at the documentation of EXISTS, you’ll see that it says nothing about just using it in a WHERE clause. It’s just a sort of function that accepts a query as input and returns "TRUE if a subquery returns at least one row". The SQL language doesn’t know about booleans, but it calls

EXISTS

Most of us know the SQL keyword EXISTS as the condition with a subquery you use in a WHERE clause. But if you look at the documentation of EXISTS, you’ll see that it says nothing about just using it in a WHERE clause. It’s just a sort of function that accepts a query as input and returns "TRUE if a subquery returns at least one row". The SQL language doesn’t know about booleans, but it calls

Ksplice in action

On July 21, 2011 Oracle announced that it has aquired Ksplice. With Ksplice users can update the Linux kernel while it is running, so without a reboot or any other disruption. As of September 15, 2011 Ksplice is available, at no additional charge, to new and existing Oracle PremierSupport customers on the Unbreakable Linux Network […]

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569