Binoy Kumar

________________________________________ Scope : i) The passed UAT server E-Business Suite to be cloned. ii) The Apps Tier and DB Tier to be separated. Precloning Steps on the UAT server E-Business Suite to be cloned. 1. Startup 1.1 Start Database Tier 1.1.1 Login as database tier user – sys as sysdba 1.1.2 Set environment variable by running $SID_hostname.envfrom $INSTALL_BASE/db/tech_st/11.1.0 —- cd /u01/oracle/PNGRB/db/tech_st/11.1.0 —- . PNGRB_apps.env (note: dot in front) 1.1.3 Start database —- sqlplus “/as sysdba” —- SQL> startup 1.1.4 Start Database Listener (lsnrctl start $SID) —- lsnrctl start PNGRB . 1.2 Start Application Tier 1.2.1 Login as application tier user - apps 1.2.2 Set environment variable by running $SID_hostname.envfrom $INSTALL_BASE/apps/apps_st/appl —- cd /oracle/PNGRB/apps/apps_st/appl —- . PNGRB_apps.env (note: dot in front) 1.2.3 Start Application Tier (adstrtal.sh apps/$apps_password) —- cd $ADMIN_SC...

Since Oracle EBS or E-Business Suite is a complete automated application and caters the need of variety of industries. It has an architecture called MultiOrg or “Multiple Organization”. Whenever we talk about an organization irrespective of its multiple structure, we will find certain common things or feature or let me call it departments. It is not necessary that every organization has every department. But some departments and/or processes are more or less the same. What is an Organization? In EBS it is a vague term, infact, varied term. In Oracle EBS an organization can be a Legal Entity, or an Inventory, or a department. Anything can be treated as organization in Oracle. When we go through the Oracle EBS documentation we will find the excessive use word Organization. But it not the organization we refer it to here in daily routine. In our daily routine if we say the word “organization”, we will certainly be referring to some company, for example, Inbox Business Technologies, ...

Database Replay workload capture of external clients is performed at the database server level. Therefore, Database Replay can be used to assess the impact of any system changes below the database tier level such as below:      Database upgrades, patches, parameter, schema changes, etc. Configuration changes such as conversion from a single instance to RAC etc. Storage, network, interconnect changes Operating system, hardware migrations, patches, upgrades, parameter changes         DB replay does this by capturing a workload on the production system with negligible performance overhead( My observation is 2-5% more CPU usage ) and replaying it on a test system with the exact timing, concurrency, and transaction characteristics of the original workload. This makes possible complete assessment of the impact of the change including undesired results; new contentions points or performance regressions. Extensive analysis and reporting ( AWR , ADDM report and DB replay report) is provided to ...

-Multi-Org Access Control feature allows you to enter, process data and generate reports from a single responsibility. -This is achieved by providing the Operating Unit field on the forms/pages and while running the concurrent processes. -To Set this feature you need to define the security profile containing operating units and set it at MO: Security Profile. -You can default the Operating Unit on forms/pages by setting the MO: Default Operating Unit profile. 1) Business Grou p (Which dealt with HRMS Module) It is the Higest level in the ORG structure. 2) Legal Entity ( Dealt with Tax entities, Govt reporting authorities) 3) Set of Books ( Dealt with 4 C's that is Chart of Account, Currencies and Calender, Accounting Convention) 4) Operating Unit (Dealt with 5 sub ledger modules by name AP/AR/GL/PO/OM 5) Inventory Organization (Dealt with INV/BOM/WIP/MS_MRP) You can assign any no. of Organization under a Operating Unit.

MO_GLOBAL Package MOAC functionality is provided through the MO_GLOBAL package (AFMOGBLB.pls).  Following are some of the more important functions and procedures in the package. Init () This is generally called by forms and reports to setup the list of orgs that can be accessed.  It calls the set_org_access procedure, which in turn calls populate_orgs.  This inserts the orgs a user is allowed to access in a global temporary table -- MO_GLOB_ORG_ACCESS_TMP.  The table is populated based on the MO: Security Profile and MO: Operating Unit profile option values. Org_security() This returns a sql predicate (where clause) that controls which records can be accessed.  Example: EXISTS (SELECT 1                     FROM mo_glob_org_access_tmp oa                     WHERE oa...

Here is a list of security enhancement features: Column-Level VPD - Virtual Private Database (VPD) is now finer grained. You are now able to enforce VPD rewrite when a query references a particular column. VPD Static and Dynamic Policies - Virtual Private Database (VPD) now lets you distinguish between static policies, which are suitable for hosting environments that always need to enforce an unchanging policy, and dynamic policies, which are suitable for time-dependent enforcement, such as time of day, where rows returned must vary at a particular time. Fine-Grained Auditing (FGA) on DML - Fine-Grained Auditing (FGA) extends the support to include UPDATE, INSERT, and DELETE statements. Virtual Private Database Virtual Private Database (VPD) was first introduced in Oracle8i. It set a new standard in database security, being built into the database server, instead of each application accessing the data. Security is no longer bypassed when a user accesses the ...

Oracle uses two types of histograms for column statistics: height-balanced histograms and frequency histograms. The type of histogram is stored in the HISTOGRAM column of the *TAB_COL_STATISTICS views (USER and DBA). This column can have values of HEIGHT BALANCED, FREQUENCY, or NONE. In a height-balanced histogram, the column values are divided into bands so that each band contains approximately the same number of rows. The useful information that the histogram provides is where in the range of values the endpoints fall. In a frequency histogram, each value of the column corresponds to a single bucket of the histogram. Each bucket contains the number of occurrences of that single value. Frequency histograms are automatically created instead of height-balanced histograms when the number of distinct values is less than or equal to the number of histogram buckets specified. Frequency histograms can be viewed using the *TAB_HISTOGRAMS views.