Shulou(Shulou.com)06/01 Report--

This article shows you how to study EBS MOAC in depth. The content is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

I hope you have read the article Multi Org in EBS R12. When we are thinking about Multi Org in R12, there are always some questions that come to mind. The best analysis of these problems is to open the package MO_GLOBAL. Don't worry, you haven't installed R12 yet. MO_GLOBAL has been available since 11.5.10. Let's start now.

How is CLIENT_INFO replaced in R12?

Let's give an example first.

In versions prior to R12, you created the table PO_HEADERS_ALL by

a. Create a table on PO Schema and name it PO_HEADERS_ALL

b. Create a synonym (synonym) PO_HEADERS_ALL on APPS schema that points to PO.PO_HEADERS_ALL

c. Create a view PO_HEADERS on APPS schema: "select * from po_headers_all where org_id=client_info"

But in R12, the following things will happen:

a. Create a table on PO Schema and name it PO_HEADERS_ALL

b. Create a synonym (synonym) PO_HEADERS_ALL on APPS schema that points to PO.PO_HEADERS_ALL

c. Another synonym (synonym) is created in APPS: PO_HEADERS, pointing to PO_HEADERS_ALL

d. By using MO_GLOBAL.ORG_SECURITY, row-level security is applied to PO_HEADERS.

This can be reconfirmed by running SQL select * from all_policies where object_name='PO_HEADERS'

e. The impact of this strategy is that whenever you visit PO_HEADERS, Oracle RLS dynamically extends WHERE conditional statements, such as

SELECT * FROM PO_HEADERS WHERE EXISTS (SELECT 1 FROM mo_glob_org_access_tmp oa WHERE oa.organization_id = org_id)

Please also refer to the * * below.

Does this mean that if I create a new customized table, I will apply RLS [Row Level Security] to this table?

Yes, that's right. If this table contains data distinguished by ORG_ID, it should be like this. In this example, all you have to do is assign the function MO_GLOBAL.ORG_SECURITY in the package to those tables / synonyms / views.

Will Multi Org's RLS [Row Level security] also be applied to tables / synonyms / views?

In theory, RLS can be applied to any of these objects, but in practice, you will only apply RLS to objects in APPS Schema, which means that you are most likely to apply RLS to synonyms. Basically, the Multi Org view has now been replaced by RLS-protected synonyms, but when accessing the pre-R12 Multi-Org security view, we don't need to modify the existing code. Now, the responsibility for secure access to data based on ORG_ID depends on RLS [also known as VPD-Virtual Private Database].

I have made some changes to my Multi Org Security Profile by attaching a new Org hierarchy. Do I need to run any other programs?

As we did in HRMS, it is recommended to run the program "Security List Maintenance" after making any changes on Security Profiles

What is MO_GLOBAL.INIT?

The purpose of mo_global.init:-

It determines whether a new Multi Org Security Profile method is used by checking whether the new Security Profile is set.

If a new MO security profile is set, mo_global.init inserts a new record into table mo_glob_org_access_tmp for each organization in Org Hierarchy

When and where was mo_global.init called?

This method will be called immediately after you log in or switch responsibilities. Just as FND_GLOBAL.INITIALIZE is called, it is safe to determine that Oracle will call MO_GLOBAL.INIT after FND_GLOBAL.INITIALIZE

Is mo_glob_org_access_tmp a global temporary table (global temporary table)?

Yes, when the Multi Org in your session is initialized, your session will have X records in the table mo_glob_org_access_tmp. X represents the number of organizations assigned to MO Security Profile [view organizational hierarchy or list of organizations in security profile]

What is the purpose of MO_GLOBAL.ORG_SECURITY?

The purpose of Row-Level-Security is to hide some data [based on some conditions]. RLS is implemented by extending where conditional statements on security objects.

1. The function of MO_GLOBAL.ORG_SECURITY is to return WHERE conditional statements.

two。 This where conditional statement will be extended to tables / synonyms / views that have Multi Org row-level security enabled

What is the purpose of MO_GLOBAL.SET_POLICY_CONTEXT?

This procedure has two parameters

P_access_mode

When you want your current session to work on only one ORG_ID, type "S"

Type "M" when you want your current session to work only on multiple ORG_ID

P_org_id

Required only if the value of p_access_mode is "S"

In SQL*Plus, I want to set session for a specified Org [single Org]. What should I do in R12?

SQL > > exec MO_GLOBAL.SET_POLICY_CONTEXT ('Scripture dint 101)

In the above example, ORG_ID 101 will be assigned to your current session.

Inside, when you Context your individual org, the blue code will be executed: dbms_session.set_context ('multi_org2',' current_org_id', 101)

* if the current database session is initialized to a single Org [as in the step above], then the Where statement extended to the object on the row-level security (Row-Level-Security) will be

WHERE org_id = sys_context ('multi_org2','current_org_id')

Why do I use MO_GLOBAL.SET_POLICY_CONTEXT as an application technician?

Let's assume that you want to create an invoice by calling API under ORG_ID 101, but this API does not have a parameter to Org_id, so you can do this:

A. E executes MO_GLOBAL.SET_POLICY_CONTEXT ('sparring dint 101)

b. Call Invoice API, which will internally read ORG_ID. Context from the current MO context (Context).

In SQL*Plus, I want to simulate a login to a specified responsibility. What should I do?

a. Call FND_GLOBAL.INITIALIZE

This will set up your responsibilities ID, user ID, etc. (responsibility id, user_id)

b. Call MO_GLOBAL.INIT

This will read the value of the MO configuration option in your responsibility / user and initialize multi-organization access (Multi Org Access).

The above content is how to study EBS MOAC deeply. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.