Category: Oracle Apps

Overview
Oracle Apps is the number one standards-based application platform that offers powerful combination of solutions and choice for enterprise business and IT Strategy. Oracle Apps is the leader among
applications associated with portfolio management, customer relationship management, human capital management etc., with lifetime support policy.

Training Objective
This section includes tutorials which aim to educate the readers about various facets of Oracle Apps. The objective of this tutorial series is to discuss features such as ERP Products, E-Business Suite, Installation, Internationalization, File System, Application Framework, Nodes, Registration API, Concurrent Process, Message Dictionary, Flex Fields, Forms, Asset Management, Reports and more…
Target Audience
Oracle Apps training provides concrete self-learning platform for beginners and will strengthen the fundamentals for intermediate database professionals.
Related Trainings

PL/SQL Tutorials
Oracle 9i Training
Oracle 10g Training
Oracle 11g Training

Oracle Reports 6i

Exforsys
Oracle Reports 6i In this tutorial you will learn about Introduction to Oracle Reports Builder, Report file storage formats, Oracle Reports Builder Tools, Report Wizard, Triggers in Reports, Types of Triggers and Case Study – Creating a Tabular report. Introduction to Oracle Reports Builder Oracle Reports Builder is a powerful enterprise reporting tool used to build reports that dynamically retrieve data from the database, format, display and print quality reports. Reports can be stored in File or Database (Report Builder Tables). Report file storage formats .rdf Report • Binary File… Read More

Oracle Apps 11i : Asset Management – Journal Entries

Exforsys
Oracle Apps 11i : Asset Management – Journal Entries In this tutorial you will learn about Journal Entries: Assets Journal Entries Flow – Oracle Assets creates journal entries for depreciation expense, asset cost, other accounts, and automatically creates general ledger transaction journal entries, if you have set up the journal entry category for that transaction type in the asset book. Journal Entries: Assets Journal Entries Flow The GL period for which you want to create journal entries must be open, The period name in the depreciation calendar assigned to the… Read More

Oracle Apps 11i : Asset Management – Retirements

Exforsys
Oracle Apps 11i : Asset Management – Retirements In this tutorial you will learn about Asset Management – Retirements; Types of Asset Retirement. – Full Retirement, Partial Retirement, Undo or Reinstate Retirements, Retiring Separately Across Depreciation Books, Reinstating Retired Assets – Reinstating with a PENDING status, Reinstating with a PROCESSED Status and Reversing a Reinstatement. Retirements 1. You retire an asset fully or partially when it is lost, stolen, damaged, sold, returned, or for any other reason that causes you to stop using it. 2. You retire assets by units… Read More

Oracle Apps 11i : Asset Management – Depreciation

Exforsys
Oracle Apps 11i : Asset Management – Depreciation In this tutorial you will learn about Asset Management – Depreciation ; a) Elements, b) Basic depreciation calculation, c) Calculate Annual Depreciation, d) Allocate Annual Depreciation across Periods, e) Spreading Depreciation across Expense Accounts, f) Methods, g) Run-Depreciation, h) Closing a Depreciation Period and i) Programs Depreciation a) Elements Define corporate, tax, and budget asset books. Define the corporate book first to associate it with multiple tax and budget books. Oracle Assets provides many standard depreciation methods. Set up additional methods if… Read More

Oracle Apps 11i : Asset Management – Mass Transfers

Exforsys
Oracle Apps 11i : Asset Management – Mass Transfers In this tutorial you will learn about Asset Management – Mass Transfers; a) Mass Reclassifications, b) Using Mass Changes and c) Mass Asset Transfers. Mass Transfers a) Mass Reclassifications Figure 1. Navigate to Mass Reclassifications. Figure 2. Create Mass Reclassifications. Figure 3. Running Mass Reclassification.(Request # 3067276 and 3067277) You can reclassify a group of assets using the Mass Reclassifications window. In addition to reclassifying assets to a new category, when you run the Mass Reclassification process, you have the option… Read More

Oracle Apps 11i : Asset Management – Asset Adjustments

Exforsys
Oracle Apps 11i : Asset Management – Asset Adjustments In this tutorial you will learn about Asset Adjustments – Single Asset Reclassification, Adjusting Units, Assigning Units, Adjusting Financial Information and Single Asset Transfers.   Asset Adjustments You can adjust an asset by reclassifying, changing the number of units, adjusting the financial information, or performing a mass change. Single Asset Reclassification Figure 1. Navigating to Single Asset Reclassification. Figure 2. Single Asset Reclassification. Reclassify assets to update information, correct data entry errors, or when consolidating categories. Adjusting Units a) You can… Read More

Oracle Apps 11i : Asset Management – Mass Additions

Exforsys
.Oracle Apps 11i : Asset Management – Mass Additions In this tutorial you will learn about Mass Additions – The Mass Addition Process, Create Mass Additions, Prepare Mass Additions, Post Mass Additions and Delete Mass Additions.   Mass Additions Mass Additions Process Step 1 Create Mass Additions : Run Mass Additions Create from Oracle Payables to copy invoice distribution lines representing potential assets into the FA_MASS_ADDITIONS interface table in Oracle Assets. Figure 1. Run the Mass Additions Create program. Step 2 Prepare Mass Additions : Use Prepare Mass Additions to… Read More

Oracle Apps 11i : Asset Management – Manual and Quick Additions

Exforsys
Oracle Apps 11i Free Training : Asset Management – Manual and Quick Additions In this tutorial you will lean about Manual and Quick Additions – Adding Assets Manually, Quick Additions, Detail Asset Additions – Using the Asset Details Window, Using the Books Window, Using the Assignments Window and Using the Source Lines Window. Manual and Quick Additions Adding Assets Manually You use Quick Additions to add assets manually. All assets added to the primary asset book are automatically converted to the reporting currencies asset books when you save transaction. Based… Read More

Oracle Apps 11i : Asset Management – Asset Books Regions

Exforsys
Oracle Apps 11i Tutorials : Asset Management – Asset Books Regions In this tutorial you will learn about various Asset Books Regions like Calendar Region, Accounting Rules Region, Natural Accounts Region, Journal Categories Region and Asset Categories Regions. Calendar Region Allow Purge : Purges data from the asset book. GL Set of Books : Enter the GL set of books for creating journal entries. Prorate Calendar : Determine depreciation rate. Current Period : Oracle Assets updates the current period field each time the current period is closed and the next… Read More

Oracle Apps 11i : Asset Management – Asset Book Positioning

Exforsys
.Oracle Apps 11i Tutorials : Asset Management – Asset Book Positioning Oracle Assets is a complete asset management solution that maintains property and equipment accurately to help you the best accounting and tax strategies. You can add, transfer, and retire assets. You can adjust for a single asset, group of assets, or financial information. Oracle assets adapts to various countries’ tax and accounting laws to accommodate fluctuating economies, unplanned depreciation, and other unforeseen circumstances. Oracle assets provides reports that you can use to inform the fixed asset manager of additions,… Read More

Oracle Apps 11i : Suppliers

Exforsys
. Oracle Apps 11i Tutorials : Suppliers One must define a supplier before performing most activities in Purchasing and Payables. Optionally enter a recommended supplier on a requisition. Need a supplier to issue a RFQ. Use the same supplier for entering a quotation. Need supplier information for POs. Receive goods or services from suppliers. Return goods to supplier. Pay the supplier for the goods or services purchased. Suppliers can be set up from many different applications, but the data is stored in only in one place. Applications sharing supplier information… Read More

Oracle Apps 11i : Creating Journals through Oracle GL

Exforsys
. Oracle Apps 11i Free Training : Journal Entry This tutorial will describe the procedure of creating journals through oracle GL – Create a new batch with multiple Journal entries, Enter Journals to a Batch and to Enter Journal Lines. Create a new batch with multiple Journal entries Create a Journal batch The following are the steps for creation of a journal batch: 1. Navigate to the enter journals window. 2. Choose New Batch. 3. Enter an optional Batch name to identify the batch on general ledger and journal entry… Read More

Oracle Apps 11i: Setting up Chart Of Accounts (COA)

Exforsys
Oracle Apps 11i Free Training : Setting up Chart Of Accounts (COA) In this tutorial you will learn how to create a Chart Of Accounts (COA), create a new value set, General Ledger – List Types, Security Types, Format Types, Validation Types, Oracle GL Segments and Create the Accounting Flexfield Structure. Setting up Chart Of Accounts Document Summary This document is a step-by-step guide to understanding and setting up Chart of Accounts and Accounting Flex Fields in Oracle Applications. To setup General Ledger for your organization, step through the following… Read More

Registering New Forms in Oracle Apps 11i

Exforsys
Registering New Forms in Oracle Apps 11i In this tutorial you will learn how to Register New Forms in Oracle Apps 11i , registering form functions, creating menu of functions and creating responsibilities. Document Summary This document describes the process of registering new forms in oracle applications. Registering a Form Navigation – Application Developer -> Application->Form Click on Form and you will see following screen. Fields Form : Enter the file name of your form (the name of the .fmx file) without extension. Your form filename must be all uppercase,… Read More

Creation of Master Detail Block in Oracle Apps 11i

Exforsys
Creation of Master Detail Block in Oracle Apps 11i In this tutorial you will learn about Creation of Master Detail Block in Oracle Apps 11i , its prerequisites and Frequently Asked Questions. Creation of Master Detail Block in Oracle Apps 11i Prerequisites There should exist a foreign key relationship between two tables in order to use the database block wizard to create master-detail block relationship. Create child table, master table and the foreign key in the database. Create Master Block Create the master block based on the test_parent_table. Repeat the… Read More

Creating New Forms in Oracle Apps 11i

Exforsys
Oracle Apps 11i Tutorials: Creating New Forms This document describes the process of creating new forms in oracle applications. In this tutorial we will discuss about Creation of new Block. Template.fmb Download the template.fmb from your oracle applications server. Open template.fmb through forms builder. You will see following screen.. Creation of new Block Click on Data Blocks and select + icon on the left toolbar. You will get following pop up window. Click on OK button and you will see following screen. Click on next button and you will see… Read More

Special Triggers in the Template Form in Oracle Apps 11i

Exforsys
This document provides an overview of the Special Triggers in the Template Form. The template form contains many form level triggers. These triggers are required for the proper operation of other routines. They are also aid in making the form respond to and behave properly in case of standard events. These triggers must not be deleted or to ensure the proper functioning of the form. Also, code can be added to these triggers but, the existing text must not be deleted. Figure: 3 Template Form triggers These triggers are listed… Read More

Oracle Apps Template Form

Exforsys
Oracle Apps 11i : Template Form in Oracle Apps 11i This document provides an overview of the template form. This form derives its importance from the fact that this form is the starting point of all development involving forms. The document highlights the importance of Template.fmb in forms development and also provides a detailed explanation of the various components of the Template form. Figure -1 Template.fmb Overview of the Template Form The TEMPLATE form is the starting point for all development of new forms. The first step in creating a… Read More

Oracle Apps Implementing Key Flex field and Descriptive Flex field

Exforsys
Oracle Apps 11i Tutorials : Implementing Key Flex field and Descriptive Flex field This tutorial tells you about implementation and other features provided in the implementation section . Implementing Flex fields Key Flexfield The basic steps in defining a key Flexfields are as given below. You may or may not use all the steps. The detailed explanation is being followed after the steps. Identifying Key flexfields that are required for you Oracle Applications installation Designing a Key flexfield structure Selecting the appropriate Key flexfield to define Defining structure information for… Read More

Oracle Apps Flex fields

Exforsys
Oracle Apps 11i Tutorials : Oracle Flex fields This chapter provides you with a conceptual overview of flexfields. The chapter covers the following topics The general features of flexfields, Flexfields terminology , The benefits of flexfields and Descriptive Flexfields.Overview of Flexfields Oracle flexfields is one of the most important parts of Oracle Applications. It is because of the flexfields that the Oracle Applications is so generic in nature and can be used to suit any industry or organization. A flexfield, as the name suggests, is a flexible data field that… Read More

Oracle Apps Message Dictionary

Exforsys
Oracle Apps 11i Free Training : Message Dictionary : This document discuss about message dictionary in oracle applications. It talks about the standards to be followed while defining the messages in oracle applications. It also discusses the usage of messages in the forms and concurrent programs.  Overview of Message Dictionary Message Dictionary lets you catalog messages for display from your application without hard coding them into your forms and programs. Using Message Dictionary, you can: Define standard messages you can use in all your applications Provide a consistent look and… Read More

Oracle Apps Concurrent Library Window

Exforsys
Oracle Apps 11i Free Training : Concurrent Library Window : This tutorial discusses about the Concurrent Library Window Navigation,create request set in oracle applications and Running Requests. Concurrent Library Window Use this window to register program libraries, which are lists of immediate concurrent programs that you wish to link with a concurrent manager. Concurrent managers use the programs in a program library to run their immediate programs. You must register libraries before you can define concurrent managers. You can only include immediate-type concurrent programs in program libraries. After adding any… Read More

Oracle Apps Concurrent Processing

Exforsys
Oracle Apps 11i Free Training : Concurrent Processing : This document talks about the concurrent processing in oracle applications. It will give the step-by-step procedure of creating concurrent programs in oracle applications. All types of concurrent programs are described in detail. Concurrent programs can be scheduled to run or manually run in oracle applications. In Oracle Applications, concurrent processing simultaneously executes programs running in the background with online operations to fully utilize your hardware capacity, hence the name ‘Concurrent Processing’. You can write a program (called a ”concurrent program”) that… Read More

Oracle Apps Table Registration API

Exforsys
Oracle Apps 11i Free Training : Table Registration API This chapter provides you with information you need to register tables to be used in Oracle Alerts and Flexfields with Oracle Applications. We will be learning about Procedures in the AD_DD Package, Procedure REGISTER_TABLE, Procedure REGISTER_COLUMN, Procedure DELETE_TABLE, Procedure DELETE_COLUMN and Example of Using the AD_DD Package. Introduction Though Oracle Applications comes with thousands of seeded database tables, there can be numerous applications in which one might be required to create a custom table to be used. In most of the… Read More

Oracle Apps Application Framework

Exforsys
Oracle Apps 11i Free Training : Application Framework: This document describes the steps of registering new application in oracle applications. It also talks about the standard directory structure within oracle application.Overview   Oracle Applications and custom applications that integrate with Oracle Applications rely on having their components arranged in a predictable structure. This includes particular directory structures where you place reports, forms, programs and other objects, as well as environment variables and application names that allow Oracle Application Object Library to find your application components. An application, such as Oracle… Read More

Single Node and Multi Node Installation Part 2

Exforsys
Oracle Apps 11i Free Training: Single Node and Multi Node Installation Part 2. In this part 2 tutorial we will continue with the installation steps about product license types, country-specific functionality, additional languages and internationalization (NLS) settings.Step 10. Select product license type On the Suite Selection screen, the wizard prompts you to indicate the type of licensing agreement you have purchased from Oracle Applications. It then presents the appropriate licensing screen. Completing a licensing screen does not constitute a license agreement. It simply registers your products as active. Rapid Install… Read More

Single Node and Multi Node Installation Part 1

Exforsys
Oracle Apps 11i Free Training: Single Node and Multi Node Installation Part 1. In this part 1 tutorial we will learn how to start with the Single Node and Multi Node Installation along with step by step instructions, screen shots and Frequently asked questions.Single-node and multi node installation In a single-node installation, the database, all product directories, all servers (concurrent processing, forms, and Web) are installed on a single node under one common APPL_TOP whereas in a multi-node installation, you install both application tier and database tier servers across two… Read More

Oracle Apps 11i – Using Rapid install and the Steps Before Apps Installation

Exforsys
This tutorial explains about using Rapid install to install Oracle Applications on any machine. With Rapid Install, you can perform these operations: Install a new, fully configured Oracle Applications system, including the latest certified Oracle Applications technology stack and all patches, mini-packs, family packs, and other updates available at the time of this release. Using Rapid Install Rapid install is used to install Oracle Applications on any machine. With Rapid Install, you can perform these operations: Install a new, fully configured Oracle Applications system, including the latest certified Oracle Applications… Read More

Oracle Apps 11i Installation – System Requirements

Exforsys
This tutorials explains about the System Requirements for Oracle Apps Installation. Please refer to Oracle Apps manuals for the specific and latest requirements for your Operating System.Oracle Apps 11i Installation – System Requirements CPU Requirements CPU requirements for running Oracle Applications depend on:  the number of concurrent users and their usage profiles the number of concurrent manager processes and the types of jobs that they are running  the load for activities other than Oracle Applications  the size of the database  desired response time Because there are different product combinations, different… Read More

Oracle Apps 11i : File System

Exforsys
An Oracle Applications Release 11i system utilizes components from many Oracle products. These product files are stored below a number of key top-level directories on the database and application server machines. Depending on how you chose to install Applications, these product directories may be located on a single machine (the simplest case) or on multiple machines (the most common type of deployment).Oracle Applications 11i File system An Oracle Applications Release 11i system utilizes components from many Oracle products. These product files are stored below a number of key top-level directories… Read More

Oracle Apps 11i: Internationalization Support and Multiple Reporting Currencies

Exforsys
This tutorial explains about Languages and Character Sets on the Database Tier, Languages and Character Sets on the Application Tier, Character Sets on the Desktop Tier as part of the Internationalization Support and Multiple Reporting Currencies feature in Oracle Applications 11i.Internationalization Support The Oracle E-Business Suite is designed for ease of deployment in a single global instance that meets the complex requirements of a worldwide enterprise. Strong internationalization support is essential in meeting this requirement. Key internationalization features provided by Release 11i include support for a wide variety of languages… Read More

Oracle Apps 11i : Getting started with Oracle Applications

Exforsys
This tutorial explains about Oracle Apps login, Choosing Responsibility, Choosing Function / Opening Form, Switch Responsibility, Query Form and Keyboard Shortcuts. This chapter would tell a user about the basics of login to the Oracle Applications instance. It would also demonstrate the basics of working with Oracle Applications. To understand the complete functionality of a particular responsibility please refer to the respective User Guide. Oracle Applications Login Before you connect to Oracle Applications you must know the URL of the Oracle Applications server you want to connect to. Clicking on… Read More

Oracle Apps 11i: Advantages of Oracle E-Business Suite

Exforsys
Oracle ERP Suite is based on Oracle Apps framework. What that essentially means to the customers is that no matter which component of the suite you buy, you get the same look and feel.Advantages of Oracle E-Business Suite Oracle Database The biggest USP of Oracle ERP is that it is based on Oracle Database, which in itself is a market leader. So the Oracle ERP is best placed to take advantage of the advances in the database technology. The buzzword is "If it is in the database, you will get… Read More

Oracle Apps 11i: Overview of popular ERP Products

Exforsys
This tutorial explains about different ERP Products and how they are being used in the industry.Oracle E- Business Suite Oracle E-Business Suite is the industry’s only complete and integrated set of enterprise applications, working together seamlessly to streamline every area of your business—from sales, service, and marketing, through financials and human resources, to supply chain and manufacturing. Oracle E-Business Suite is your fastest path to high-quality enterprise intelligence, bringing your company a true 360-degree view of your finances, your customers, and your supply chains, so you can make faster, better… Read More

ERP Overview

Exforsys
ERP (Enterprise Resource Planning) Overview covers What is ERP, Brief history of ERP, Why is it necessary, Market Leaders and the future of ERP. What is ERP? Enterprise Resource Planning or ERP is an industry term for integrated, multi-module application software packages that are designed to serve and support multiple business functions. An ERP system can include software for manufacturing, order entry, accounts receivable and payable, general ledger, purchasing, warehousing, transportation and human resources. Evolving out of the manufacturing industry, ERP implies the use of packaged software rather than proprietary… Read More