The Feature

How to Make ‘Close Other Forms’ Option Updatable

December 12, 2008 on 10:20 am | by Marian Crkon | In Feature of the Week | Enter Comments |  Print |  Email

This feature of the week is for anyone using Oracle Projects 11i plus.

The Feature

When using certain responsibilities the ‘Close Other Forms’ option in the Navigator window, ‘Tools’ menu is protected against an update.

Solution

The function ‘Navigator: Disable Multiform’ needs to be included in menu exclusions of the given responsibility. As System Administrator:

• Navigate to Security > Responsibility > Define.
• Query the responsibility in which you want to allow to control the Close Other Forms option.
• In the Menu Exclusions, enter a function Name: Navigator: Disable Multiform
• Save changes.

The values are stored in FND_USER_PREFERENCES table by user. To see whether the checkbox is checked or not:

select * from fnd_preferences
where preference_name = ‘NEW_WINDOW_FLAG’

‘N’ means defaults to checked, ‘R’ means defaults to not-checked. We have had some inconsistencies with this checkbox. You would un-check it and exit the applications, and the next time when you log in, it’s checked again.

Recording Project-Related Receipt Accruals in Oracle Projects

November 25, 2008 on 9:27 pm | by Marian Crkon | In Feature of the Week | Enter Comments |  Print |  Email

This feature is for anyone using Oracle Purchasing, Payables and Projects 11i and beyond. I’ve been asked today to provide a solution for recording project-related receipt accruals in Oracle, and was very pleased when I found out this was a standard functionality. A summary of my research [from four different Oracle user guides] is available below.

Recording Project-Related Receipt Accruals

Oracle Purchasing records the received goods as delivered for your project when they are delivered and assigned to a project-related purchase order distribution line. When a purchase order line is flagged to accrue on receipt and the purchased goods are delivered to an expense destination, you can interface receipt accrual accounting entries from Oracle Purchasing to Oracle Projects as actual expenditure transactions. This allows you to recognize the cost to your project in the period in which it is incurred rather than in the period in which it is invoiced.

Interfacing Receipt Accruals to Projects

To interface receipt accruals from Oracle Purchasing to Oracle Projects, use the PRC: Interface Supplier Costs process in Oracle Projects. The process selects transactions based on the project-related values entered on PO distribution lines.

The process first retrieves all eligible accounted, project-related receipt accrual information, supplier invoice distributions (including non-recoverable tax lines) and all payment discounts that are distributed to project-related distributions. The process then interfaces the amounts to Oracle Projects.

The interfaced items are grouped into expenditure batches as follows:

• All invoice distributions, excluding non-recoverable tax lines, are included in one batch.
• Non-recoverable tax lines are grouped into a second batch
• Payment Discounts are included in a third batch, and
• Receipt accruals for project related items with a destination type of Expenses are grouped in the fourth batch.

Each time you run Interface Supplier Costs process, Oracle Projects generates reports you can use to track the interfaced supplier invoices distribution lines, receipt accruals, as well as those invoice lines and receipt accruals that are rejected during interface from Oracle Payables and Oracle Purchasing, respectively. The following reports show you the results of this process. These reports show amounts in the functional and transaction (AP invoice) currencies.

• The Interface Project Costs from Payables Report. Lists all invoice distribution lines and receipt accrual transactions that were successfully interfaced to Oracle Projects. In addition, summary information is provided to display the total number and total costs of the interfaced transactions.
• The Interface Project Costs from Payables Exception Report. Lists all invoice distribution lines and receipt accrual transactions that failed to interface to Oracle Projects during the process. For each transaction that fails to transfer, output reports list the rejection reason.

Submitting the Interface Supplier Costs Process

The PRC: Interface Supplier Costs process retrieves the following items and interfaces them from Oracle Purchasing and Oracle Payables to Oracle Projects:

• All eligible accounted, project-related supplier invoice distributions
• All eligible receipt accrual information from Oracle Purchasing
• Tax lines for project-related intercompany invoices
• All eligible accounted payment discounts that are distributed to project-related invoice distributions

The process first populates the Transaction Import Interface table, creating an expenditure item and cost distribution line for each invoice or payment distribution line, and an expenditure for each invoice. This process also checks for original items being adjusted when processing adjusting items from Oracle Payables, to ensure that every negative expenditure item adjusts a valid original expenditure item. If an original matching item is found, the process next checks to ensure that the original item is not already adjusted to have a net zero amount.

Select ‘Yes’ or ‘Accrued Cost Only’ in the Interface Supplier Invoices parameter if you want to interface supplier invoices. When this parameter is set to Yes or Accrued Cost Only, project–related supplier invoice costs are interfaced from Oracle Payables to Oracle Projects.

If an invoice distribution is matched to a purchase order line that is flagged to accrue on receipt and the receipt accrual information is interfaced to Projects, only additional invoice amounts are interfaced. These amounts can include tax or freight charges added during invoice entry, or price and exchange rate variances.

If Accrued Cost Only is selected, only additional invoice amounts are interfaced even when the receipt accrual information is not interfaced to projects. But if an invoice distribution is matched to a purchase order line that is flagged to accrue on receipt and fully interfaced to Projects, then for any invoice distribution matched to this purchase order line, the whole invoice amount will be interfaced to projects irrespective of the selected option.

Similarly, if an invoice distribution is matched to a purchase order line that is flagged to accrue on receipt and for which only additional amounts have been interfaced to projects, then for any invoice distribution matched to this purchase order line, only additional invoice amounts will be interfaced to projects irrespective of the selected option.

Select ‘Yes’ in the Interface Receipt Accruals parameter to interface receipt accruals. When this parameter is set to Yes, receipt accruals for project-related items with a destination type of Expense are interfaced from Oracle Purchasing to Oracle Projects.

Note: Receipt accrual entries are not interfaced if the received items are invoiced and the invoice amounts are interfaced to Projects.

Receipt Accrual Adjustments

You cannot adjust the expenditure item in Oracle Projects when the item is interfaced from Oracle Purchasing (i.e. receipt accrual).

If the invoice is matched to an accrue on receipt purchase order line and the invoice line (rather than the purchase order receipt) is interfaced, then the invoice line can be adjusted in Oracle Projects.

After you have made adjustments to supplier invoice items, you must send the adjustment information back to Oracle Payables so the Payables distribution lines match what is recorded in Oracle Projects. Oracle Payables will interface adjustments that affect the GL account number to Oracle General Ledger. You run the following processes in Oracle Projects for supplier invoice adjustments:

• PRC: Distribute Supplier Invoice Adjustment Costs
• PRC: Interface Supplier Invoice Adjustment Costs to Payables

If you need to change the invoice amount, supplier, or expenditure type, organization, or item date for a supplier invoice line, reverse the line and create a new line in Oracle Payables.

Troubleshooting the Projects to Receivables Interface

November 17, 2008 on 9:10 pm | by Marian Crkon | In Feature of the Week | Enter Comments |  Print |  Email

This feature is for anyone using Oracle Projects and Receivables 11.5.10 and beyond. There were several new features introduced to Projects 10.5.10 (Family Pack M), which now require additional [not quite documented] configurations for the Receivables interface to work. I find myself scrambling to make the interface work everytime I run it the first time in a new installation or a new operating unit. Here are few quick tipts I consolidated from the Metalink notes and user guides to remember what to do the next time…

Open Periods

Make sure to open respective accounting periods in Receivables. As Receivables Manager, navigate to Control > Accounting > Open/Close Periods.

Retention Error

You may not be using retention or multi-currency in Project Billing, but you still receive the “Transaction Code: TRA OU Level Retention Accounting flag N… Some transactions are disabled. Please Check auto-accounting setup” error when running the PRC: Interface Invoices to Receivables program (PATTAR).

To resolve the error you need to enable the AutoAccounting Assignments for Unbilled Retention Account and Rounding Account.

As Projects Billing Super User:

• Navigate to Setup > AutoAccounting > Assign
• Query up function ‘Revenue and Invoice Accounts’
• Define Segment Rule Pairings for the Unbilled Retention Account
• Define Segment Rule Pairings for the Rounding Account
• Make sure to enable the Function Transactions!

Again, you need to do this even if you do not intend to enable retention and multi-currency billing in your Implementation Options.

Sales Credit Type Rejection

You might get a ‘No sales credit type at Implementation or Projec Level’ rejection when running the PRC: Interface Invoices to Receivables program (PATTAR).

In order to resolve this error as Projects Billing Super User:

• Navigate to Implementation Options
• Select ‘Exchange Rate Type’ in the Currency tab
• Select ‘Sales Credit Type’ in the Billing tab

Transaction Source and Transaction Type Errors

The seeded Project Transaction Source and Project Transaction Types might be incomplete. Make sure to review and update these for your setting you defined in the Implementation Options > Billing tab. The source It is going to be ‘PROJECTS INVOICES’ (if new 11i or R12 implementation, or ‘PA INVOICES’ if upgraded from 10.7) and Transaction Types are going to be ‘Projects Invoice’ and ‘Projects Credit Memo’ (11i and beyond) or ‘PA Invoice’ and ‘PA Credit Memo’ (10.7) respectively.

As Receivables Manager:

• Navigate to Transaction Sources: Setup > Transactions > Sources
• Query up your Transactions Source you defined in the Implementation Options > Billing tab
• Make sure the Reference Field Default Value field = ‘interface_header_attribute1′
• Make sure the Standard Transaction Type = ‘Projects Invoice’
• Make sure the Credit Meno Batch Source = ‘PROJECTS INVOICES’
• Also navigate to Transaction Types: Setup > Transactions > Types
• Query up ‘Projects Invoice’ transaction type
• Make sure the Credit memo Type = ‘Projects Credit Memo’

How to Create Custom WebADI Integrators

November 11, 2008 on 10:40 pm | by Marian Crkon | In How To Guides | 5 Comments |  Print |  Email

Web Applications Desktop Integrator (Web ADI) is a self-service Oracle application, accessed using a browser. Unlike ADI, the  Web ADI software is not installed on individual client machines, as the processing takes place on the server rather than on individual client PCs.

Web ADI generates Microsoft Excel or Word documents on your desktop, and downloads the data you have selected from the application. You can modify the data in the Microsoft Excel or Word documents, working either online or offline, and upload the data using Web ADI. In addition to the Web ADI integrators supplied with Oracle Applications, you can create your own integrators to allow download and upload data from Oracle windows or direct from Web ADI.

Except for HRMS, it seems to me that other Oracle Development teams have not utilized Web ADI to its full potential.  There were some discussions in forums and Oracle blogs on whether this approach is even needed. I feel like every available interface and API that let you integrate with legacy or 3rd party applications should come with a standard Web ADI integrator.

Creating Custom Integrators

Thanks to the HRMS Web ADI, you can define your own custom HRMS and non-HRMS integrators and in a combination with the seeded Oracle APIs and interfaces, implement elegant solutions for downloading or uploading data. Examples for frequently used custom integrators include upload of employees, users, POs and requisitions, AP invoices, project events, AR transactions, etc.

Creating custom integrators is done by a system administrator. Let’s define an integrator to create employees to explain how to create custom integrators. Employees and employee assignments can be created using the standard HR_EMPLOYEE_API. Our custom integrator will upload data to this API.

Grant Access to Required Functions

As System Administrator, navigate to Application > Menu, and query up ‘Desktop Integration Menu’. Make sure to include functions required for respective integrators. In case of custom Create Employee integrator, you’ll need to include the following functions (no prompts are necessary):

• HR Integrator Setup Integrator
• HR Maintain Integrator Form Functions Integrator

Create ‘HR Integrator Setup’ Web ADI Document

• Log in as Desktop Integration responsibility. Select Create Document from the menu. The Settings page of the Web ADI wizard appears.
• In the Settings page, select a spreadsheet viewer in the Viewer field. Keep the Reporting check box unchecked, as this integrator is used to upload data to the database.
• In the Integrator page, select the seeded integrator “HR Integrator Setup”.
• In the Layout page, select the default layout “HR Integrator Setup”.
• In the Content page, select None.
• In the Review page, you can see full details of the document that will be created. Choose the Back button if you want to change any of the information, or choose the Create Document button to continue.
• A spreadsheet document is created, containing all the fields you need to enter to create your own integrator.

• Define all fields to create your Create Employee integrator and upload it to the database.

Controlling Access to Custom Integrators

Custom integrators, like predefined integrators, must be associated with form functions. Follow the steps below to associate your Create Employee integrator with the functions required to define Web ADI layout and Web ADI document.

• Select Create Document from the Web ADI menu.
• Select a spreadsheet viewer. Leave the Reporting check box unselected to download data for updating.
• Select HR Maintain Integrator Form Functions Integrator.
• Enter the Application Short Name (for example, your custom application name). Optionally, enter the integrator name.
• The displayed spreadsheet shows your selected custom integrators, and has a column for associating form functions. Enter the form function required for controlling access to the integrator.
• Upload your changes to the database.

Define Layout of Custom Integrator

Each integrator must have at least one layout specifying the columns to appear in the spreadsheet. To define a layout:

• Choose Define Layout from the Web ADI menu. The Layout page appears.
• Select the integrator for which you want to define the layout, and choose Go.
• Choose the Define Layout button to define a new layout.
• In the Define Layout page, enter a unique name for the layout. This appears whenever the user is required to select the layout, so should clearly indicate the purpose of the layout.
• Enter a unique key. The key is used internally by the system to identify the mapping.
• The Field List defaults to the complete list of columns available in the view or API.
• Choose Continue. In case of Create Employee integrator, the layout is based on the the HR_EMPLOYEE_API columns. In the next page, you select a subset of these fields to include in your layout.

Create ‘Create Employee’ Spreadsheet

And finally, using the custom integrator and layout defined above, create a new ‘Create Employee’ WebADI upload spreadsheet:

• From the Navigator window (Oracle Personal Home Page), click on ‘Desktop Integration’ responsibility. The Settings page of the Web ADI wizard appears.
• In the Settings page, select a spreadsheet viewer in the Viewer field. Keep the Reporting check box unchecked, as this integrator is used to upload data to the database.
• In the Integrator page, select your new integrator ‘Create Employee’.
• In the Layout page, select the default layout “Create Employee”.
• In the Content page, select None.
• In the Review page, you can see full details of the document that will be created. Choose the Back button if you want to change any of the information, or choose the Create Document button to continue.

• A spreadsheet document is created and ready to use for creating employees.
• Save a local copy to your PC.

Application Blogs I Read and Why You Should Too

November 10, 2008 on 10:40 pm | by Marian Crkon | In Worth Noting | 15 Comments |  Print |  Email

Here is an updated compilation of application-related blogs I read and know about at this point.

AppsBI : Applications Business Intelligence By Nilesh Jethwa. Nilesh has worked on various reporting, Data warehousing, Daily Business Intelligence, Discoverer and Enterprise Planning and Budgeting projects and wants to share and write about different BI tools and techniques. He enjoys his job and starting this blog adds a new adventure to his life and career.

Big4Guy

Big4Guy is an online resource by an anonymous author with the latest news, insights, knowledge and experiences as a Big 4 consultant. He discusses some of the important issues which organizations are facing today in the areas of information security, security and controls in SAP R/3, Oracle Applications, J.D.Edwards, Peoplesoft and various other ERP’s. He also provides valuable resources for individuals interested in the CISA, CISM, CISSP, and various other security certifications considered essential for entry in any Big 4 accounting, auditing and consulting firms.

BlogERP: HCM Software Blog

By James Holincheck. James is a Research Vice President in Gartner Research where he covers the human capital management software market.

Deal Architect

By Vinnie Mirchandani. Vinnie is a former technology industry analyst (with Gartner), outsourcing executive and entrepreneur. He has personally helped clients evaluate and negotiate technology contracts worth billions of dollars, and has consistently advised companies on IT risk management, globalization and sourcing issues. A MUST READ!

ERP Software Blog

By another anonymous author. There are several good links and articles to ERP-related stories.

Grey Sparling PeopleSoft Expert’s Corner

By a group of authors at Grey Sparling Solutions. This is a company website turned into a blog with plentiful resources of information for Peoplesoft and Oracle users and buyers. These guys don’t know it but they were a great inspiration and influence on creating this blog. They do not play the usual blogging game with links and tags to improve their Technorati ranking. Instead, they focus on creating an original, expert content useful to their audience.

FIN-SIG Blog

The OAUG Financial Services Industry Special Industry Group (FIN-SIG) is affiliated to the Oracle Applications Users Group (OAUG). The FIN-SIG shall fill a gap for a common forum and support/ resource base for all new and existing Oracle Applications users who operate in the space commonly called Financial Services Industry and also users who have interest in the specific packaged application software provided by Oracle Corporation to meet specific business needs of the Financial Services Industry.

Learn DIscoverer Blog

By Darlene and Michael Armstrong-Smith. They are the authors of the Oracle Discoverer 10g Handbook. Their company Armstrong-Smith Consulting specilaizes in everything Oracle Discoverer.

Learning ERP Systems

Discussion of challenges, ideas, and suggestions for improving ERP application training in the corporate workplace.

Learning of an Oracle Apps Consultant

By Krishanu Bose. Krishanu covers Oracle Apps consulting services situation and provides an inside view of Oracle Apps outsource services in India.

Mark Rittman’s Oracle Weblog

Not really an application blog, but one of the original Oracle blogs out there and an excellent production by Mark Rittman. Personally, this is to me a never-ending source of inspiration for how a corporate blog should be done. Read more about Mark and his blog in this story.

Oracle AppsLab

By Paul Pedrazzi, Jake Kuramoto, and Rich Manalang. In their own words, “Oracle AppsLab is a think-tank developed to drive adoption of new web patterns and technologies across Oracle’s business and products. We’re a small group dedicated to living and breathing Web 2.0. This blog is our space for sharing our ideas.”

OracleAppsBlog

By Richard Byrom and a group of authors. OracleAppsBlog is THE ORIGINAL Oracle application blog. If you search the web for anything related to Oracle Applications, the chances are you end up at OracleAppsBlog - a rich resource of Oracle-related links and information. Read 10 questions for Richard to find out more information about him and his blog.

Oracle Apps Confessions

By Jo Davis, Oracle eBusiness Suite functional consultant. A compilation of quick tips and tricks for Oracle Applications users.

Oracle Apps Epicentrum

Sanjit Anand shares his implementation knowledge and experiences.

Oracle Business Intelligence Blog

By Abhinav Agarwal and Keith Laker. This is a blog for all things Oracle Business Intelligence. Includes musings and postings on Oracle Discoverer, OLAP, and other Oracle BI products, technologies and tools. Way to go guys! Personally, BI is as technical as I ever want to get with Oracle Applications.

Oracle Contractors Network Blog

Oracle eBusiness Suite resources, ideas, white papers, advice and tips from a number of Oracle consultants.

Oracle E-Business Suite Technology

By Steven Chan. An excellent Oracle insider’s take on technology stack-related topics for the Oracle E-Business Suite, with sneak previews of upcoming releases, new product announcements, glimpses into the inner workings of Oracle Development, in-depth discussions of technology-stack architectures, and the occasional desupport notice. Read more about the man behind this blog in my interview with Steven. A MUST READ for Oracle Applications DBAs, system administrators, and other Oracle professionals.

Oracle Financials Strategy

The blog where we talk about what’s on our minds as individual strategists and as a team. It’s where we share articles, ideas and opinions that are relevant to our work here at Oracle. However, we reserve the right to veer off topic occasionally. It wouldn’t be a blog without that - would it?

Oracle iRecruitment Blog

By Martin Millmore, a Director of iRecruitment Development at Oracle.

Oracle Intercompany Blog

By David Haimes. The primary focus of this blog is Intercompany and Oracle Financials. David is a 10 year Veteran of Oracle Financials Development. David is interested in technology both inside and outside of Oracle and is always thinking of how I can incorporate new ideas, technologies, methodologies or innovations into my work here at Oracle. David’s current role is looking after the Intercompany and Legal Entity products in Oracle Financials, he has also worked on EMEA Globalizations, Federal and Public Sector Financials, XML Payments and a variety of projects on other products.

Oracle Support Blog

By Chris Warticki. This site is Oracle Support. Chris has been working for Oracle Support for over 8 years. His team helps Oracle customers, offers free information and training sessions on a variety of Support related topics. Take advantage of his team’s experience and knowledge about our Support processes, policies, tools, tips, and tricks.

ORCLville

By Floyd Teter. Floyd is the System Engineer for Institutional Business Systems at the Jet Propulsion Lab in Pasadena, California. Floyd has been working with Oracle products since 1990 and Oracle applications since 1997, and even spent a few years as a Managing Principal with Oracle Consulting during the dot-com boom.

Parallax: Calculating Technology’s Future

By Neil Robertson, a CTO at Newmerix and a talented writer who became famous in the enterprise bloggosphere for his original analysis of Oracle Fusion in I Pity the Fool. Neil is also very active in establishing the Web 2.0 tools in the enterprise.

PeopleSoft Corner

By Brent Martin. Ideas, Tips, Techniques and information sharing for Oracle and PeopleSoft Enterprise.

Project Directions

Produced by an anonymous project strategy manager at Oracle working with the Oracle Projects application. According to his own profile, the author’s focus is on our Project Management and Project Collaboration but he hopes that this blog will encompass some of other [Oracle] modules with the use of guest bloggers, i.e. his colleagues who manage those modules.The author is also interested in how software can help project managers and teams be more successful especially given the proliferation of collaborative tools that we see now.

Project Lifestyle

By Andrew Sparks. Andrew is a Senior Practice Director at Oracle EMEA. He runs the EMEA International Projects practice. This organization is an international team of specialist consultants based throughout the EMEA region. The team acts as a single point of contact for delivering and remediating complex or multinational applications programs in the EMEA region.

Project Partners

This is FINALLY a company blog by two authors from Project Partners - Bob Anderson and Neeraj Garg. Project Partners regularly publish great white papers and newsletters for Oracle customers in the project-centric industries. The blogs are an excellent complement to this already fantastic resource.

Software Safari

By Brian Sommer. A “premium blog” by an experienced technology industry analyst.

Solution Beacon

Advise and opinions from employees of Solution Beacon, LLC, a provider of expert-level resources for the most widely used Enterprise Management Systems and Technologies.

Systematic HR

Systematic HR is a human resources blog about the intersection between HR process and HR technology. You can read about how HRMS systems, point solutions such as TAS, TMS, portals, etc, can be utilized to maximize your employee experience and enhance the strategic capabilities of your organization as well as the concerns of the day such as employee engagement, project management, and cost parameters to your strategies.

TalentedApps

Talented Apps is written by a group of Development and Strategy individuals within the Oracle Fusion HCM team. Their focus is on the industry and future of Talent Management…

Triora Group

This company blog is a way to “give back to the Oracle community”. You will find a growing amount of practical information you can use to improve your environment. Triora Group focus primarily on Oracle E-Business Suite 11i and 12, the Fusion Middleware and of course Oracle Database 10g/11g.

Yak About Apps

By Linda Fishman Hoyle, a a Senior Director for Cross Applications Marketing at Oracle and the Editor-in-Chief of a Podcast series called AppCasts. Linda has more than 20 years of experience with Enterprise Software and Services - marketing, strategy and business development. In Linda’s own words, “you want to read her blog if you are interested in the latest and greatest Oracle Application stuff!”

Usable Apps

Blog posts by some of the [User Experience] staff at Oracle. The posts vary in their scope and material, but they will give you a glimpse into what they think about new and emerging concepts that relate to enterprise applications.

Last, I would also like to mention blogs by Oracle Applications executives Jesper Andersen, Jim McGlothlin, and Luke Kowalski [see an interview with Luke]. We all appreciate their intention and effort to share their views and opinions.

Let Contractors Buy!

November 10, 2008 on 8:23 pm | by Marian Crkon | In Feature of the Week | Enter Comments |  Print |  Email

This feature of the week is for anyone using Oracle HRMS and Purchasing 11.5.10. When the contingent worker functionality was rolled out to Oracle Financials in this release, (see the original story from February 2006), the contractors could charge their time and expenses to projects, and have their costs calculated based on their time or purchase orders, and few other things.

Few months ago our implementation team at a local hospital in Seattle was surprised to find out that contingent workers were not allowed to enter or approve purchasing documents. Since a major part of the company’s supply chain was outsourced to 3rd party vendors, this was a major problem. It seems that other companies face the same problem, as documented in the bug 4534789 on Metalink. The business need can be summarized as follows:

“…Contingent workers who are allowed (in both business terms and in Oracle functionality) to have employees report to them and who can be entered into the requisition hierarchy do not have the ability to enter requisitions or approve their employee’s requisitions. This requires someone else to do that for them and that individual may not have the knowledge of whether the purchase is allowable or acceptable, creating delays and inappropriate approvals in the requisitioning process…”

Few Questions for Oracle Development:

• Can contingent workers buy in Release 12?
• Is this functionality going to be back ported to Release 11i?

If anyone has more information on the subject, I invite you to share it as comments on this post. Thank you!

Tips and Tricks For Oracle Key Flexfields

May 27, 2008 on 10:55 am | by Melanie Cameron | In How To Guides | Enter Comments |  Print |  Email

Key Flexfields are widely used in Oracle Applications. In general, they house the codes used by organizations to identify such things as part numbers and General Ledger accounts. Setting up these segments can improve the usability of Oracle, decrease the work load of the users, and increase data accuracy. The Oracle Key Flexfields Tips and Tricks paper will provide an overview of the options available and recommended best practices. When first setting up a Key Flexfield, there are some features that will greatly affect the usability and required maintenance. Read the white paper for more details…

E-Business Suite Financial Integration

May 12, 2008 on 9:50 am | by Melanie Cameron | In How To Guides | Enter Comments |  Print |  Email

Oracle E-Business Suite (EBS) consists of tightly integrated modules that result in a company’s financial statements. Tracking transactions through the system back to the source, then to the setups that affected the way the source transactions behaved is difficult at best. The Oracle EBS Integration Overview white paper (based on R11.5.10) will help you understand where these transactions are coming from, back through the interfaces to the transactions, then even farther into the setups dictating their behavior.

Tips and Tricks for Oracle FSGs

April 29, 2008 on 2:17 pm | by Melanie Cameron | In Feature of the Week, How To Guides | Enter Comments |  Print |  Email

Financial Statement Generators (FSG’s) are a necessary evil at any company running Oracle’s E-Business Suite General Ledger. Row Sets, Column Sets, Content Sets, Parents accounts or Ranges, Publish with XML, ADI. . .the combinations and possibilities are endless. And the decisions you make when creating and maintaining your FSGs can affect their ease of use and maintainability in the future.

See my Tips and Tricks for Oracle FSGs white paper for Best Practices, Tips and Tricks to making this task a little more manageable and less time consuming. When working with FSGs, perhaps the most important thing to remember is the FSG functionality is old. I have been a heavy user of General Ledger for 13 years, and except for generating outputs, it is basically the same.

That means that the majority of older installs (implemented prior to 11i) had one-off patches that greatly affected the way FSGs behave. A report created three years ago that is copied or mimicked for a new report-well, they just give different results. Research shows the new report is behaving as Oracle documentation explains it should, but the old report is not.

So I leave you with my biggest tip of the paper: Tip: If it works, don’t change it! See the while paper for more details…

Conversation with the Team from PPM Energy

March 6, 2008 on 9:40 am | by Marian Crkon | In Conversations | 2 Comments |  Print |  Email

Last fall, I had an opportunity to spend some time in beautiful Portland, OR, assisting a talented group at PPM Energy with their calendar changes in Oracle Applications. PPM energy builds and manages wind turbines and sells alternative energy. I invited two of their key Oracle users - Lori Thibodeaux, a financial systems manager, and Kevin Kosub, a senior business systems analyst, to a have conversation about their lives with Oracle. Read on for few excerpts below.

Marian: Let me start by asking what Oracle products/applications does PPME currently use?

Lori: We use the full Financials suite, including iExpense and iProcurement, Inventory, Enterprise Asset Mgt (EAM), Project Costing and HR. We are also using Discoverer for adhoc reporting.

Were you involved in picking Oracle EBS? Why was Oracle chosen over other ERP solutions?

I came on board after the selection of Oracle was done. However, I do know it was picked over other solutions because of the ease of implementation. We implemented Oracle in about six months.

How would you describe the original implementation? What were your main lessons learned?

I would describe the implementation as fast and “vanilla”! We did not have time for any customizations. The lessons learned were we wish we had a better grip on our business processes before configuring the system. We have made quite a few changes and enhancements to configuration post implementation.

Did you take the same approach to all applications? Were some applications or processes easier to implement than others?

Project Costing was the hardest to implement.

You did not have to think too long about that one…

Mostly because of all the set up decisions that need to be made.

If you had three recommendations for other people implementing Oracle EBS, what would they be?

Make sure you have a good executive sponsor for the project. One who has the authority to set down expectations and resolve disputes.

Make sure the business users are invested and integrated into the project. If their days jobs can be backfilled, even better.

Get a good consulting partner with expertise across the Oracle apps. It is best to have people who understand the processes from cradle to grave and how they flow through Oracle.

Speaking about users, how did they accept the new system and the change in general?

In our case they didn’t have a choice. Our parent company sold off the division that hosted the applications we were using.

Kevin: Users were learning the business processes as well as the system.

The EBS applications are sometimes criticized for being overly complex and not very intuitive. How did you make sure people learned the new tools quickly?

Lots of training and as much documentation as we could put together in the short time we had.

We had some cases where we didn’t have enough business insight to our new processes to drive the configuration appropriately upon initial set up. Later once the insights were gained we had to make tweaks to configuration, which were easy in some instances and painful in others.

Which processes or functions posed the biggest challenges?

We are still suffering from the lack of user training, especially in Projects and procurement. Projects has been problematic because we do not have a [ready process in place] real system savvy super user.

Procurement has been problematic because of some bad configuration decisions at the time of implementation. We were initially set up to accrue upon receipt for expense items - a bad decision!!! This has created a reconciliation nightmare! We changed over to accrue at month end about a year ago.

Additionally we had users who were wearing two hats for configuration responsibilities, as well as performing normal operations.

One pain point I have is the procurement hierarchy maintenance. Our hierarchy is based on HR Positions. Unfortunately, it is policy in our HR to change positions fairly frequently. When they do this, the old position stays in the hierarchy without a person attached. I have to go re-add the new position to the hierarchy to fix it.
I have been told, and I believe it, this issue has been addressed in R12.

Kevin, I know you have some experience with SAP too. How would you compare it to Oracle?

There are both positives and negatives with both of those ERP systems. All of the SAP environments I was a part of were heavily customized. There were a lot of changes to custom development and SAP had sophisticated tools for migration between development environments. SAP seemed to have better out of the box reporting capabilities as well.

On the other hand, SAP can be overly engineered and be difficult to configure.
Oracle is relatively simple with the user interface and out of the box configuration, which is a positive for a mid-size company Security administration is also much simpler in Oracle.

Are you planning to stay on 11i, upgrade to R12, or wait for Fusion?

I like some of the changes I see in R12, like the SLA engine. Not having to log into each operating unit separately is very nice! I also like that they are getting rid of the client version of ADI. It is high maintenance! I also like the look and feel of R12.

I would like to start planning for an upgrade to R12. However, our new parent company is running SAP. We may be forced onto SAP in the next couple of years. Fusion is probably not in the picture for us. From what I have seen, Fusion isn’t a viable option for anyone in the near future. I think it is years away.

I see a lot of positive changes with R12. It would nice to simplify our sub-ledger configuration and maintenance as well as enhance some reporting capabilities.

Are you referring to BI Publisher? Or reporting in general?

We are currently using XML Publisher for report output. I look forward to expanding our use of this tool.

Well that is an option but a lot of existing DBI-like dashboards are standard with R12. We are also considering other tools like Noetix to supplement our reporting options.

Let’s switch gears just a little. I know you are very active participants in the local OAUG activities. What can we do better as a user community?

I try to go to activities as they seem appropriate. I like the NWOUG conferences. It is a good networking event.

I am relatively new to the OAUG. From what I have seen, it is a positive experience

What Oracle resources (Metalink, oracle.com, podcasts, conferences, etc.) best provide you with the information you need?

Metalink is a good resource, however, the search capabilities could be improved.

Metalink is a staple. It takes some time to figure out how to maneuver through all the info out there. [Our colleague] Keith has had 10 years of experience with it, so he is pretty good at finding things.

Sometimes I spend more time searching than reading relevant information on my issue.

I am still learning. As a manager in my previous jobs, I didn’t search Metalink very much. Now I need to and I find it a little challenging to get to the right information. I have used Google as a search tool and sometimes have better luck there.

Oracle University classes are also a good resource for learning new products.

Oracle.com is a sales site. I don’t go there for hard information. I haven’t ever used podcasts. I went to Oracle World last November. In my opinion it was way too big. I ended up networking only with people from Portland, which I didn’t have to travel [to San Francisco] to do.

Yes, I agree. Oracle University’s training is very good! We have had trainers come up to Portland to put on classes just for PPM employees. This worked out very well!

Thank you so much for your time and opinions! This was fun!

Thanks.

Thank you, bye!