Oracle_R12_MOAC介绍及应用.doc

EBS R12 MOAC原理探索 Document Control Change Record 3 Date Author Version Change Reference 21-May-08 Draft 1a No Previous Document Reviewers Name Position Distribution Copy No. Name Location Library Master Project Library Project 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 Control ii 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 Deliverable 35 Open Issues 35 Closed Issues 35  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 be