ApplTop Upgrades Product That Enhances Oracle e-Biz Suite


ApplTop Solutions says its flagship product, ASL*Form, a productivity tool for the Oracle E-Business Suite, has added a number of "major new features added to the latest release that help businesses make the most out of their investment in Oracle technology.

“Since its initial release, we have continually improved and added to the product to ensure that we can offer groundbreaking software that offers many benefits to any business that utilizes the Oracle E-Business Suite,” the vendor says.

A feature in the latest release (R2i v2.3.1) is the PRECOMPUTE Directive, which takes advantage of an Oracle database feature that ApplTop notes is “very much underutilized, the Materialized View.

“We have found that many users of ASL*Form are creating front-ends to an Oracle Applications-based data warehouse or core Applications Business Intelligence system where the data presented by the ASL*Forms is based on a very large volume of typically summarized information; before the current release of ASL*Form, these kinds of solutions could suffer with data retrieval performance issues in that the volume of data is just so huge that collating all the information could take a very long time. In this scenario we would usually recommend the use of a Materialized View but often the response to this was ‘a Materialized what?’ Taking this typical response in hand, we have added new functionality that means ASL*Form can take control and automatically create any underlying Materialized Views that are required thus ensuring ASL*Form query performance is always at its best.

“This new functionality helps keep solutions wholly within ASL*Form and reinforces ApplTop’s position as a customer-focused business. The new PRECOMPUTE Directive means that ASL*Form, standing on it own, can solve many more types of real business issues that many Oracle E-Business sites often face.

“A recent example of using this new functionality saw performance improvements of over 99%; we took a solution where the underlying query was taking over 10 minutes to return any data; using the PRECOMPUTE functionality we got this down to less than 2 seconds.

“The new functionality works by predetermining the results of the query at a specified interval or time. ApplTop say that so long as the data does not need to be completely real-time then the new functionality will help in many different scenarios.

“Another major new addition to the feature list that was also borne out of a client specific request is an improved security model. ASL*Forms’ ease of use and incredibly shallow learning curve means that the skills required to become productive with the product are minimal; this in itself means anyone from developers to functional consultants to power users can use the product effectively within a matter of minutes.

“If the ASL*Form builder tools are to be deployed to Power Users then the old security model could prove to be inadequate for some businesses. We have taken the old security layer built into ASL*Form and completely revamped it to ensure that the IT department can safely and securely deploy ASL*Form builder tools to non-technical, non-IT personnel. The new security model is very simple but also very powerful in that it ensures IT (or whoever owns ASL*Form) remains in complete control as to who can access what data. This new functionality means ASL*Form builder tools can be used by an even wider audience than previously possible.”

Founded during 1999 and based in England, ApplTop Solutions Limited is an independent software solution provider within the Oracle Applications complimentary software market.

  • Subscribe Newsletter
  • Contribute
Subscribe to ebizQ:

Enter your email address:

 Subscribe Blog Updates via RSS

 Subscribe News via RSS

ebizQ is very interested in what you have to say. To contribute an article, an opinion, or to become a blogger, please contact Peter Schooff.

  • Virtual Conferences
  • Webinars
  • Roundtables

SOA Cloud Qcamp

June 3, 2009

One of the most compelling trends in the enterprise business technology space over the past year has been the emergence of cloud computing. In ebizQ’s upcoming Qcamp virtual un-conference, leading industry experts and practitioners will explore the role of service-oriented architecture (SOA) and business process management (BPM) in supporting cloud-computing initiatives. Additionally, the new skills that developers and IT managers need for successful cloud development will be discussed.Register

View All Virtual Conferences

Smart Case Management: Why It's So Smart.

Date:Nov 05, 2009
Time:12:00 PM ET- (17:00 GMT)


Date:Oct 29, 2009
Time:15:00 PM ET- (19:00 GMT)

View All Roundtables
  • White Papers
  • Podcasts
  • Blogs

Joe McKendrick: Part II of II: Designing Evolve-ability into SOA and IT Systems

In part two of Joe McKendrick's recent podcast with Miko Matsumura, chief strategist for Software AG, they talk about how SOA and IT systems need to change and grow and adapt with the organization around it.

Listen Now

Phil Wainewright: Helping Brands Engage with Social Media

Phil Wainewright interviews David Vap, VP of products at RightNow Technologies, and finds out how sharing best practices can help businesses understand how best to engage with online communities.

Listen Now

Peter Schooff: Making Every IT Dollar Result in a Desired Business Outcome: Scott Hebner of IBM Rati

Scott Hebner, Vice President of Marketing and Strategy for IBM Rational, discusses a topic on the top of every company's mind today: getting the most from IT investments.

Listen Now

Jessica Ann Mola: Where Will BI Fit In? Lyndsay Wise Explains

In BI, this tough economy and the increasing role of Web 2.0 and MDM are certainly topics on people's minds today. WiseAnalytics' Lyndsay Wise addresses each of them in this informative podcast.

Listen Now

Dennis Byron: Talking with...Deepak Singh of BPM Provider Adeptia

Deepak Singh, President and CTO of Adeptia, joins ebizQ's Dennis Byron in a podcast that gets its hand around the trend of industry-specific BPM.

Listen Now
More Podcasts
  • Most Read
  • Quick Guide
  • Most Discussed

Quick Guide: What is BPM?

Learn More

Quick Guide: What is Event Processing?

Smart event processing can help your company run smarter and faster. This comprehensive guide helps you research the basics of complex event processing (CEP) and learn how to get started on the right foot with your CEP project using EDA, RFID, SOA, SCADA and other relevant technologies. Learn More

Quick Guide: What is Enterprise 2.0?

A lot of people are talking about Enterprise 2.0 as being the business application of Web 2.0 technology. However, there's still some debate on exactly what this technology entails, how it applies to today's business models, and which components bring true value. Some use the term Enterprise 2.0 exclusively to describe the use of social networking technologies in the enterprise, while others use it to describe a web economy platform, or the technological framework behind such a platform. Still others say that Enterprise 2.0 is all of these things. Learn More