Oracle
Oracle E-Business Suite Outsourcing Notes PDF Print E-mail
Wednesday, 27 August 2008 11:01

Oracle Applications, in the eve of Oracle Fusion, is very efficient platform for being supported remotely, sometimes referred as offshore, nearshore or outsourced. The majority of Oracle E-Business clients have basic set of modules, also referred as Oracle Financials. Let’s take a look at outsourcing options and pitfalls.

• Central Worldwide database. This is ideal scenario, however in real world Oracle EBusiness Suite might be spread over across several regional servers. In any case, web client interface provides “remote connection” to Oracle EBS users and administrators. Natural way to include Oracle consulting company into the same group

• Multinational Corporation. As its name reads – it deals with international business practice and has to tune Oracle Applications to local or regional specifics, often referred as localizations. Localization usually has two aspects: fiscal compliance and language support. As corporation penetrates to large country – fiscal compliance part of localization usually becomes the first priority. Very good example is Brazil. It has federal, state and local municipal taxation. For Brazil worldwide outsourcing partner has to coup with one of local Brazilian Oracle partners, who should implement and support Brazilian localization

• Reporting. This one of the most promising Oracle outsourcing directions. Report is very formalized by its nature and it is relatively simple to find “report designer”, who will create the report according to your specs and will ask clarification questions if needed. Majority of Oracle reporting tools: Oracle Reports, Oracle Discoverer, Oracle XML Publisher, RXi Report, FSG Reports, Business Intelligence System are good candidates

• Extension Development. Oracle customizations are often referred as extensions. Also extensions are compared with modifications, where modification is the change to standard Oracle EBS database and extension is preferred way to go

Please do not hesitate to call or email us: USA/Canada: 1-866-528-0577, 1-630-961-5918, Europe: +44 20 8123 2580, +45 36 96 55 20, Mexico: 52-55-535-04027 This e-mail address is being protected from spambots, you need JavaScript enabled to view it

Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.ronix-systems.de http://www.enterlogix.com.br ) - Microsoft Business Solutions Great Plains, Navision, Axapta MS CRM, Oracle Financials and IBM Lotus Domino Partner, serving corporate customers in the following industries: Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally.

We are serving USA Nationwide: CA, IL, NY, FL, AZ, CO, TX, WI, WA, MI, MA, MO, LA, NM, MN, Europe: Germany, France, Belgium, Poland, Russia, Middle East (Egypt, Saudi Arabia, OAE, Bahrain), Asia: China, Australia, New Zealand, Oceania, South & Central America: Mexico, Peru, Brazil, Venezuela, Colombia, Ecuador, Chile, Paraguay, Uruguay, Argentina, Dominican Republic, Puerto Rico

 
Reporting Oracle E-Business Suite: Database Schemas PDF Print E-mail
Monday, 16 June 2008 09:00

Oracle Reports, Oracle E-Business Suite, Oracle Applications, Oracle Database Schemas

The Oracle E-Business Suite, also known as Oracle Applications or Oracle Financials, has close to 25,100 tables and 33,000 views on its database. One of the main issues for Oracle E-Business suite reports development is to find the right data in so many available objects. In this article we are going to discuss how Oracle has organized its database to make developers´ life easier.

A database schema determines the ownership of the products´ database objects. Oracle has separated each product of Oracle E-Business suite in one schema. For example, the module Bill of Materials has a code id ‘BOM’ and a named schema with the same name as its code id, in this case BOM. Each Oracle E-Business suite module has a default Oracle database user id, with the product abbreviation as name of the database schema. There is one “main schema”, called APPS, with a user also called APPS, which has privileges to access most of the objects from any schema.

The APPS schema owns procedures, triggers, functions, packages, views and materialized views and has permission to access tables, indexes, sequences and constraints from other schemas (products). The APPS schema improves the reliability over Oracle E-Business database and reduces the time needed for installation, upgrade, and patching by eliminating the need for cross-product grants.

Once APPS user has permissions to access all the objects that are part of Oracle E-Business Suite, developers should be connected to the database as APPS user (in a test instance) to produce their reports. Oracle also has helped developers by creating standards on database objects naming. All objects names starts with the abbreviation of the product. For example, the purchasing product has ‘PO’ as its abbreviation and all Purchasing objects start with ‘PO_’.

Finding the data that you need in more than 50,000 objects is not an easy job. Knowing the naming standards of the objects and how they are storage facilitates developers’ life. Oracle has also made available an Electronic Technical Reference Manual that has information about all the objects in all schemas. It can be accessed on line at http://etrm.oracle.com (metalink access needed) and it provides a very good help to find the data that you need. Our company is specialized on Oracle E-Business suite customizations; if you need service in this area we will be glad to help.

Give us a call 1-866-528-0577, 1-630-961-5918 or This e-mail address is being protected from spambots, you need JavaScript enabled to view it if you need additional information or directions.

Author is technical consultant at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.greatplains.com.mx http://www.ronix-systems.de ), serving clients in Illinois, California, Texas, New York, Florida, Louisiana, Georgia, New Jersey, Washington, Pennsylvania, Ohio, Michigan, Wisconsin, Arizona, Nevada, and having locations in Brazil, Colombia, Chile, Argentina, Germany, Mexico

 
Oracle Discoverer: A Reporting and Decision Support Tool for Oracle E-Business Suite PDF Print E-mail
Monday, 16 June 2008 01:00

Oracle Applications, Oracle E-Business Suite, Oracle Financials, Oracle Reports, Oracle Discoverer

Oracle Discoverer is a business intelligence tool to support organizational decisions. It uses a repository called EUL (End User Layer) which is based on information stored and controlled by transactional applications. The main EUL goal is to hide details and complexity of a transactional database, organizing data to reflect the company specific business areas, making all data queries faster and easier.

Oracle E-Business Suite (EBS - also known as Oracle Applications and sometimes called Oracle Financials) has a BI module with an EUL mapped from Oracle EBS transactional data, which permits Oracle Discoverer to be used as a decision support tool for information stored into Oracle EBS database.

By using Oracle EBS security schema, which uses responsibilities to control access rights, Oracle Discoverer shows its repository in a user friendly way, using folders for each business area, listing all items that you can select for a query.

When you select an item for a query, all items that don’t have relationship with this first selected item will be disabled for selecting because every relationship and dependencies are mapped through EUL.

All Oracle Discoverer queries can be viewed in a tabular or matrix formats, allowing the definition of data fields (items) at the header of a report. This is used to filter the result set of data to be shown. There are many data format functions and it is possible to change the reports layouts, allowing conditional format of characters fonts and colors for each column of data. Besides this features, you can change columns positions, order and group data dynamically.

Oracle Discoverer can be executed by a local desktop software installation (Oracle Discoverer Desktop Edition) or using a browser via web (Oracle Discoverer Plus). Additionally you can export the reports for Html files, Microsof Excel and other file formats.

All of these characteristics make Oracle Discoverer a powerful and useful tool for Oracle E-Business Suite reporting, beyond Oracle Reports and XML Publisher, each one with its features and benefits.

If your company has specific business requirements that are not totally satisfied by Oracle EBS reports, please give us a call: 1-866-528-0577, 1-630-961-5918 or This e-mail address is being protected from spambots, you need JavaScript enabled to view it

Author is technical consultant at Alba Spectrum Technologies ( http://www.albaspectrum.com http://www.greatplains.com.mx http://www.ronix-systems.de ), serving clients in Houston, Chicago, Dallas, New York, Miami, Atlanta, Washington, Boston, Minneapolis, Phoenix, San Francisco, Millwaukee, Los Angeles, Seattle, Denver, Detroit, San Diego, and having locations in Brazil, Colombia, Chile, Argentina, Germany, Mexico

 
<< Start < Prev 1 2 3 4 Next > End >>

Page 1 of 4