1 | Search Results | IT Training and Consulting

Oracle 11g SecureFiles

Relational content looks fine and flexible to follow even crude strategies of storage but unstructured data like documents of varied sort, audios, videos, and many more are add up the challenges for designers and architects.

September 4, 2011 - Saurabh Gupta - Comments:

Oracle 11g Subprogram Overloading

Polymorphism is an Object Oriented Programming language feature which allows the objects to accept same input and behave differently. It can be implemented in three ways i.e. overriding, hiding, and overloading.

June 17, 2011 - Saurabh Gupta - Comments:

Oracle 11g Read Only Tables

A Read-Only table is a normal data storage table, which restricts any transactional action on it. In the tutorial, we shall study the behavior of READ-ONLY tables under different scenarios.

June 16, 2011 - Saurabh Gupta - Comments:

Oracle 11g Exception Handling

Exception can be defined as the state of an entity, which is different from its conventional and normal behavior. In context to programming language, exception refers to the abnormal situation in the normal flow of the program.

June 9, 2011 - Saurabh Gupta - Comments:

Oracle 11g Collections

Composite data types are hybrid types which are capable of holding components of varying data type. Oracle implements composite data type in two forms, either as PL/SQL records or PL/SQL collections.

June 2, 2011 - Saurabh Gupta - Comments:

Oracle 11g Virtual Columns

Oracle 11g had brought multiple language enhancement features. These features have not only added the language utility, but also widened the programming scope of database developers.

May 30, 2011 - Saurabh Gupta - Comments:

Oracle 11g Invisible Index

Oracle 11g release has introduced a new property of an Index i.e. Visibility. Before the world saw 11g release, an index was always created and existed in visible mode. But now, as per the fresh feature in Oracle 11g, an index may exist in Invisible Mode too.

May 27, 2011 - Saurabh Gupta - Comments:

Oracle 11g SQL New Features

In continuation to my last tutorial on PL/SQL enhancements, I have compiled the list of enhancement pertaining to SQL. Similar to PL/SQL, Oracle had done considerable enhancements in SQL to raise performance level from instrumental to advisory. In the tutorial, we shall go through the performance oriented features, fresh additions and language enhancements. Performance improvements a. Alter table to add columns with default value In Oracle 11g, we can alter a table to add a column with a default value. Earlier, a developer used to update the value for the new column using UPDATE statement. Refer the example code [1]….

May 15, 2011 - Saurabh Gupta - Comments:

Compound Triggers in Oracle 11g

Oracle 11g offers considerable improvements in database triggers. These additions have not only enhanced the language usability but also promise a better performance in a real application environment.

May 9, 2011 - Saurabh Gupta - Comments:

Oracle 11g Result Cache

Result Caching is a new feature introduced in Oracle 11g. Since its induction in the 11g release, caching of result sets has emerged out as one of the most efficient performance tip in modern database applications.

April 28, 2011 - Saurabh Gupta - Comments:

PL/SQL Native Compilation in Oracle 11g

During the introduction of Objects and Types in Oracle 8 release, PL/SQL was referred as procedural and object oriented language. While Oracle 9i and 10g were more concentrated on the sharpening of the object oriented model of Oracle, Oracle 11g aims at evolving PL/SQL from interpreted language to natively compiled language. In the tutorial, we shall see the changes made to achieve native compilation and its post application effects. Interpreted to Native Compilation: A Tour Native compilation of program units was first introduced in Oracle 9i release 1. Introduction of native compilation was taken as one of the revolutionary changes…

April 25, 2011 - Saurabh Gupta - Comments:

Oracle 11g PL/SQL New Features

The tutorial lists the major PL/SQL additions and enhancements covered in Oracle 11g. The features described here are based on their utility in a development environment. SQL* Plus Stepped Down and Passwords made Case Sensitive SQL* Plus is no more the part of Oracle home family. This step has been taken to recommend the use of SQL Developer. SQL Developer version 3.0 is the latest release from Oracle, in which all the earlier reported bugs were resolved. Besides, developers can still optionally setup SQL* Plus environment on command line prompt. Now, database connection passwords could be case sensitive. Two new…

April 24, 2011 - Saurabh Gupta - Comments:

Mobdro Apk Download | Mobdro {Jan 2017 VERSION}

MobdroApk Download and install|MobdroJan 2017 VARIATION Mobdroapk for Android is a popular Application for streaming online Flicks and Television Series. With the massive collection of Free Movies, Trailers, Anime and Thrilling TV collection, its ideal Movie App in its league. You can find essentially anything on MobdroApk is created for Android platform and also provide some of coolest features which none of its competitors gives. Here Ill be giving the quick introduction about App and Its attributes. Youll find links to all released versions till now. MobdroApk is an enjoyment hub App. If you are Film enthusiast person then this…

November 22, 2010 - Exforsys - Comments:

Facilitator Core Skill 1: Building Rapport

In order to effectively reach out and work with the team members, a facilitator has to learn the fundamental skill of building rapport. That is, the need to create and maintain empathy or a sense of connection with the members. Building rapport is not done the easy way; people have different ways of establishing it with other people. There are those who have the natural ability to easily create a good relationship with others. Their is a need to understand the essence of the skill and learn it to come up with their own techniques. Have you ever encountered a…

April 4, 2010 - Exforsys - Comments:

JavaScript Conditional Statements Part 1

In this JavaScript tutorial, you will learn about the conditional statements available in JavaScript for decision making, if statement and if…else statement.

April 24, 2007 - Exforsys - Comments:

PHP Tutorials – File manipulation (Part 1)

PHP Tutorials – File manipulation (Part 1) In the PHP Tutorial You will learn about File manipulation (Part 1) – Checking file existence, A file or directory, Determining file size, Creating and deleting files and Opening a file for writing, reading, or appending. Checking file existence: You can test for the existence of a file with the file_exists() function. file_exists() takes one element, which is a string representing an absolute or relative path to a file that might or might not be there. If the file is found, file_exists() returns true; otherwise, it returns false. Example: if (file_exists(“file.jpg”)) { print…

November 15, 2006 - Exforsys - Comments:

C++ Operator Overloading Part 1

In this C++ tutorial you will learn about Operator Overloading in two Parts, In Part I of Operator Overloading you will learn about Unary Operators, Binary Operators and Operator Overloading – Unary operators. Operator overloading is a very important feature of Object Oriented Programming. Curious to know why!!? It is because by using this facility programmer would be able to create new definitions to existing operators. In other words a single operator can take up several functions as desired by programmers depending on the argument taken by the operator by using the operator overloading facility. After knowing about the feature…

September 7, 2006 - Sripriya R - Comments:

C Programming – Data Types : Part 1

C language provides various data types for holding different kinds of values. There are several integral data types, a character data type, floating point data types for holding real numbers and more. In addition you can define your own data types using aggregations of the native types. The C standard gives detailed specifications on the language; implementations of C must conform to the standard. An “implementation” is basically the combination of the compiler, and the hardware platform. As you will see, the C standard usually does not specify exact sizes for the native types, preferring to set a basic minimum…

March 7, 2006 - Exforsys - Comments:

Using SQL Sever Management Studio – Part 1

Using SQL Sever Management Studio – Part 1 In the tutorial you will learn about Using SQL Sever Management Studio, The features of the Management Studio, Starting SQL Server Management Studio, The Object Explorer and also Default. Optional connection settings. A Database Administrator typically grapples with tasks relating to accessing, configuring and administrating the components of the SQL Server. To assist the Administrator in this task, SQL Server 2005 provides a graphical user interface called the SQL Server Management Studio. The SQL Server Management Studio combines graphical user interface with a rich script editor, so that administrators can script and…

December 15, 2005 - Exforsys - Comments:

Oracle Apps 11i : Asset Management – Journal Entries

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 asset book must be the same as that in the…

October 16, 2005 - Exforsys - Comments:

Oracle Apps 11i : Asset Management – Retirements

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 or costs. 3. You can perform a mass retirement by…

October 16, 2005 - Exforsys - Comments:

Oracle Apps 11i : Asset Management – Depreciation

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 required. b) Basic depreciation calculation Prorate date Oracle Assets prorates…

October 13, 2005 - Exforsys - Comments:

Oracle Apps 11i : Asset Management – Mass Transfers

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 to have assets inherit the depreciation rules of the new…

October 12, 2005 - Exforsys - Comments:

Oracle Apps 11i : Asset Management – Asset Adjustments

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 change the number of units for the asset in the…

October 12, 2005 - Exforsys - Comments:

Oracle Apps 11i : Asset Management – Mass Additions

.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 enter additional data for a mass addition; add a mass…

October 9, 2005 - Exforsys - Comments:

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

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 on asset date placed in service, Oracle Assets retrieves an…

October 9, 2005 - Exforsys - Comments:

Oracle Apps 11i : Asset Management – Asset Books Regions

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 period is opened. Only one period can exist at the…

October 9, 2005 - Exforsys - Comments:

Oracle Apps 11i : Asset Management – Asset Book Positioning

.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, transfers, retirements, or other unrecorded changes, ensuring that the asset…

October 9, 2005 - Exforsys - Comments:

Oracle Apps 11i : Suppliers

. 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 include Purchasing, Payables, Assets, and Property manager. Enter/Update Supplier Base…

September 27, 2005 - Exforsys - Comments:

Oracle Apps 11i : Creating Journals through Oracle GL

. 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 reports. You cannot have duplicate batch names in the same…

September 27, 2005 - Exforsys - Comments:

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

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 points: Creating a Chart Of Accounts (COA) A Chart Of…

August 14, 2005 - Exforsys - Comments:

Registering New Forms in Oracle Apps 11i

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, and its .fmx file must be located in your application…

July 24, 2005 - Exforsys - Comments:

Creation of Master Detail Block in Oracle Apps 11i

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 steps for creating a block using database block wizard. Use…

July 24, 2005 - Exforsys - Comments:

Creating New Forms in Oracle Apps 11i

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 following screen Base your block on table, Click next, you…

July 17, 2005 - Exforsys - Comments:

VB.NET Creating and Managing Components Part 1

VB.NET Creating and Managing Components Part 1 In this tutorial you will learn about Components, Best practices in using Components, Creating Components by extending the UserControl Class, Testing the Control, Creating and implementing Events, Extending a control through Visual Inheritance and Inheriting from a UserControl. A component is a reusable piece of code in binary form. This code can be reused by inheritance. No class is being inherited. It follows that a containment relationship is defined between the application using the component and the component that is being used. This is different from the relationship that exists between a derived…

July 6, 2005 - Exforsys - Comments:

Special Triggers in the Template Form in Oracle Apps 11i

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 below: KEY–CLRFRM KEY–COMMIT KEY–DUPREC KEY–EDIT KEY–EXIT KEY–HELP KEY–LISTVAL KEY–MENU ON–ERROR…

July 3, 2005 - Exforsys - Comments:

.NET Common Windows Forms Controls Part 1

.NET Common Windows Forms Controls In this tutorial we will learn about Common Windows Forms Controls in Visual Basic .NET 2005. IN this part 1 of this article, We will be learning the controls like Control Hierarchy, Label, LinkLabel, TextBox, RichTextBox, PictureBox, GroupBox, Panel, Button, CheckBox , RadioButton, ListBox, CheckedListBox and ComboBox.Control Hierarchy The base class for all Windows controls is located in the System.Windows.Forms namespace. These controls are built into the .NET framework and form the basis for derived controls. These controls have a distinct hierarchy of their own. For example the hierarchy of the control rich text box is…

June 26, 2005 - Exforsys - Comments:

Differences between VB.NET 1.0 and VB.NET 2.0

VB.NET 2005 Free Training: Differences between VB.NET 1.0 and VB.NET 2.0: VB.NET 2005 comes with a number of enhancements. The IntelliSense Code snippets, the Windows Forms designer updates, IntelliSense filtering, debugger data tips, exception Assistant etc make the software a pleasure to work with. The language has been spruced up with generics, unsigned types, Operator overloading etc. The My Namespace is the most significant enhancement that provides a single reference to commonly used functionalities within the .NET framework. It includes classes like Application, Computer, Forms, Resources, Settings and Users. This enables users to ping a computer with a simple line…

May 31, 2005 - Exforsys - Comments:

Single Node and Multi Node Installation Part 1

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 or more nodes. The installation steps for single-node and multi-node…

May 28, 2005 - Exforsys - Comments:

The .NET Framework Architecture Part 1

This is the first tutorial as part of the Visual Basic .NET 2005 Training. In this tutorials we will be learning about the basics of The .NET Framework Architecture, The .NET vision, Common Language Runtime (CLR), .NET Framework Class Library and Microsoft Intermediate Language (MSIL). It’s very important to learn the basics before we actually start with the Programming. The .NET Vision The .NET framework is a software technology that is directed towards connecting information, people, systems and devices seamlessly. The high level of software integration that has been attempted through use of XML web services enables the creation of…

May 27, 2005 - Exforsys - Comments:

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

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 technology stack and all patches, mini-packs, family packs, and other…

May 24, 2005 - Exforsys - Comments:

Oracle Apps 11i Installation – System Requirements

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 user profiles, and different configurations, there is no one sizing…

May 22, 2005 - Exforsys - Comments:

Oracle Apps 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 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 on the database and application server machines. Depending on how…

May 22, 2005 - Exforsys - Comments:

Oracle Apps 11i: Internationalization Support and Multiple Reporting Currencies

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 and territories, flexible date and number formats to suit local…

May 18, 2005 - Exforsys - Comments:

Oracle 10g Installation Guide on Windows 7

Oracle 10g Installation tutorial depicts step by step installation of Oracle 10g on Windows 7, 64bit (10204_vista_w2k8_x64_production_db) operating system. Installation on Windows 7 will return a operating system version compatibility error. However, there will not be any such issue during installation on older version of Windows operating system. It is important to note that this installation method is neither certified nor recommended by Oracle. If you are planning to install Oracle 10g for production purpose then please follow the Oracle specified installation guidelines and use only the correct and supported version for installation. Download Oracle 10g for Windows Oracle software…

May 11, 2005 - Exforsys - Comments:

Oracle Apps 11i : Getting started with Oracle Applications

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 the URL would lead you to the Oracle Applications Login…

May 9, 2005 - Exforsys - Comments:

Bluetooth Vs 802.11b Wireless LANs

This article discusses about the differences between Bluetooth and 802.11b Wireless LANs, Co-existence of Bluetooth & Wi-Fi and Advantages & Disadvantages. 1) Bluetooth has lower distance range (less than 30 feet) than 802.11b (up to 200 feet). Therefore, you would need many more access points to cover the same area of an office. Simple mathematics will show that you may need as many as 20-50 times the number of access points 2) Bluetooth has generally lower speed than that of 802.11b wireless LANs. 3) Bluetooth components (chips and radios) and device adapters are cheaper than wireless LAN components and adapters. 4)…

May 6, 2005 - Exforsys - Comments:

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

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 it and get it fast!!" Consultants As far as the…

May 4, 2005 - Exforsys - Comments:

Oracle Apps 11i: Overview of popular ERP Products

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 decisions and grow profitability in a competitive marketplace. Application software…

May 4, 2005 - Exforsys - Comments:

MSAS – Implementing Calculations Using MDX Part 1

In this tutorial we will be learning about Calculated members, Creating Calculated Members, Using Function Libraries to Build Calculated Members and Calculated Member Builder.Understanding Calculated members Calculated members are members of a dimension whose value is calculated at run time using Multidimensional expressions. The values of a calculated member may be derived from other member’s values. For instance Profit is determined by subtracting the value of member costs from value of member sales. This is unlike an input member whose value is directly loaded from the data base. The expressions for calculated members are defined when the member is defined. Calculated…

April 21, 2005 - Exforsys - Comments:

MSAS: Optimization Tuning Part 1

SQL Server 2000 Analysis services comes with certain features that optimize performance without the intervention of the Administrator. The Storage Engine is optimized by incorporating the following features;Record size and Data types should be kept as short as possible in the Fact tables and should only include fields for measures and indexed key columns. The Measure fields should use the smallest data type consistent with the measure data but the data type should be large enough to contain summarized values and prevent overflow when aggregations are calculated. Even saving two bytes per row can result in smaller fact tables in…

April 14, 2005 - Exforsys - Comments:

MSAS : The Data warehousing framework of SQL Server 2000 – Part 1

The Data warehousing framework is a set of components and API’s that implement the data warehousing features of the SQL server 2000. The common interface of the server known as the Enterprise Manager can be used by various components to build and use the data warehouse or a data mart.The Data warehousing framework of SQL Server 2000The following illustration details the Microsoft SQL Server 2000 data warehousing overview.The relational database engine of the SQL server is a modern, highly scalable and reliable engine for storing data. The database stores data in tables and each table represents objects that are of…

March 15, 2005 - Exforsys - Comments:

MSAS : Building the Cube Part #1

This three part tutorial explains about cubes, Dimensions and how to create them using the wizards. You need to understand and learn how to create the cubes since it’s very critical step.Tutorial 12: MSAS : Building the Cube Part #1A cube is a multidimensional structure consisting of dimensions and measures. Therefore, we need to know what dimensions we intend to use and what measures will be captured. In short, we need to know what quantitative values we want to analyze or monitor from our database. Usually organizations capture actual measures such as revenues, sales in context of expenses, costs along…

March 9, 2005 - Exforsys - Comments:

XML Unit Testing tools Series 1

Avignon allows for true test-first design by letting users express test cases in XML prior to the start of unit development. Avignon is an acceptance test system that allows you to write executable tests in a language that you define. It uses XML to define the syntax of the language but, if you choose to extend the language, leaves the semantics of the tests up to you.FeaturesRunning Tests : Avignon is implemented in Java, and is configurable for many different forms of test execution.Requirement: Junit, HTTPUnit, JAXP, Xalan Avignon is being released freely under the GPL license. The single ZIP…

February 6, 2005 - - Comments:

Determining Quality Needs for Stakeholders

The ability to figure out the needs of your stakeholders will play a crucial role in project management. In recent years, engaging the stakeholders during social reporting has become extremely important for corporations and business organizations. At the same time, organizations must be capable of taking the time to measure the actual engagement process to properly verify and use the process result. Not only is it necessary for you to measure the needs of Stakeholders process through the usage of the AA1000 Stakeholder Engagement Standard series, which encompasses principles-based standards to help organizations become more accountable, responsible and sustainable and…

August 31, 2016 - Exforsys - Comments:

Create a Successful Quality Management Plan

Having a Quality Management Plan is an important foundation for any Project. Successfully implementing a quality management plan for a project is a task which requires a lot of organization. However, the benefits are well worth it, as the creation of the quality management plan and its application to any given project will give you the ability to ensure that proper quality management is being utilized. Quality management plan can be thought of as a type of document which is responsible for detailing the effectiveness of activities and practices which are available for any given product or service. It forms…

August 30, 2016 - Exforsys - Comments:

Grouping Seminar Audience Effectively

During seminar, it is common for participants to join group activities. These activities are specifically designed to create a powerful and long-lasting impact on the knowledge that you are trying to instill in their minds. Thus, grouping your audience should make use of group dynamics so that you, as the seminar facilitator, will be able to increase your chances of achieving your overall purpose for the seminar. Group Dynamics This term would refer to the series of processes, interactions, and combined performances that occur within a group. Because people differ from each other in terms of personalities, beliefs, values, level…

June 21, 2016 - Exforsys - Comments:

Seminar Visual Aids

Visual aids have long been regarded as a staple in most public speaking endeavors. When making a presentation during a business meeting, giving a speech, or even when holding seminars, the use of visual aids is commonly employed. There are two main functions of a visual aid: it helps the audience understand your message better. it keeps them interested. Learners can be visual, auditory, or even kinesthetic learners, which is why effective seminars always take into consideration these three aspects. By making use of visual aids during your seminar, you will be able to address the three channels of learning….

May 12, 2016 - Exforsys - Comments:

Seminar Presentation Skills

A large part of your success as a seminar facilitator lies in your presentation skills. Because presentation is crucial in every seminar, you should therefore endeavor to learn these skills and never step up that podium without even bothering to understand the things you need to do in order to become an effective facilitator. Seminar Presentation requires proper planning and extensive preparation. How well are you able to communicate with the audience? Are you able to effectively deliver your thoughts and ideas towards them? Are you able to keep them interested that they do not even want to move or…

May 6, 2016 - Exforsys - Comments:

Seminar Outline

Preparation is key to a successful seminar. Even a seasoned seminar speaker would still take the time to sit down and plan things out before the event. As someone who will conduct a seminar in front of 10, 100, or even more participants, you cannot afford to be in front of the audience unprepared. If this is the first seminar you will handle, then it is all the more necessary to plan weeks and even months before the big day. A large chunk of the preparation phase is making the outline. This will serve as your guide in knowing what…

April 25, 2016 - Exforsys - Comments:

Organizational Change Management

The concept of organizational change management applies to organization changes such as mission change, restructuring operations, application of new technologies, major collaborations, and mergers. This kind of change in the organization requires a fundamental and radical reorientation of how the organization functions and operates. This happens when there is a provocation of external driving force such as economic crisis, fund cuts, new markets, and major increase in demand. The occurrence of organizational change has not slowed down over the last decade and will continue to increase as more and more innovations in technology have been used to drive change within…

March 22, 2016 - Exforsys - Comments:

Organization Redesign

It is common for organizations to realize later on that the design they have created does not seem to provide a positive impact to their purpose, or is not able to keep up with the changes. Either way, they need to make certain adjustments in their current design framework in order to thrive. This process is known as organization redesign. Importance of Organization Redesign The restructuring of an organization has become a necessity and at the same time, a powerful business strategy. It is critical to the success of a business because of how dynamic the environment is. With so…

March 17, 2016 - Exforsys - Comments:

Organization Life Cycle

The life cycle of an organization proposes that over a certain period of time, for-profit companies move through a predictable sequence of development. Life cycles have been the subject of extensive study over the years and these are linked to organizational growth and development studies. It has been found that organizations are similar to living beings because they have a pattern of developmental stages and are impacted largely by the circumstances of the internal and external environments. There are many frameworks used to determine the life cycle of an organization. However, the most basic, which others have based their framework…

March 12, 2016 - Exforsys - Comments:

Organizational Chart

An organizational chart, otherwise referred to as org chart, is a diagram that illustrates the structure of an organization. It clearly shows the rank and relationships of the employees, and help keep the work operations organized. Depending on the size of the company, a chart may comprise of numerous lines, arrows, and boxes, or it may consist of only a few. Because relationships within a company often change, charts should be flexible and simple, so that they can be changed easily. Importance of Organizational Chart Organizational charts are considered important and vital in allowing the members of the company to…

March 2, 2016 - Exforsys - Comments:

Organizational Learning

Over the years, there have been several definitions of organizational learning. One such definition is that it is the process of being able to detect and correct errors, with people in the organization acting as the agents who learn through various activities. Another definition states that there are four aspects associated with organizational learning, and these are: knowledge acquisition, distribution of information, interpretation of information, and the use of organizational memory. Lastly, organizational learning has also been defined as similar to that of having one stimulus and getting several effects, a pattern of many “means and ends” relationships. But fundamentally,…

February 22, 2016 - Exforsys - Comments:

Organization Design Models

The basic systems model used in organizations is one that takes input, creates a transformation through a series of internal processes, and produces an output. However, whilst the different models being used today are still built around this fundamental concept, there have already been variations made to meet the needs of the organizations in the 21st century. This article discusses the four most commonly used models in organizations. Galbraith’s Star Model of Organizational Design The Star Model serves as the basis from which an organization creates design choices. It has five categories of design policies that can be controlled by…

February 7, 2016 - Exforsys - Comments:

Principles of Organization Design

There are numerous frameworks that allows to structure an organization. However, to design an organization is quiet different because there is no such thing as a design blueprint that anyone can simply follow without taking necessary steps to ensure that the design structure will work for a particular organization. Blueprint Designs even makes it more complicated knowing that the design is ineffective, this will lead the organization to serious consequences which may ultimately result in business failure. Fortunately, there are four guiding principles that will assist employers in making an organization design. These principles, if followed correctly, will bring a…

January 31, 2016 - Exforsys - Comments:

Using Competencies in Project Management

Project management has been defined as the process involved to successfully attain the goals and objectives of a given project. There are several types of project managers such as construction project manager, software project manager, architectural project manager and research project manager. Every project management endeavor has a manager. The project manager has a long list of roles that needs to be filled so that the project can be completed in the best means possible. These roles are categorized into: planning, organizing, managing, executing and closing. Roles of a Project Manager A project manager has the following responsibilities: Develops the…

January 26, 2016 - Exforsys - Comments:

Using Competencies in Selecting Your People

During hiring process, companies focus on an individual’s competencies, and this is more evident today than ever. Their understanding of the value of people to help them communicate their core competencies to their market and the rest of the world has paved the way for the integration of competency-based hiring practices. The kind of people hired by any company will impact the business, and such impact can go either way – good or bad. The employees are the heart of the company; if they are highly competent individuals then they will contribute greatly to the company’s success. Conversely, if ineffectual…

January 19, 2016 - Exforsys - Comments:

Using Competencies in Training

Training is a very significant aspect in helping employees become more efficient and effective in their job. Thus, it is very important that this department must be equipped with the necessary competencies that will allow them to impart and transfer knowledge and understanding to the trainees through various methods, strategies, and activities. Areas of Competence and Competencies of a Trainer The areas of competence of a trainer, and their corresponding competencies are: Training Delivery: Presentation of learning objectives must be set clearly; audio-visual aids must encourage learning. The trainer should understand that the physical environment can greatly affect the learning…

January 16, 2016 - Exforsys - Comments:

How to Develop a New Competency

To stay competitive, one must adapt to the changing times. Today, there are already many competencies that were unheard of 50 years ago. This is particularly true for functional competencies which are job-specific competencies; in the past, there were no web developers and designers, which mean that before, people were not required to know programming languages and stylesheets. The advent of technology has paved the way for these competencies to exist; thus, people who want to be able to move up in their career have to evolve too, especially when it comes to developing new competencies. There are three phases…

January 8, 2016 - Exforsys - Comments:

Competencies Key Principles

Competencies can be produced and learned by one or many individuals by adhering to a framework. Competencies must also be updated and made adaptable to hold relevance to those they were designed for. However, in order to get commitment from employees, there are guiding principles to be followed. These will be discussed in detail in this article. Principle 1: Collaboration Management creates policies for everyone to follow; they create plans and programs designed for all. But when it comes to designing a competency framework for the organization, the task should not only be limited to management, but also to those…

January 5, 2016 - Exforsys - Comments:

Leadership Competencies

Leadership role in any organization is vital to its success. Managers can be leaders but not every manager is a leader. A leader must be able to create a vision, influence others, and bring out the best in their people. With leadership, one can initiate action among his people. He can motivate everyone to keep going, with or without the help of rewards. Additionally, leadership enables a person to provide guidance to others so that work can be done effectively and efficiently, and such guidance is given through coaching and mentoring. Lastly, with leadership, a person can make others confident…

December 31, 2015 - Exforsys - Comments:

Competency Framework

A competency framework is a method by which an organization can accurately assess the knowledge, skills, and attitudes (KSA) of their employees. In addition, it also helps maintain and keep track of these competencies; a tool to measure competency levels to ensure that everyone makes significant contributions to the organization by performing in a superior manner. With a competency framework, recruitment officers will be able to effectively hire the ideal candidate they need for their company; managers will be able to make sound decisions in managing their employees; and employees will be able to develop their skill sets because they…

December 27, 2015 - Exforsys - Comments:

Competency and Competence

Competency and competence have often been used interchangeably. Moreover, people often think that competency and competence are one and the same however this is a misconception. What a lot of people fail to realize is that these are two different concepts and cannot be used to take the other’s place. To understand this better, definitions of each are given below. Competency (pl. competencies) refers to the characteristics of a person; these may be observable or non-observable. Such characteristics are behavior-based, and are instrumental to helping a person perform his tasks at a higher level. On the other hand, competence (pl….

December 24, 2015 - Exforsys - Comments:

Introduction to Competency

In order to perform well in any job, an individual needs possess all necessary skill set and knowledge, as well as the personal attributes. Today’s Individuals have become fiercely competitive to succeed in their chosen fields, and are equipping themselves with the right attitude, knowledge, and skills. Understanding this reality will create awareness that to stay competitive you must have an edge over the others. For this reason, you need to develop certain competencies. Many often confuse competence and competency. Although used interchangeably, they are nonetheless different from each other. Competence is defined as the requirements and standards that have…

December 20, 2015 - Exforsys - Comments:

Competency Based Performance Management

An organization follows certain process that aims to consistently meet the goals effectively through constant monitoring of employees’ performance and making sure that everyone performs in an outstanding manner. This is called performance management. It is an organizational work system that starts when an employee’s job title is defined along with its competencies and ends when an employee resigns from the company. It is a process of building a work environment wherein working individuals perform their best to contribute to the success of company goals. The term is sometimes associated with performance appraisal in some organizations. The following are the…

August 27, 2015 - Exforsys - Comments:

Competency Models

Building a successful career in an organization requires core set of competencies in order to carry out an outstanding performance and desirable outputs. This is what we call competency model. The framework helps employees in identifying the competencies they need to further improve in order to make a more satisfactory performance in their functions and also in preparation for future promotions and job transfer. The model will analyze employee competency to determine the areas the individual lacks development on and to bridge the gap, training and development will be required. There are three essential types of competency models used by…

August 19, 2015 - Exforsys - Comments:

Competency Management Software

Competency assessment is a very essential tool in measuring the abilities of every employee. Organizations prefer to employ only competent workforce who can maintain their attributes or keep on improving it to continually meet organizational goals. In order to effectively manage workforce competencies in the company, the use of competency management software is an effective solution. Various management software programs keep track of competency assessments within given deadlines. When a company is able to identify the appropriate employees in the right positions internally, motivation and commitment increase. Moreover, employee turnover is reduced which in turn minimizes the cost and hassle…

August 18, 2015 - Exforsys - Comments:

Creating a Competency Based Resume

An important tool in the job application process is the resume or curriculum vitae (CV). It is an applicant’s personal identification where all pertinent information is reflected. Resumes are necessary documents that the recruiting team of a company will need from anyone who is applying for a job. Whether making an online or hard copy of a resume, an effective type of resume to be followed is the competency-based resume. Sometimes called functional resume, it highlights the core skills and qualifications of the individual as opposed to chronological and traditional resumes. Since an applicant is selling personal experience through acquired…

August 4, 2015 - Exforsys - Comments:

Competency Mapping – Discovering Your Core Competencies

Companies find it easy to grow and expand with a group of competent and skilled individuals who largely contribute to its success. In many growing and successful companies, competency mapping plays a major role. The term pertains to the process of identifying the essential qualities and skills of the employees and processes within the organization. Competency mapping generally assesses two crucial areas of a working individual: emotional intelligence or emotional quotient (EQ), and the individual’s strength or capabilities in various aspects of the organization such as leadership, decision-making, and organizational structure. This process works effectively in the aspect of recruitment,…

July 31, 2015 - Exforsys - Comments:

How to Think Positively

Choosing to become an optimistic person with positive thoughts and attitude is a healthy choice to make in one’s life. Positivity in our mental and emotional aspects is a habit that we can gradually master with constant practice. You might be living a life filled with negative vibes which could in turn ruin your life. Your thoughts alone can make a misery out of your life. You may have noticed that it is easy to think of negative thoughts and consequences once you encounter hardships and problems. Changing your perceptions and outlook into something positive will transform your individuality. It…

July 24, 2015 - Exforsys - Comments:

How Self Esteem Can Help Positive Thinking

The word ‘esteem’ is defined as “appreciating the value of”. The term self-esteem means giving high regard for oneself and treating the self more importantly than anyone else regardless of cultural or personal differences. Self-esteem is synonymous to self-respect. Self-esteem is about believing that you are a valuable and worthy person not just to yourself but to other people as well. It is one important attribute that every one of us should cultivate. Our personal value is a crucial foundation of personal success. It always starts out with loving yourself and nurturing what you are capable of. Before you can…

July 10, 2015 - Exforsys - Comments:

How to Manage People’s Perception

Have you experienced being misjudged by other people? Have you ever thought about how others should see and know you? The way we see and interpret others can affect the way we understand their personality. We often get assumptions of our character from those we do not know, but on certain instances, even from those we already know. If you are keeping a reputation just like high profile leaders do, you must have cared about it a lot. But even if you are just an ordinary person or a typical employee in your company, it is important to project a…

July 9, 2015 - Exforsys - Comments:

Architecture Designing

Architecture design service provided by Exforsys gives an elaborate blueprint for retrieving complex data from the database. Architecture designing broadly falls under three main categories: Database components Clients Application components Database components are used to store the data in a central hub. The client provides input and the application software plays an important role in saving the data. It acts as the bridge between the database and the client side and helps in saving data. Architecture can be of two types: 1. Two-Tier Architecture In two-tier architecture, the client has direct access to the storage database and can save data…

January 26, 2014 - Exforsys - Comments:

Implementation Solutions

Many business organizations face difficulties while trying to access a particular data from the huge database they maintain. This issue can be also due to inappropriate maintenance of departmental documents, which causes problems while retrieving the correct files for carrying out certain tasks. To overcome such problems, we deliver extraordinary Enterprise Resource Planning solutions. Exforsys team is highly experienced in the field of implementation solutions. We carry out a detailed Statement of Work (SOW) after analyzing the present state of affairs of the company. By means of the solution delivered by our company, one can visualize the growth of their…

January 26, 2014 - Exforsys - Comments: