Tuesday, 15 December 2015

Multi Org Concept



Introduction
Any enterprise has several organization structures. These organizations interact with each other for various purposes. While interacting with other organizations data has to be secure and should be transferred to the correct organization.
What is Multi Org
Multi Org is a feature, which helps us to classify and define various organizations in such a way that hierarchy is maintained and data is secure across organizations. It also decides how transactions flow through different organizations and how those organizations interact with each other.
The various organizations that can be defined within Oracle Applications are as follows:
Business Group. The business group represents the highest level in the organization structure, such as the consolidated enterprise, a major division, or an operation company. Oracle Apps provides with a predefined Business Group ‘Setup Business Group’. Reliance Group of Companies is an example of Business Group.
GRE/Legal Entity. The company for which we prepare tax returns. You assign tax identifiers and other legal entity information to this type of organization. If there are several subsidiary companies for which tax returns are filed, each company is a separate legal entity. Reliance Group of Companies consists of several companies like Reliance Industries ltd, Reliance Info-comm, Reliance Energy ltd etc. Each company is a separate Legal Entity.
Note: The Set of Book can contain multiple Legal Entities.
Operating Unit. Each group company will have several branch offices involved with purchasing, order management, shipping execution etc. Each such branch will be an Operating Unit.
It could be a sales office, a division, or a department. An operating unit is associated with a legal entity.
For implementing Oracle Cash Management, Order Management and Shipping Execution, Oracle Payables, Oracle Projects, Oracle Purchasing, Oracle Property Manager, Oracle Receivables and Sales and Marketing Operating Unit is required.
Information is secured by operating unit for these applications. Each user sees information only for their operating unit.
Inventory Organization. An organization for which you track inventory transactions and balances, and/or an organization that manufactures or distributes products. Inventory organization is generally assigned to a manufacturing plant. An operating unit can also be an Inventory Organization. Many branches (operating units) might be Manufacturing Plants and will be attached to an Inventory/Warehouse. Such inventory/warehouses will be Inventory Organizations.
HR Organization. HR organizations represent the basic work structure of any enterprise. They usually represent the functional management, or reporting groups that exist within a business group.
Asset Organization. An asset organization is an organization that allows you to perform asset–related activities for a specific Oracle Assets corporate depreciation book. Any organization (legal entity, operating unit, inventory organization), which has Fixed Assets can be classified as Asset Organization. For implementing Oracle Assets, this type of organization is used.

Secure Access within Multi Org
An individual Operating Unit is assigned to an individual application Responsibility. To see and work with data that is relevant to a specific Operating Unit, users choose the appropriate Responsibility after logging on to Oracle Applications.
The current Multi-Org architecture utilizes database objects like Views to build a security layer that allows you to logically partition all your application data in one database, instead of physically partitioning data with multiple instances and even multiple application installations.
In earlier versions of Oracle Applications data partitioning was done using multiple instances and therefore installation had to be done several times for various operating units.
Note: All Multi Org tables in the database will be suffixed with ‘_ALL’.
HRMS Organization Model

The business group is the largest organization unit you set up in Human Resources to represent your enterprises as an employer. After defining one or more business groups for your enterprise, you set up one or more Government Reporting Entities (GREs) within each business group. The GRE is the organization that federal, state, and local governments recognize as the employer.
Needless to say, HR does not require Operating Units, Inventory Organization and Asset Organization.


The following are the summarized steps for implementing Multi-Org in Oracle Applications or when converting from a Non Multi-Org environment to a Multi-Org environment.
1.1 Develop an Organization Structure
1.2 Define Set of Books
1.3 Define Locations
1.4 Define Business Groups (Optional)
1.5 Define Responsibilities
1.6 Associate Responsibilities with Business Groups
1.7 Define Organizations
1.8 Define Organization Relationships
1.9 Set MO: Operating Unit Profile Option
1.10 Convert to Multi-Org Architecture
1.11 Define Inventory Organization Security
1.12 Define Inter-company Relations
How to set Org_id at back-endWe have a API to set the org_id from the backend.

begin
fnd_client_info.set_org_context();
end;

Note:- Org_id indicates the "Operating Unit" in the Business Structure.

How to I know what Org_id is set at back-end

We can use userenv function to know the Org_id set at backend.

select userenv('CLIENT_INFO') from dual;

Why we need to set org_id at back-end

We usually, set org_id at back-end. So that we can get the org_id records from the Multi Organization views.

What happens if I try to query records from Multi-Origination views without setting Org_id at back-endIt will not fetch any records. As, "where" condition fails (org_id = Userenv('CLIENT_INFO'));

Note:- If you set org_id from back-end, then you get org_id value populated by above userenv function.

Is this Multi -Org concept is same for all the Oracle Application versionsNo. Above Technical points are applicable only till 11i version. It is different in Release 12.

Thanks
Srini

Tuesday, 8 December 2015

Re: how to set the init-param debug_mode to "true"

To clarify: Edit

form database side
$ORACLE_HOME/oc4j/j2ee/OC4J_SEARCH/config/global-web-application.xml

...  /j2ee/home/config

In the section <servlet><servlet-name>jsp<...

Add an "init-param" section so it looks like this:

< servlet>
< servlet-name>jsp</servlet-name>
< servlet-class>oracle.jsp.runtimev2.JspServlet</servlet-class>
< init-param>
< param-name>debug_mode</param-name>
< param-value>true</param-value>
< /init-param>
< !-- you can set main_mode to "justrun" to speed up

Then restart the midtier using "searchctl restart"

Don't leave this on for production - sometimes it can reveal database passwords!

Thanks
Srini

Monday, 7 December 2015

Oracle E-Business Service Suite Release 12 ITIL Solution (Doc ID 850485.1)



Applies to:

Oracle Customer Support - Version 12.0.0 and later
Oracle Teleservice - Version 12.0 and later
Information in this document applies to any platform.
Checked for relevance on 01-MAY-2012


Abstract

Oracle E-Business Service Suite Release 12 is ITIL certified by Pink Elephant through the PinkVerify™ program in four process areas:
• Incident Management
• Problem Management
• Service Asset and Configuration Management
• Change Management
The focus of this paper is on how Oracle E-Business Service Suite can help organizations achieve their goals in the four ITIL processes for which the Suite is verified compliant by Pink Elephant.

Details

Reducing cost while improving quality, customer satisfaction and aligning ITIL with business are a few of the key issues facing senior business and IT managers today. By facilitating communication through standardized processes, the ITIL (IT Infrastructure Library) framework can help bridge the gap between IT and the business community. By focusing on the standardization and discipline that ITIL emphasizes, enterprises can reduce the ongoing cost of delivering IT services while improving the quality and consistency of service. Unfortunately, the lack of an integrated solution that supports the ITIL process lifecycle has been a major inhibitor in widespread adoption. IT managers are concerned about adopting point solutions for a single ITIL process that does not seamlessly integrate well with other processes. Oracle E-Business Service Suite Release 12 provides a rich, comprehensive, and fully integrated set of features that can be used to seamlessly support ITIL processes.
Please see the attachments to this note for the complete White Paper which describes the Oracle E-Business Service Suite Release 12 ITIL Solution. Also attached is a setup document containing setups that can be used as a reference/guideline when setting up an ITIL demo for customers using Oracle E-Business Service Suite Release 12.
Oracle E-Business Service Suite Release 12 ITIL Solution
Setup Document

Thanks
Srini


Friday, 4 December 2015

How to find Components version in R12

 


Apache Version

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v


Go to reports path Then type: -

string -a APXAPRVL.rdf|grep Header

Perl Version
$IAS_ORACLE_HOME/perl/bin/perl -v|grep built


Java Version
sh -c "`awk -F= '$1 ~ /^JSERVJAVA.*$/ {print $2}' $ADMIN_SCRIPTS_HOME/java.sh` -version;"

Jre version
cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35

Forms Version
$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version

Plsql Version
$ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version

Forms Communication mode
cat $FORMS_WEB_CONFIG_FILE|grep serverURL=
echo "If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet"

How to find Apps Version
select release_name from apps.fnd_product_groups;

Web Server/Apache or Application Server in Apps 11i/R12
Log in as Application user, set environment variable and run below query $IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version
  

Forms & Report version in R12/12i
Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/rwrun | grep Release

 Oracle Jinitiator in 11i/R12/12i
 
Log in as Application user, set environment variable and run below query
grep jinit_ver_comma $CONTEXT_FILE

(Default is Java Plug-In for R12/12i )
Oracle Java Plug-in in 11i/R12/12i
A.
Log in as Application user, set environment variable and run below query
grep plugin $CONTEXT_FILE.

File Version on file system
adident Header
or
strings | grep Header
Here adident is AD Utility (Oracle Apps) and strings is Unix utility.

Version of pld file
*.pld are source code of *.pll which are inturn source of *.plx.  *.pll is in $AU_TOP/resource and to find its version check

adident Header $AU_TOP/resource/.pll
IGSAU012.pll:
$Header IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $
or
strings $AU_TOP/resource/.pll | grep -i header
FDRCSID(’$Header: IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship $’);

Workflow Version with Apps
select TEXT Version from   WF_RESOURCES where  NAME = ‘WF_VERSION’;
 
Identity Management component Version/Release Number

Oracle Single Sign On
select version from orasso.wwc_version$;
Oracle Internet Directory
There are two component in OID (Software/binaries & Schema/database)
To find software/binary version
$ORACLE_HOME/bin/oidldapd -version
To find Schema Version/ database use
ldapsearch -h -p -D “cn=orcladmin” -w “” -b “” \ -s base “objectclass=*” orcldirectoryversion 
select attrval from ods.ds_attrstore where entryid = 1 and attrname = ‘orcldirectoryversion’;

 Application Server
Oracle Application Server 10g Rel 3 (10.1.3.X)
cat $ORACLE_HOME/config/ias.properties | grep Version
Version=10.1.3.0.0 
For Oracle Application Server 10.1.2 (Prior to Oracle WebLogic Server)
If application server is registered in database (Portal, Discoverer) check from database
select * from ias_versions;
or
select * from INTERNET_APPSERVER_REGISTRY.SCHEMA_VERSIONS;
AOC4J (Oracle Container for J2EE)
Set ORACLE_HOME
cd $ORACLE_HOME/j2ee/home
java -jar oc4j.jar -version 

Oracle Portal
select version from portal.wwc_version$; 

Database Component 
To find database version
select * from v$version;
or
All component version in database
$ORACLE_HOME/OPatch/opatch lsinventory -detail
Unix Operating System
Solaris -> cat /etc/release
Red Hat Linux -> cat /etc/redhat-release
 
 
Thanks
Srini