OracleAppsBlog

Friday, July 30, 2004

Fndload is not a command line tool

Fndload is a tool used at patch-upgrade time to migrate data from the Oracle reference instance to your installation. Via fndload seeded responsibilities, menus, profile options and many many more are delivered.

Fndload can also be used at your project by dba’s or technical consultants to migrate-script the setup from one instance to an other. Those people will tell you that fndload requires a first set of mandatory parameters (apps/apps 0 Y) and then some object specific parameters.

But you do not need the unix prompt to use fndload. Make it a functional tool by creating a concurrent program that points to the seeded fndload executable.

Seeded examples you can explore in the instance you’re on now are:

• Download HRMS Taskflows
• Forms Configurator - Upload Template
• Plan Design Copy - Import (Benefit plans)

Forget about the first set of parameters. The concurrent manager handles these for you. The only parameters you have to create and validate and restrict are the functional ones. In the examples above you can see how Oracle implemented it.

Thursday, July 29, 2004

Download Oracle Documentation

This post contains a link to a site where you can download a comprehensive range of Oracle Documentation.

Certainly I might be stating the obvious but I thought it would be good to have the information on this site. This Oracle Technology Network (OTN) page contains Oracle Documentation for the following key technology areas: -

• Database
• Development Tools
• Data Warehousing and Business Intelligence
• On Demand
• System Management
• Application Server
• Oracle Collaboration Suite
• Technologies / Utilities
• Applications / E-Business Suite

Of interest to Oracle Apps users will be the online documentation CD which can be downloaded for each release of Oracle E-Business Suite from R11 to R11.5.9

Oracle Applications Upgrade - new functionality added since 10.7 and 11

This post contains a link to the Oracle page which will provide you with a functionality comparison between the different releases of Oracle Applications.

If you are still on Oracle Applications R10.7 or R11 and are considering an upgrade to R11i, this Oracle Appsnet page will provide you with an understanding of what new features and capabilities have been added to Oracle E-Business Suite since R10.7 and R11. The site lists the changes by major release and by module and is very useful in understanding the differences between each major release of Oracle Applications.

Tuesday, July 27, 2004

Oracle OpenWorld in Shanghai, China - presentations and white papers now available

This post takes a look at the key areas covered in the Oracle OpenWorld China conference and also reviews the presentations and white papers delivered for some of the Oracle E-Business Suite 11i Tracks. There were more than 150 sessions going on at the conference so there’s no shortage of reading material.

The Oracle OpenWorld China conference came to a close last week and the presentations and white papers are now available for download in PPT and Word format (nice for those who like to copy and paste). Most of the areas presented on were not really Apps related but for those that were, I will be preparing a review of some of the presentations during the week. The following is a list of the solution areas presented on as well as the number of presentations for each area: -

• Security and Identity Management - 4
• High Availability - 11
• Performance and Scalability - 31
• Management - 35
• Content Management and Collaboration - 8
• Business Intelligence - 21
• Portals and Wireless - 9
• Linux - 5
• Integration and Web Services - 9
• Application Development - 22
• Corporate Governance - 9
• Small and Mid-Size Business - 6
• Corporate Performance Management - 7
• On Demand - 4

Saturday, July 24, 2004

New Oracle Presentations from the OpenWorld Conference in Melbourne

After a bit of a wait it now seems that the Oracle OpenWorld Melbourne Presentations are now available in pdf format (sorry to those people who like copying and pasting). This post lists the key areas covered and also reviews the presentations delivered for some of the Oracle E-Business Suite 11i Tracks.

You can download presentations for the Oracle OpenWorld Australia and New Zealand Conference here. According to the site: -

There were over 100 Sessions to choose from over the course of the OpenWorld conference. They were delivered via 10 concurrent Tracks - focussing on Oracle’s entire range of business solutions and technologies.

Following is a complete listing of all the tracks as well as some personal reviews I have prepared: -

Keynote Presentations

Charles Phillips presentation on Creating Corporate Value - Information Matters contains a short but interesting look at Oracle’s financial performance. I was interested to see that Oracle Applications Sales have grown by 4% in the last 12 months. The competitors didn’t do so well - SAP (-6%), Peoplesoft (-17%), Siebel (-31%). The only software company beating Oracle’s operating profit margins is Microsoft. I must be in the right business - at least for now anyway! The session goes on to discuss the Oracle Strategy a large component of which seems to be helping organizations Standardize IT in the following areas: -

• Processes 
• Data
• Architecture
• Infrastructure

Keith Kellogg’s presentation on Oracle’s Perspective on Homeland Security gives a nice high level view of the Oracle E-Security Suite solution bundle.

The presentation I like the most was by John Wookey on the Information Driven Organization. Firstly it ask’s the question, what defines the information driven organization - to which the answer is: -

• Alignment - encourage behaviour that supports organizational objectives through communication, consistency and incentives.
• Effectiveness - drive enerprise information and enterprise business processes into every aspect of your business.
• Collaberation - coordinate processes across direct, partner, supplier and online channels through distributed access, integrated processes and shared information.

He then defines the Oracle Solution for the Information Driven Organization by outlining the key features of the new 11i release (namely 11i.10 or 11.5.10) which are: -

• Integrated Business Driven Intelligence
• Continued Aggressive product extensions
• Best in Proven Technology
• Broad Industry Investments
• Opening of the E-Business Suite: -


• Integration Services
• Customer Data Hub

The presentation outlines Oracle Solutions for Specific Industries and then goes on to explain the three paths to higher quality information, which are: -

1. Full E-Business Suite right away - best information, lowest cost.
2. E-Business Suite with Integration to Legacy Apps - More graceful on-ramp to E-Business Suite.
3. Data Hub - Retain Legacy Apps; benefit from single data model.

I like the presentation because although it does mention Oracle Specific Solutions, it gives a good idea of what organizations are trying to achieve and how IT is helping them meet their business goals.

Oracle Database 10g - Tracks A & B

Oracle Application Server 10g and Application Development - Tracks A & B

Oracle Collaboration Suite Track

Business Intelligence & Data Warehousing Track

Enterprise Resource Management - (Oracle E-Business Suite 11i) - Tracks A & B

Certainly the best presentation in this category was The Enterprise Iceberg - a hidden resource or a hazard to business by John Julian. The presentation relates to the University Systems Project (named Themis) undertaken at the University of Melbourne. It’s quite a lengthy presentation but makes good reading and will provide you with a really good understanding of all aspects of ERP implementation. The presentation begins with a project overview and states why the University needed to change. One of the strong points of the presentation is that it clearly outlines the hardware and software architecture being used. A comprehensive listing of all the costs involved as well as the quantifiable benefits is also given. Lastly, the presentation mentions how you can avoid implementation disaster and goes on to mention several good books that you can read relating to enterprise systems implementations.

A presentation I was certainly interested in reading was E-Business Suite Special Edition - benefits for small and medium sized enterprises. Oracle E-Business Suite Special Edition is Oracle’s Packaged Solution for midsize businesses. Key features are: -

• Pre-configured E-Business Suite 11i modules (packaged but tailorable)
• Rapid, fixed price, fixed scope implementation
• Ready to expand when you are 

The presentation contains a case study for Sunny Queen (Pty) Ltd - the largest egg supplier in Queensland. I’m hoping at a later point to try and provide readers with a bit more information on this release, in the mean time you can read more about E-Business Suite Special Edition at this Oracle Page

Another presentation of interest was Leadership in Leasing by Brett Kennedy. The presentation discussed the leasing industry in Australia, the leasing lifecycle and the platform and then finally took a look at the Oracle Lease Management Solution. I was interested in the presentation primarily because I didn’t realise Oracle had a solution for Lease Management. After reading the presentation it became clear to me that this was only released in 11.5.8. The presentation states Oracle’s commitment to leasing as follows: -

• First Production Release 11.5.8, Dec 2002


• Joint Development with GE
• Current Release 11.5.9


• New functionality - syndications, asset terminations. Multi-GAAP
• Australian Launch of Lease Management, Feb 2004


• Local Training, Implementation and Support Capability
• Next Major Release 11.5.10, due mid 2004
• Significant Resources


• Effort has been underway since 1999
• Deep Leasing Experience on Oracle Development Team
• Many Enhancements to Existing Products
• Significant Investment by Oracle Consulting and Partners Since Inception

I liked the Value Proposition slide which had an interesting “graph” and states: -

A lease management solution delivers significant profitability improvement, through cost reduction and better operational control, scale economies for future growth and reductions in the cost of capital.

The presentation also clearly outlines the lease business flows.

I was interested to see the screen shots of the Oracle Lease Management solution as most of the interface seem to be web based (using Java Server Pages - JSP’s) which makes me think that Oracle is moving more towards a web based solution than using forms. The very last section of the presentation also has some cool looking Oracle Discoverer reports.

Customer Relationship Management - (Oracle E-Business Suite 11i) Track

Supply Chain Management - (Oracle E-Business Suite 11i) Track

Friday, July 23, 2004

Oracle Financials R11.5.9 at Stanford University

Recently I came across the Oracle Financials site at Stanford University. This post contains a review of the various sections of the site.

The Oracle Financials Site at Stanford University is an excellent resource for anyone interested in learning and reading about Oracle Financials implementations. Being a University, the site gives you a good idea of how Oracle E-Business Suite can be implemented in a Higher Education Institute. It’s also interesting to note that Stanford has recently upgraded to the latest version of Oracle E-Business Suite, namely R11.5.9. You can read about Stanfords Upgrade from 11.5.8 to 11.5.9 here. The Oracle Financials System site is categorised in to the following sections: -

• Learning Centre
• Chart of Accounts

According to this page: -


The Chart of Accounts is the underlying structure for organizing financial information at Stanford. Stanford adopted a new Chart of Accounts along with the new Oracle Financials system in 2003. News and general information about the Chart of Accounts and associated issues may be found here.

In the news item "What is the Chart of Accounts" the University explains: -

The Chart of Accounts is the set of codes used to classify and record financial transactions in meaningful ways. These codes enable Stanford to: -


• identify specific “pots” of money; 
• specify what that money may be used for; and 
• record the transactions related to that money


By fulfilling the above functions, the Chart of Accounts also: -


• facilitates financial reporting;
• provides a framework for understanding the financial results of Stanford’s operations; and
• controls how financial transactions and balances are collected and stored in the Oracle system




Under this news item you will also find the Universities Chart of Accounts Segment Structure as well as mapping tables and spreadsheets which outline how the legacy Chart of Accounts translates to the new structure.

• Authority
• Reporting
• iJournals
• Purchasing
• Reimbursements
• Labor Distribution
• PCards
• Sunflower

Wednesday, July 21, 2004

WebDesignBlog - a new blog by Richard Byrom

This post contains details of a new blog dedicated to the design and build of Web Sites.

I’ve just launched a new block called WebDesignBlog - a definitive guide to designing and building web sites. The purpose of the blog is to create a web log and portal that is dedicated to the designing and building of web sites. Having been involved in the set up of my own web sites for the past year or so I decided to create a blog which could transfer the knowledge that I have gained to other members of the web community. There are certainly many sites which can give you information on designing web sites, however, I have not come across many blogs that can give you this type of information - hence I decided to start one.

Should you wish to participate in the blog either as an author or simply by being a reader, please register and let me know to what extent you would like to participate.

New Oracle Tutor, OPM, Order Management and Logistics Author

This post contains details of a new author that has joined OracleAppsBlog who has experience in the areas of Oracle Tutor, Process Manufacturing, Order Management and Logistics

Chris Killington - a technical writer and consultant who works directly for companies implementing Oracle 11i Tutor, as well as a Tutor Trainer/Consultant/Technical Writer for Oracle Corporation (when required) - has joined OracleAppsBlog as an author. He has worked in the Process Manufacturing, Airline and Education industries using the Tutor methodology to identify business processes, documenting them in the Tutor format, creating student guides, building online document repositories and conducting end user training. Chris has also worked as an OPM4.10.10 Order Management and Logistics consultant in Malaysia, and Order Management Consultant in China.

His Tutor experience spans 5 years. In this time Chris has implemented Tutor in Australia, New Zealand, China and Malaysia and has used the courseware output, from these implementations, to ‘speed up’ the learning curve for implementation teams in Europe and the United states.

I wanted to welcome Chris to the Blog and introduce him to all the other members. It’s not often you come across someone with experience in Oracle Tutor and I am sure his contributions in this area will be very useful to readers.

You can read Chris’ membership profile here or if you’re a member you can e-mail Chris via the profile e-mail console.

Friday, July 16, 2004

Online Business Office Environment at Yale University

This post takes a look at the Online Business Office Environment at Yale University, an ideal place for implementors of ERP systems to take a look at what types of documentation should be prepared when undertaking an implementation.

Recently I discovered the Online Business Office Environment (OBOE) Site at Yale University. I felt it’s the type of site that would give implementors of ERP Systems an idea of what types of documentation would need to be prepared. The thing I’ve always believed with ERP systems is that clients, implementors or consultants do not make enough effort to document the processes. Even if the processes are documented, the knowledge of how the new process is executed is not adequately transferred to those making use of them. Placing this information online and updating it frequently is one way of resolving these issues. It also ensures that continuous learning and education on systems and processes within the organisation is undertaken. Below I have highlighted the two major sub-sections of the Online Business Office Environment and provided a brief summary of what’s available in these particular areas. I am sure the information contained on this site will prove useful to implementors of Enterprise Resource Planning (ERP) systems and in particular Oracle Applications.

Learning Modules

This section contains user guides, training scenarios, tutorials and presentations for each of the following functional areas.

• Procurement


• i-procurement
• VIP - Contract Purchases
• WIP - Web Invoice Payment
• SWAP - Simple Web Allocation Process
• General Procurement
• General Accounting


• Journal Staging Area (JSA)
• Custom Commitments
• Receipt Identification Form (RIF)
• Labor Distribution (LD)
• FPM - Financial Planning and Management


• Data Warehousing Portal
• Budgeting - with Oracle Financial Analyzer (OFA)
• HR/LD/Payroll Reporting Using DataWarehouse Portal and Brio BUG
• Other Training


• System & Technology Access Request Tool (START)
• Training Management System (TMS)
• Human Resources and Payroll


• KRONOS Time Keeping System
• C & T Payroll (Casual and Temps)
• Casual and Student Payroll
• Casual Hiring

Policies, Procedures, Forms and Guides

This section of the site contains policies, procedures, forms and guides for the following functional areas: -

• Accounts Payable
• Purchasing
• Internal Services
• Information Technology Services (ITS)
• HR Services
• Payroll
• General Accounting
• Financial Management

There’s plenty of good reading material on this site - enjoy browsing it!

Thursday, July 15, 2004

Installing GNU Make for E-Business Suite

The Oracle E-Business suite R11i installation on a Windows platform requires certain software to be pre-installed as outlined below. Without this software up and running you will not pass the system installation check. The software is required to meet the interpolarity needs of Oracle Apps E-Business suite, allow linking of a Unix and Windows environment (Oracle Apps is designed to run on Unix platform), run patches, etc. MKS toolkit is an interpolarity tool (besides other professional uses) which allows users to make use of UNIX features on a Windows platform. Cygwin is another alternative to MKS. GNU MAKE will allow MAKE utilities to run alongside others under the command prompt. Installing GNU Make is sometimes a time consuming task. However, if all the steps are followed and nothing goes wrong, it can be a relatively simple installation.

Installation of GNU Make is required when installing Oracle Apps 11i. Following some simple steps will get the job done in a single go.

Before you begin:

• Check on Installation/Related Documentation at Metalink
• Browse the Oracle Applications Documentation Library or Oracle Store
• Examine the Getting Started CD which details all system and environment requirements.

Tips on preparing for Oracle Apps Installations

You need to follow some steps before you start the Rapid Install wizard. These are:

• You must have a domain up and running - for this you need Windows 2000 Advance Server with the Latest Service Pack.
• Create a user with Domain Level Admin Group Privileges.
• Install VC++ with the latest Service Pack (Note: where you install VC or any of the preceding software, directory names must not contain any spaces e.g. use ‘MSVisualC’)
• Whilst installing VC you must choose to ‘Register Environment Variable’ - this option is in the VC Install wizard. Alternately you could go to Control Panel> Systems Advance Tab Page / Environment Variables Button; edit the Environment Variable yourself as follows: -


• In systems variables find a ‘variable name’ Path, add your VC directories to it, then save and exit
• Without Environment Variables being registered it will not be possible to run executables from the command line.
• Install MKS Toolkit - It used to be available for trial download it doesn’t seem to be any more, alternately you can try Cygwin.

GNU Make Pre-Install Files

Before you install GNU Make download the following files from the utilities and from utilitiesdirectory: -

• Readme
• Djtarnt.exe
• Gunzip-.12.4-i386.exe
• Gzip-.12.4-i386.exe
• Tar-1.11.2-i386.exe
• Tar-1.11.2a.exe

You will require only two of them for this installation (Gunzip-.12.4-i386.exe and Tar-1.11.2a.exe)

• Rename these files as gunzip.exe and tar.exe respectively
• Copy and paste both files in to the system32 directory or alternately create a folder for these files and register it in environment variables.

Installing GNU Make for use with E-Business suite R11i.

• Download it from the GNU FTP site
• Download make-3.79.tar.gz or a later version
• Unpack the files using c:\folder_where_u_downloaded>gunzip make-3.79.tar.gz
• The files will be unpacked and extension gz will be removed.
• Now un tar the files c:\ folder_where_u_unpacked >tar –xvf make-3.79.tar
• This will create a new sub directory MAKE-3.79 under folder_where_u_unpacked
• Now test for VC environment with this command c:\make\make-3.79>vcvars32. this will give a message “petting environment for using Microsoft Visual C++ tools.
• Create a new sub directory MAKE-3.79 under folder_where_u_unpacked has a batch file build_w32.bat
• Run it from command prompt. C:\make\make-3.79\build_w32.bat
• If the build is successful check for a directory name winrel. It should have a file GNUKAME.EXE
• Rapidwiz checks for this file at installation time.
• You might have to run bat file twice for build to be successful.
• In case build is not successful, you could use a file LS.EXE (present in MKS Toolkit Subdirectory MKSNT), rename it as GNUMAKE.EXE and put it in the system32 folder. But this option is only a crude way of finishing your installation.
• Note that unzipping gnumake using winzip v7 or other zip utilities may rename the file config.h.w32 as config_h.w32. Other files may well be renamed like this one. This could lead to build failures.
• Lastly, you need to install JDK1.3.1 or higher.

You are now ready to install Oracle Apps E-Business Suite using rapid wiz! Good Luck.

Wednesday, July 14, 2004

Business need for Chart of Accounts - An Overview

The Chart of Accounts (COA) is the account structure the organization uses to record transactions and maintain financial account balances. Oracle General Ledger defines the COA structure in the Accounting Flexfield. The structure enables the organization to categorize accounting information during the recording process. The structure is comprised of multiple uniquely defined segments. Each segment contains a list of values, such as the list of Cost Centers or Natural Accounts. The various combinations of the segment values represent the unique account combination to which accounting transactions are posted and account balances are maintained.

When defining the Accounting Flexfield (COA) segments, Oracle requires one segment be designated as the balancing segment and one segment be designated the account segment. The balancing segment identifies an entity requiring a self-balancing trial balance, such as Company. The Account segment identifies the segment used to produce the Financial Statements such as Cash, Accounts Payable, or Revenue. Additionally, Oracle allows the designation of a cost center segment. The cost center segment identifies functional areas of the business such as Finance and Marketing. The cost center segment value is primarily used for reporting in Oracle Assets or Projects.

There are several constraints that should be adhered to when defining the organization’s COA in Oracle

• COA structure must contain at least 2 segments (Balancing and Natural Account) and no more than 30 segments
• Total length of segment combinations cannot exceed 240 characters
• Each Natural Account value must have only one Account Type (e.g. Expense, Asset, etc...)

Benefits of Common Chart of Account Structure

Some of the benefits of using a Common Chart of Accounts are the following: -

• Drives consistency of reported information across business units and ensures compatibility
• Reduces the effort to consolidate information to satisfy management requests
• Reduces reconciliation procedures
• Provides easier benchmarking between different business units/territories
• Allows ability to leverage staff between different business units
• Reduces learning curve due to commonality
• Provides a framework to introduce financial shared services

Chart of Accounts Impact on Reporting

The primary purpose of the General Ledger is financial reporting and financial analysis. The Chart of Account structure defines the nature, ranges, and groupings of information available for reporting and inquiry. Reporting is generated by ranges and groupings of values for one or more segments. Management must define the dimensions by which financial data will be analyzed and reported and ensure those dimensions are reflected in the segments contained within the COA structure.

Chart of Accounts Best Practices and Development Guidelines

Structure

• Determine the scope that the chart of accounts must support. The scope should begin with GAAP reporting requirements followed by management reporting requirements. Common examples of Management reporting requirements are Geographic Regions, Product Line reporting, Activities, and Cost Centers.
• Team members in the chart of accounts design process should be functionally aligned as opposed to geographically aligned. This facilitates the aim of developing a standard COA across global boundaries.
• Design a flexible chart of accounts that will reflect current business processes and accommodate organizational changes in the future. Consider future segments if involved in a high-growth, dynamic industry or environment.
• Each measured dimension of the business should be a separate segment. Segments used for more than one dimension limit the use of standard default values and complicates reporting by making data difficult to isolate. In addition, it precludes the user from using more than one dimension in an individual transaction. This also complicates the processing of consolidations and allocations, validation/security rules, and reporting.
• The resulting COA structure should be more horizontal in design with reporting across segments instead of using individual values for multiple dimensions.

Values

• Limit detail in values and report on information in the appropriate source (subledger) system unless the data is scattered among multiple systems. (e.g. create the minimum number of accounts for GAAP reporting of PP&E.  Create Asset Categories in Oracle Assets that “roll-up” to the respective natural accounts and report detail out of the Assets subledger)
• Product segments should be carefully considered for inclusion in the Accounting Flexfield Structure if there are extensive product lines. Try to identify major product lines for meaningful reporting in the General Ledger and look to the relevant subledger for detail reporting.
• Project segments may be considered if not using Project Accounting. Project Segments are not recommended if Project Accounting is to be used. All project reporting should be generated from the Projects subsystem.
• Carefully consider usage of summary accounts to capture information. Balances are stored at both the detail and summary levels and can negatively impact some concurrent processes. Summary Accounts may significantly improve FSG reporting.
• Avoid intelligent numbering (Assigning a meaning to every digit of a segment value). This complicates allocations and reporting.
• Avoid using dependent segments.  Allocations work off independent segments and may not function properly with dependent segments.
• Define segments as Character Type
• Avoid alpha characters in segments, except for parent values. Alpha Characters complicate sorting data, using ranges, assigning codes, and creation of validation/security rules.
• Use all capital letters for data entry.  This promotes consistency and simplifies query retrievals.
• Use parent/child relationships to facilitate reporting versus creating additional segments values.
• Assign segments in the most logical data entry order. Default segments should be at the very beginning or end of the accounting flexfield structure.
• Verify that you can perform complex allocation schemes.
• Document mappings to legacy chart of accounts. This will assist in populating conversion tables and in reconciling discrepancies.

Oracle Applications Evolution - A Complete Journey

This is a graphical representation of the Oracle Applications Evolution

Pre-Validate PSB Worksheet Option now available for Oracle Position Budgeting

This post discussses the pre-validate worksheet option for position budgeting which is now available in the Define Worksheet Form.

Recently when defining a PSB Worksheet I noticed that on the Define Worksheet Form (Form Name: PSBWCDWS) there is now a "Pre-Validate" button. The button is positioned on the bottom left hand side of the form and can only be used if you have checked the "Budget by Position" checkbox and specified a Position Extract (refer to Fig.1). I was curious to know what this button was all about as I hadn’t noticed it before and after some investigation discovered that it was a new feature released as a result of an enhancement request per bug no. 324574 on Metalink.

Figure 1: The Define Worksheet Form in PSB with the “Pre-Validate” Button

The Pre-Validate worksheet option is meant to proactively validate position records before starting the worksheet creation process. In other words, before starting the worksheet creation process you can separately validate whether the positions have the correct salary information and distributions for the worksheet. Previously there was no option to perform a separate validation of the positions outside of the worksheet creation process. This meant that one would have to run a potentially long worksheet creation process to determine whether the position information was correct. 

By clicking the pre-validate button two concurrent requests are launched, namely: -

1. Validate Worksheet
2. Position Worksheet Exception Report (Validation Results Report)

The Position Worksheet Exception report lists all the problematic position records. After you have eliminated any potential problems with the position information you can then run the worksheet creation process.

In order to "install" the Pre-Validate Button you will need to load Minipack J for PSB which will deliver the new version (11.5.44) of the Define Worksheet form.

Tuesday, July 13, 2004

An API for Element types

A new set of Oracle HRMS API’s has been published since HRMS Family Pack E which includes an API for element types and input values.

One of the consequences is that there is now a supported way to migrate the element types from a development environment to the production instance, aside from manually rekeying the elements.

I recently used the update procedure of the element type api to link a high number of element types to an event group for retronotification.

The names of the api’s involved are Pay_element_types_api and Pay_input_value_api.

Monday, July 12, 2004

New Oracle Process Manufacturing, Discrete Manufacturing and Enterprise Asset Management Contributor

This post contains details of a new author who has joined OracleAppsBlog and will be blogging under the Process Manufacturing, Discrete Manufacturing and Enterprise Asset Management Categories

Lokesh Tayal who is working as the Head of an Oracle Applications Group in one of the largest corporate houses in Dubai, is joining OracleAppsBlog. He will be blogging under the categories of Process Manufacturing, Discrete Manufacturing and Enterprise Asset Management. Lokesh and his team are implementing Oracle E-Business suite in nine group companies. Previously, he has worked with one of the largest Oracle Apps practices in the Asia Pacific.

Lokesh has rich experience in Oracle Enterprise Asset Management (eAM), Oracle Process Manufacturing (OPM), Discrete Manufacturing, Supply Chain and Project Management and has been working with Oracle Apps for the last seven years. He has been focusing on Oracle eAM for the past two years. Lokesh is a member of the Oracle eAM Customer Advisory Board and actively participates in defining this products future enhancements. He has implemented Oracle Apps in the Telecoms, Airline, Fast Moving Consumer Goods (FMCG), Real Estate, Metal and Plastic Manufacturing Sectors. You can read Lokeshes membership profile here or if you’re a member you can e-mail Lokesh via the profile e-mail console.

I wanted to welcome Lokesh to the Blog and introduce him to all the other members. I am sure his experience will add some interesting and useful content to the blog.