oracle r12 创建同义词,Oracle_R12_MOAC介绍及应用.doc

Oracle_R12_MOAC介绍及应用

EBS R12 MOAC原理探索

Document Control

Change Record

3

DateAuthorVersionChange Reference21-May-08Draft 1aNo Previous Document

Reviewers

NamePosition

Distribution

Copy No.NameLocationLibrary MasterProject LibraryProject Manager

Note To Holders:

If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes.

If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.

Contents

Document Controlii

1.MOAC介绍和配置2

1.1.MOAC背景2

1.2.多OU使用配置5

2.MOAC内部实现10

2.1.过程概述10

2.2.po_glob_org_access_tmp表的分析11

2.3.MO_GLOBAL包的分析16

2.4.VPD介绍和使用实例21

3.技术实施要点28

3.1.环境初始化28

3.2.并发请求30

3.3.Form开发30

4.附录31

4.1.VPD实例源码31

4.2.参考文档34

5.WhOpen and Closed Issues for this Deliverable35

Open Issues35

Closed Issues35

MOAC介绍和配置

MOAC背景

概述

MOAC(Multi-Org Access Control)中文简称为多组织访问控制，是ebs R12的重要新功能，其目标是:使用安全性控制文件实现在一个职责类对多个OU进行操作。这句概括可能有些模糊，但一开始说多了会更模糊，本文的重点在于整理MOAC的内部流程和实现过程。

业务需求

一个老外的Blog例子，个人觉得蛮不错

Business Reason for this change Four years ago, I was tasked to design a Payables Invoice scanning process that had following requirements:

My client had 100s of legal entities and organization units.

They wanted to receive all paper payables invoices at a central location n.Effectively, they would have a single Address where invoices for all the Legal entities /Operating Units were received.

All the invoices would be scanned at that central location.

The scanned images were then placed in a queue that were? then keyed(typed) into the system by Bangalore Team(their shared servicecentre)

Here lies the issue:-

Scanned Invoices had ?o be first sorted per operating unit. Why? Because, there was different "Payables Clerk" responsibility for each operating unit. The poor clerk had to switch responsibility depending upon which operating unit the invoice was