Skip to main content

Author: pitss

PITSS auf der APEX Connect ’25

PITSS auf der APEX Connect ’25
13.-15. Mai 2025 | Europa-Park Rust

Die fließende Modernisierung von Oracle Forms nach APEX

 

Stuttgart, 17.04.2025 – PITSS ist dieses Jahr als Sponsor auf der APEX Connect vom 13.-15. Mai im Europa-Park Rust dabei. Außerdem zeigt APEX-Experte Stephan La Rocca in seinem Vortrag, wie Datenstrukturen auch in langjährigen, gewachsene Oracle Applikationen zu durchleuchten sind. Die APEX Connect ist die führende deutschsprachige Fachkonferenz für Oracle Application Express (APEX) und bringt jährlich rund 400 Teilnehmer – Entwickler, wie auch Anwender – aus der APEX-Community zusammen. Sie bietet eine Plattform für den Austausch über aktuelle Entwicklungen, Best Practices und innovative Lösungen im Bereich Low-Code-Entwicklung. 

Die APEX Connect ist die Fachkonferenz rund um APEX, PL/SQL und deren Lösungen. Neben neuen Features, Best Practices und Performance Tuning geht es auch um konkrete APEX-Projekte, technische Herausforderungen, Vorgehensmodelle und visuelle Highlights.

Eine besondere Empfehlung geben wir für den Vortrag: “Wie  cool wäre es, ein ERM in Aktion zu sehen?” am 13.05.2025 um 13:00 Uhr im Raum Sanssouci mit unserem geschätzten Kollegen Stephan La Rocca, Head of Development bei PITSS. 

Der Vortrag zeigt, wie man ein bestehendes Datenmodell einer langjährigen Applikation analysieren kann – und zwar nicht isoliert, sondern im Zusammenhang mit den darauf basierenden Anwendungen. Ziel ist es, die tatsächlichen, in der Praxis genutzten Verbindungen zwischen den Tabellen herauszufinden.

Stephan kann aus jahrelanger Projekterfahrung berichten: “In der Praxis stoßen wir oft auf Datenmodelle, die schon viele Jahre alt sind – manchmal Jahrzehnte – und bei denen Begriffe wie Foreign Keys kaum eine Rolle gespielt haben. Wenn man solche Modelle modernisieren will, ist es aber wichtig, die Beziehungen zwischen den Tabellen genau zu verstehen und zu erkennen, welche Rolle jede Tabelle im Gesamtsystem spielt.” 

Besuchen Sie Stephan’s Session  und lassen Sie sich von den Analysemöglichkeiten von Oracle Applikationen begeistern! Der Vortrag enthält zahlreiche Demos und Beispiele, um die Abhängigkeitsanalyse und ihren Nutzen zu veranschaulichen. 

Über die APEX Connect
Die APEX Connect ist mit über 80 Vorträgen und Workshops sowie über 400 Besuchern die größte deutschsprachige Fachkonferenz rund um Oracle APEX (Application Express) – eine Low-Code-Plattform zur Entwicklung moderner Webanwendungen. Sie richtet sich an Entwickler:innen, Architekt:innen, Administrator:innen sowie IT-Entscheider:innen, die mit Oracle-Technologien arbeiten. Die Konferenz wird von der DOAG (Deutsche ORACLE-Anwendergruppe e.V.) organisiert und findet in diesem Jahr zum 11. Mal statt. Veranstaltungsort ist der Europa-Park Rust in Deutschland.

PITSS-Vortrag:
Wie cool wäre es, ein ERM in Aktion zu sehen?
Stephan La Rocca
13.05.2025 | 13:00 Uhr | Raum Sanssouci

PITSS-Stand:
Schauen Sie doch  bei uns vorbei!

Termin vorab vereinbaren?
Dann melde Sie sich gerne:
Stephan La Rocca, Head of Development bei PITSS
Harald Wagner, Senior Sales Manager DACH bei PITSS


POPULAR POSTS


Modernization

Why and how to modernize legacy applications efficiently

Read more


Sponsorship project

PITSS is awarded a BMBF funding project for digital software documentation

Read more

 
 
 
 
 
 
 
 
 
 
 
 
 
 

Your Contact

Uta Daniels Assistant
of Sales Management

udaniels@pitss.com

+49 711/914-012-12











Continue reading

PITSS at APEX Alpa Adria 11.04.2025 in Zagreb

PITSS AT APEX ALPE ADRIA

11.04.2025 | Zagreb

Strategies and how-to’s for the seamless
integration of Oracle Forms & APEX

 

Stuttgart / Zagreb, 31.03.2025 – The modernization expert PITSS is looking forward to this year’s international event “APEX Alpe Adria” on April 11 in Zagreb, Croatia. The event is all about APEX. PITSS Head of Development Stephan La Rocca, will talk about “Forms + APEX side by side”. The focus is harmonious UI integration between Oracle Forms and APEX

Even if the decision has been made to modernise the entire Oracle Forms-based application to APEX, this project is not completed in one weekend. Larger projects use an established staged approach for modernisation, which enables a continuous transition to the new technology. For users, however, this means a phase of coexistence between the two technologies.

This requires harmonious UI integration between Oracle Forms and APEX. The presentation will highlight the different integration and communication paths that can be considered for such an integration on the different levels (client or server-side).

Join Stephan’s session and experience client-side and server-side solutions, with practical demonstrations and real-world code examples to showcase how these methods work in action. Friday, April 11 at 9:50 a.m. /  Room 3.

About APEX Alpe Adria
APEX Alpe Adria is a co-project of APEX enthusiasts of three countries: Slovenia, Croatia, Austria. Together, they saw the need for an APEX event in the region. Attendees are welcome from everywhere. The first conference in 2018 was a blazing success with 190 attendees. The second edition in 2019 had a participation of 280 attendees, followed by a post-pandemic third edition in 2022 with almost 200 attendees! Last year’s Apex Alpe Adria in Maribor, Slovenia, was once again a great success with around 240 attendees. Enjoy also in 2025 a day packed with APEX.

Presentation:
Stephan La Rocca
Forms + APEX side by side
April 11 | 9:50 a.m. | Room 3


POPULAR POSTS


Modernization

Why and how to modernize legacy applications efficiently

Read more


Sponsorship project

PITSS is awarded a BMBF funding project for digital software documentation

Read more

Your Contact

Uta Daniels Assistant
of Sales Management

udaniels@pitss.com

+49 711/914-012-12











Continue reading

PITSS awarded contract for BMBF sponsorship project for digital software documentation

PITSS awarded contract for
BMBF sponsorship project for
digital software documentation

Interview with Andreas Gaede, CEO PITSS

Nowadays almost every company has comprehensive IT systems, the majority of which have a long history. Business applications, that have grown over decades, confront decision-makers as well as the IT team with great challenges. What is today modern and future-proof can already be outdated by tomorrow and become an obstructive legacy. One therefore needs the possibility, to be able to appropriately further develop applications – in the sense of sustainable application development.

The modernization experts of PITSS focus their research and development precisely in this field. They revolutionize the application development by building on product-based methods and transferring the values of old applications into a modern IT world. This innovative thinking and acting has now been commended as a BMBF sponsorship project.

Mr. Gaede, with your research project “Soft Proc, Development of methods for the retrograde process analysis from a running application” you will be sponsored by the BMBF. Can you briefly explain to us what it is about?

Software developments or modernization projects fail, are delayed and consume enormous sums of money. One main reason for this is the manageability, which in most cases can be traced back to the lack of documentation of the implemented software. Because only the person who understands and penetrates the software can also meaningfully work with it. Well documented software saves enormous costs, avoids errors and enables easy entry for new colleagues or new development partners.

We all know, that in practice applications or requirements are in most cases developed under time constraints, savings are made in the documentation. As soon as the applications have to be adapted or expanded, this sparse documentation is no longer of any help, instead it causes further irritation. As a consequence the costs and times explode, just as the entire project.

That is why, with SoftProc we are developing a new product, that analyses an implemented application with everything that distinguishes it, from program code through to its productive processes, and assembles it into an image that can be understood by everyone. A kind of real-time documentation, which is fed with the latest program versions and with productive data from the running applications. This new knowledge makes decisions possible again and implementations simple and reliable.

And there is nothing like that up to now?

No. There are indeed analysis tools, which deal with source code and code quality, but none of these consider the complete application up to the real processes. That is an absolutely crucial point, because only the knowledge of how the users handle the application specifies how the program code really works. A dependency on former developers no longer exists, one learns and understands the software by using it.

A major buzzword of today’s IT is “Process Mining“, where one makes use of the so-called logfiles, in other words log data, in order to interpret a real process. What works well for standard products turns out to be hardly solvable for individual applications. We therefore rely on this new type of approach, which records, analyses and displays all components of an application in an understandable form – SoftProc.

What kind of product will emerge as a result?

In the next two years we will launch products on the market, that analyze applications and present the information acquired in an attractive form – also as Cloud solutions. A main focus of the research thereby is the visualization of the different items of information from the application, oriented to the respective issues of the viewer, such as e.g. code quality, object uses, function chains, sequences, test coverage, data throughputs or performance aspects. These new products will put organizations in the position of being able to quickly and reliably make the right decisions and implement development projects swiftly, targeted and successfully.

For which organizations, persons, situations and requirements will this software be developed?

Our software is directed at all organizations and branches that develop their own IT systems. The benefit increases dramatically with the size, in other words the complexity of an application, since large applications are, of course, the most difficult to penetrate.

Our products have for many years provided reliable decision-making bases for responsible persons up to CIOs, CTOs, CDOs etc., based on their own systems, without the need for in-depth IT knowledge. The products are also intended for architects and developers, who want to plan information-based and work target-oriented.

In this day and age we are subjected to a high degree of pressure and many influences. Frequently changing market conditions, company strategies, business relations, regulations etc. make fast acquisition and implementation necessary. Or the companies expand, merge, develop new business units and they cast all that in software, couple systems, design interfaces or expand existing ones. This highly dynamic interplay of business and IT processes, always documented up-to-date, creates an optimum of effort and costs with maximum quality.

By which research partners are you accompanied and what role do they play?

For scientific expertise Herr Prof. Dr. Manfred Reichert, Head of the Chair DBIS – Institute for Databases and Information Systems – University of Ulm, provides support. He researches and teaches with his team in the field “Development of Innovative Technologies for Business Process Management”. Prof. Reichert is one of the pioneers in the field of agile Process-Management-Technologies. He has published a variety of publications on this subject, has been distinguished several times and enjoys an international reputation as visionary. His expertise and that of his institute is already available to our customers during the ongoing sponsorship project, in order to have their valuable experience and expectations flow into the development of the product early on.

Even at an early age I was fascinated by the representation of analog actions and work sequences in a variety of programming languages. As a mechanical engineer I was also fascinated by the constantly increasing degree of automation, that one had been striving for a long time already in manufacturing and production processes. Thereby, ever since I can remember, the manageability – in the form of documentation – the reusability of process steps as well as simple sequences is at the forefront, because it decisively determines the degree of automation.

Maybe that’s where the motivation came from and the vision, to develop products that have a very high degree of automation, in order to be able to master the tremendously fast transformation in IT with the challenges of digitalization and never ending modernization.

To be sponsored by the federal government is a great distinction. What significance does that have for you and your company?

To be among the Top 50, chosen from over 6000 highly innovative project approaches, naturally makes us proud. But more importantly it is an appreciation for the enormous commitment of all PITSS employees over many years and for our product-based approaches, to optimize software development by means of intelligent automatisms.

At this point my very special thanks go to the PITSS Team in the USA, UK and Germany, the companions, families and friends, as well as our many customers in over 40 countries worldwide, who have made this recognition possible. For years we have been able to measure our performance in our projects against IT service providers and software departments, who adhere rigidly to the traditional, personnel- and cost-intensive – but also error-prone – course. Even if here the concern for something new still outweighs the unknown, we notice, that more and more companies are searching for innovative, practicable ways.

The enormous potential that products such as SoftProc can have for the IT in companies, has been recognized by the academic specialist committees and honored with the sponsorship project. Here our thanks go to the Federal Republic of Germany, specifically the BMBF, for the support of our innovative ideas and approaches. That confirms our decision, to expand our Research & Development and the practical testing in the areas of the latest software development.

What significance do research projects such as yours have for our economy?

The thinking in Germany is more reserved and conservative. Experienced, one rests on the laurels of our car manufacturers and mechanical engineers. When it comes to IT, which will inevitably determine our future, after SAP or a unicorn such as Celonis, it gets quite sparse. It would be very sad, if Germany, as the land of poets and philosophers, would oversleep the striving to network everything analog into digital. To pursue innovation means, to promote ideas wherever they occur. For this reason, here our thanks again to the BMBF with its KMU program, that specifically promotes small and medium-sized companies, in which so many ideas and innovations lie dormant.

In comparison to the leading IT nations we are still far behind. To change something here requires a change in our mindset, the commitment of every single individual and a far greater perception of social obligations of our large, international corporations, which also evolved from an erstwhile vision. It also requires just as much a greater willingness of banks and investors to invest, to really move something along.

With the SoftProc project, we are consequently pursuing our vision, that man can only successfully manage the enormous, fast growing demand for software in quantity and complexity, when he is supported by intelligent products. To develop just such products is our aim. Because companies as well as our economy will be forced to realize their IT projects far faster and more agile, in order to find their place at the front in a globally digital world.

Entrepreneurs, CIOs, CTOs, CDOs, IT-Managers, Risk-Managers, Administrators and also Developers are now surely listening attentively. When is the software expected to be available? And how and when can one get in touch with you, in order to learn more or also to test the prototypes?

SoftProc will be in progress over the next two years, a product resulting from this is expected at the end of the project. However, this way there will always be product stages for trials and testing. Interested parties as well as sceptics are today invited to contact us, in order to learn more about the subject or to actively accompany the project.

Further information:

PITSS Corporate Communications

Cathrin Cambensi

ccambensi@pitss.com

Modernization

Why and how to modernize legacy applications efficiently

Read more


Sponsorship project

PITSS is awarded a BMBF funding project for digital software documentation

Read more

Your Contact

Uta Daniels Assistant
of Sales Management

udaniels@pitss.com

+49 711/914-012-12











Continue reading

Forms 14c is out now

Forms 14c is out now

The perfect time to revitalize your Forms Application
Oracle Forms 14.1.2 was released after a long period of time at the end of last year. Compared to the most previous versions in the past for me this release has the most powerful improvements since the architectural change from pure client/server architecture into a Java based application.

The list of new features and improvements is definitely worth considering
https://www.oracle.com/a/otn/docs/oracleforms-1412-newfeatures.pdf

Your Oracle Forms application with the look of 14c

We as PITSS have seen tons of Forms applications in the past. Many of them look as if they were put into a coma 20 years ago and are now on artificial respiration until a final decision will be made.
This is not necessary!
Forms 14 allows you to revitalize your application into a modern and agile application!

Sure, your application was maintained over decades and perhaps you’re afraid of having a not well documented application which does not support consistent inheritance. Don’t be afraid of that! Oracle Forms still provides Java and C-API which allows you to mass analyse and change your application. If you perhaps like the dynamic sort order of a block, which is a pretty good feature for UX enhancements, the API allows you to rollout that into your entire application.

Product based migration from
Oracle Forms to APEX

Taking into account that your application exists for decades, we could assume that also the former architects and developers of the first breath of your application are close to rest or even left the team. Writing this, the manpower of your team may decrease and for the new team members it’s getting harder to get a deep understanding of the application with perhaps outdated documentation.

The time with Forms 14 is perfect to think about refreshing your documentation with a retrograde dynamic approach and to onboard new members for the next decade of further maintenance of your application.

We as PITSS see that with a good base of SQL and PL/SQL know-how developer is fast in reading, understanding and developing Oracle Forms based applications.

All the infrastructure stuff with WLS, FMW Components and perhaps SSO is a one time affair, which could be outsourced very well.

Whenever we are asked to take over maintenance support for an application, we use our own product to draw the overall architecture of the application, to close the gap between the forms modules and the database objects and use the powerful search capabilities to navigate on ease through a totally unknown application. It takes us a twinkle of an eye to answer dependencies between components, which may “exist” in the brain of the designer of the application.

Your compass for optimization and Forms 14c roll-out

But Forms 14 doesn’t open the door only for UI/UX improvements. Especially the new REST-API allows a very good integration into other applications and data sources.

This may bring your business onto the table.

The new possibilities provide you with arguments and tools to discuss with your key users about process improvements and enhancements.

Keeping in mind, once again, that your application is settled for multiple years, it’s not unlikely that the actual version of your application is feature overloaded and no longer streamlined to the actual business processes. Think about considering the various trace capabilities of your infrastructure, to recognize how the application is used. For us, this is a very helpful source to identify the use cases and their strengths and weaknesses.

With the help of PITSS.CON we are able to identify the business processes inside your application only out of the sources of the logfiles and your code. This helps us to design and implement new and changed business requirements very quickly and efficiently.

BMBF funding project

Sure, Oracle Forms is not turned into a native, responsive web application, so it might be that the one or the other enhancement request is not feasible to implement.
Don’t be afraid of this! In combination with Oracle APEX you will have a strong buddy next to Forms 14 which can assist on improvements like e.g. mobile device support, dashboards, excel like grids, etc.

Both of them can share the same data, the same logic and integrate from a user interface perspective.

We as PITSS can support you at any stage of your personal journey. Whether you like to regain control, externalize your support, request selective implementation power, improve the overall user experience of your app – feel free to reach out.

If you have any technical questions, please use calendly to arrange a virtual coffee with me.

Your Contact

Stephan LaRocca

Business Development

slarocca@pitss.com

Continue reading

The new PITSS.CON Release 25.1.1 will be available soon

The new PITSS.CON Release 25.1.1
will be available soon

The perfect navigator for
upgrading and developing on
Oracle Forms Release 14c

Stuttgart / London / Troy 04.03.2025 – We are pleased to announce that the new PITSS.CON release 25.1.1 will be available at the end of April. After the release of the new Oracle Forms 14c last December, we have aligned PITSS.CON to 14c and added more great enhancements. We recommend all Oracle Forms customers to upgrade their Oracle Forms application to Forms 14c soon.

What you can expect in the new PITSS.CON Release 25.1.1:

1. Get the best out of 14c 

  • Upgrade to Forms 14c
  • Benefit from the new features of Forms 14c in all parts of your application
  • Regain control of your application
  • Your Oracle Forms 14c application in coexistence with other technologies

2. APEX inside

  • Load APEX into the PITSS.COn Application Data Cube
  • Benefit from all parsing-, analysis- and search-functions
  • Transparency: Forms, DB and APEX objects in one view

3. Forms2APEX Modeler improvements

  • Form region layout
  • Format-Mask consolidation
  • Friendly URLs
  • Navigate from checkliste to Page-Designer
  • Automate weight calculation
  • Convert Blocks with Post-Query into table based function

Stay tuned for PITSS.CON 25.1.1 – available at the end of April!


POPULAR POSTS


Modernization

Why and how to modernize legacy applications efficiently

Read more


Sponsorship project

PITSS is awarded a BMBF funding project for digital software documentation

Read more

Would you like to find out more about the new PITSS.CON Release 25.1.1?
Or would you like a sneak preview?

Make appointment now

Your Contact

Uta Daniels
Assistant of Sales Management

udaniels@pitss.com

+49 711/914-012-12










Quelle  


Continue reading

The new PITSS.CON release for Oracle Forms 14c

The new PITSS.CON Release
for Oracle Forms 14c

The easy way to upgrade and optimize
Oracle Forms applications

Stuttgart/Troy (MI) 01/21/2025 – Oracle Forms 14c is here. Long awaited, the new Forms Release 14c was published just before Christmas. Oracle Forms 14.1.2 offers numerous new features and is more modern than ever. At PITSS and its PITSS.CON toolset, preparations for Forms 14c are in full swing. The new PITSS.CON release offers numerous new features for Forms 14c. PITSS will give a sneak preview in its webinar on February 19, 2025 with Senior Principal Product Manager Michael Ferrante. 

Forms 14c is here and with it numerous new and improved functionalities in the areas of:

  • Runtimes 
  • Forms Builder
  • Forms Standalone Launcher
  • Administration
  • Installation

At PITSS, enthusiasm for the new Oracle Forms 14c release is high and preparations for the enhancements in the new PITSS.CON release are in full swing. Stephan La Rocca, Head of Product Development at PITSS, recommends that his customers upgrade to 14c as soon as possible in order to benefit from the new Forms features: “PITSS.CON can provide you with perfect support for Oracle Forms 14c. This starts even before the upgrade to 14c. With PITSS.CON, the existing application is first cleaned up and thus freed from legacy issues. After the upgrade to Forms 14c, PITSS.CON can be used to roll out the desired new features across all Forms in the entire application at lightning speed. “Our customers will be particularly impressed by the new UI.”

PITSS invites customers and interested parties to a joint webinar with Oracle Senior Principal Product Manager Michael Ferrante on February 19, 2024. In this webinar, not only exciting new functionalities will be presented, but also how to easily enjoy them with the new PITSS.CON release. Register for the webinar here. 

Options to upgrade to Oracle Forms 14c stress-free and benefit from it

PITSS offers its customers expert advice, individual support or even complete outsourcing for the new Forms release. From analysis of the Forms application, through the upgrade and optimization to 14c, to further modernization projects – the PITSS.CON products support you in all phases of the maintenance project. 

For the perfect start with PITSS.CON and Oracle Forms 14c, PITSS offers various options, depending on the individual customer situation, to familiarize yourself with Oracle Forms 14c or to implement the new features in your own Forms application.

Offer 1: 
Oracle Forms 14 Live Experience Workshop
Experience Forms 14c on your own sources.

Offer 2:
Oracle Forms 14 Installation Service
We install everything, such as WLS, FMW incl. development, to evaluate Forms 14 in your own environment at your convenience. 

Offer 3:
Regain Control Service
Use the new Oracle Forms version to bring applications up to date: Documentation, cleaning up technical debt and being able to use all Forms 14c features across the board.


POPULAR POSTS


Modernization

Why and how to modernize legacy applications efficiently

Read more


Sponsorship project

PITSS is awarded a BMBF funding project for digital software documentation

Read more

Your Contact

Uta Daniels Assistant
of Sales Management

udaniels@pitss.com

+49 711/914-012-12











Continue reading

Oracle expert Günther Stürner in interview with Bernd Frost, Head of Consulting PITSS GmbH

Oracle expert Günther Stürner
in interview with Bernd Frost,
Head of Consulting PITSS GmbH

In the service of successful customers

Bernd Frost is a member of the management team at PITSS GmbH, Stuttgart, and is responsible for the consulting division.

PITSS is one of the leading software houses specializing in the analysis and modernization of Oracle Forms and Oracle Reports systems. PITSS products and services are offered worldwide.


Modernization

Why and how to modernize legacy applications efficiently

Read more


Sponsorship project

PITSS is awarded a BMBF funding project for digital software documentation

Read more

Günther: PITSS was founded in 1999 by Andreas Gaede, the current CEO, among others. May I first ask what the abbreviation PITSS stands for?

Bernd Frost: The abbreviation stands for Professional IT Software and Service. At the very beginning of PITSS, our colleagues used to answer the phone in the pronounced form, until the long name was replaced by the abbreviation “PITSS”. Today, our customers no longer know what the letters stand for. What is much more important, however, is that the idea behind this name has been pursued without interruption and continues to describe what we do and is well expressed in the vision and mission statements: “Software develops Software” and “Simplifying Complexity”.

Just one year after PITSS was founded, the product PITSS.CON was launched on the market. With PITSS.CON it was not only possible to analyze and visualize ORACLE FORMS software but also to optimize it. With each release, additional functions were added, initially functions to automate the ORACLE FORMS upgrade and later the migration to ADF, and relatively early on the migration to ORACLE APEX was supported and parallel solutions for the modernization of ORACLE reports.

Günther: As Head of Consulting, you are responsible for the second ‘S’ of PITSS, Service?

Bernd Frost: Yes, my area is the projects that we carry out for customers. From quotation to acceptance. From small projects to very large projects; from projects around the corner to projects in the USA or anywhere else in the world. We may not be a very large company, but our software products and services are not only in demand locally.

Günther: You worked in the consulting environment at IBM for a long time. What motivated or inspired you to take over the consulting division at PITSS?

Bernd Frost: This is a mixture of my personal history and what PITSS offers as a company.  The founders of PITSS and I developed an ERP system based on the ORACLE database and ORACLE FORMS together in a software company in Stuttgart in the early years of our IT careers and implemented it for customers. Although our professional paths parted, we always stayed in touch and so I knew the high and low lights from the history of PITSS and they made me want to work together again.

In addition to the emotional excitement of being able to go “back to the future”, there were also objective reasons: The performance of a product like PITSS.CON opens up incredible potential, especially when used in projects. In addition, it is much more exciting and satisfying to work on a success story in a small company than in a much larger one.

Günther: What kind of projects do you carry out with your teams?

Bernd Frost: In January 2023, Gartner published the article: “How to Choose the Right Approach for Application Modernization and Cloud Migration” (Note on the source: 23 January 2023- ID G00772600- By Stefan Van Der Zijden, Howard Dodd”)

It mentions: Rehost, Replatform, Rearchitect, Rebuild, Replace.

As PITSS, we not only have the right products and services for each of the alternatives mentioned, we also have and had projects that we execute with our method and with our expert teams. We have also coined an additional term, Regain, to express the fact that we also have the right offer for customers who do not yet want to start with one of the other steps. By this we mean projects that focus on the optimization of Forms applications. Here, existing Forms applications are analyzed with PITSS.CON, weak points and errors are localized and corrected. This also applies to Oracle Reports applications. We proceed in the same way here.

This process can be imagined as a ring process that can be repeated periodically. Ideally, this process is integrated into the development process. Here we are usually involved in the initial projects as a consulting partner and the subsequent optimizations are carried out by the customers themselves. Regain is intended to reference this: The customer regains full control over their application.

The use of our PITSS.CON product suite plays a decisive role in all projects. 

Günther: So the customer has bought your “toolbox” and uses it himself?

Bernd Frost: Yes, this is a typical scenario that many customers use in exactly the same way. The customer buys our product and uses it with their team. In the beginning, many customers want support from PITSS experts or for us to take over certain tasks. Later, expert support is often sufficient.

Günther: You mentioned other cases of use

Bernd Frost: Let’s stay within the scope of the term Regain. This also includes the Forms upgrade. These deployments were the bread and butter business of PITSS years ago and, as mentioned above, one of the first functions of the PITSS.CON product suite. At this point, it is worth explaining a little about how PITSS.CON works.

Only when the customer systems are understood in detail is it possible to display correlations, automatic optimization steps, and a highly automated upgrade. To create this understanding, PITSS.CON reads the source files of the customer application. A parser breaks these down and stores everything in the PITSS.CON DataCube. All PITSS.CON products work based on the data – we like to say “the knowledge” – in the DataCube.

With this knowledge, we can:

  • Perform and visualize source code analysis, as well as dependencies between different application components.
  • Optimize code to increase maintainability and reduce the associated costs, e.g. detect and automatically remove unused code. In applications that have grown over many years, a dead code share of up to 30% is not uncommon. Detect redundancies, display them and simplify their removal, and also automatically move business logic from the FORMS modules to the database.
  • Generating new code is what our code modelers do. The simplest case is the Forms to Forms Modeler, which generates the code in a higher FORMS version. However, we can also generate code fragments in other technologies and thus significantly accelerate migration and modernization projects. Code modelers in other technologies are ORACLE Reports to Jasper Reports and FORMS to APEX.
  • Recognize and visualize business processes in customer applications and thus create the basis for improving the business processes that are mapped in an application.

With these skills, we can significantly improve efficiency in all the above-mentioned types of migration and modernization projects. It’s not just me saying that, you can read about it on our homepage in the References section.

Günther: So by migration and modernization projects you mean a [a2]  technology change from forms or reports to another new technology?

Bernd Frost: Exactly. Many Forms customers are currently considering migrating their Forms applications to Oracle APEX. When it comes to reports, the preference is for JasperReports.

Günther: Such migration projects are not the most straightforward. Why do customers take such a step?

Bernd Frost: Forms applications are widespread in the Oracle environment and it is often the core systems that are implemented in this technology. FORMS is a technology that has been around since the 1990s and, although it has always been developed further, the question now is whether it will continue to be the appropriate technology in the long term.

We know from customers that there was some uncertainty as to whether FORMS 14 would actually come and how long the technology would be in maintenance. ORACLE has now answered this question. Since core systems with many hundreds of FORMS modules of varying size and complexity cannot be converted to a new technology at the snap of a finger, the answer to the question: “Should we use the time that FORMS 14 gives us to switch to a new technology gradually and in a planned manner?” is a clear “yes”. We are only talking about operational reliability for the time being.

In addition, APEX provides functionalities out of the box that are not available in FORMS. The use of application parts on mobile devices is a good example. Features such as artificial intelligence are provided by ORACLE in APEX, no longer in FORMS. The customers who want to use something like this to increase efficiency both in application development and in the business processes supported by the application need to take action. And since APEX follows a similar approach to FORMS, it is only logical that APEX is seen as the new target technology. In addition, the business logic that has already been implemented in the ORACLE database can simply continue to be used. This makes the switch even more attractive.

But it is true that migration projects are demanding and yet they are usually much cheaper and less risky than a completely new development. In addition, the involvement of customer personnel in migration projects can be significantly lower than in new development projects. This not only saves costs, but customers can continue to concentrate on their business and still bring their IT applications up to date. With our approach, our first-class products, and the experience of our teams, we can ensure that we complete the project at the contractually agreed time and that an operational and modern system can be handed over to the customer at that time.

One more thing is important. We do not have to carry out these projects as big-bang projects. Parallel operation of existing Forms and new APEX modules, old and new, is possible. This is also often requested by customers and is recommended by us as a procedure. It works!

Günther: How do you proceed with such projects? If a customer contacts you today and says that they have a Forms environment that is used as a central company application by a large number of users and plans to replace this entire system with APEX. What steps do you take?

Bernd Frost: First, we analyze the application with the help of PITSS.CON. Then we know how complex the application is and what special features are built into it. From this, we can derive the migration effort. We present the result to the customer and recommend how PITSS would carry out the migration if we were commissioned to do so. This is a standardized process that we can carry out within two weeks.

The customer then decides whether to purchase only our product and, if necessary, start-up support or whether to have the migration carried out by PITSS, or a mixed form. If the customer decides to have the migration carried out by PITSS, we clarify the parameters: Big bang or cluster-wise migration, migration or modernization, and duration. With these parameters and the results of the analysis, PITSS submits an offer and the project starts after the contract is signed.

We use our tried and tested method in the project. As befits a proper method, it not only contains a description of what is to be done and in what order but is also backed up with a description of the “how”. This enables us to quickly integrate new team members into the project.

Günther: And how much does it cost? How do you determine the price? With fixed-price projects, you have to be very sure of what you’re doing!

Bernd Frost: The price depends on the factors mentioned above. In the analysis, we determine the complexity of the application in so-called weight points. This is comparable to story points from SCRUM. The main difference is that PITSS calculates the weight with an algorithm that is applied to the detailed data of the application stored in the PITSS Data Cube. In SCRUM, the developers estimate and assign the story points along the Fibonacci sequence. There is no other way to do this for new developments, but it can be done much more precisely when migrating an existing application.

This also enables us to offer fixed-price projects if the other parameters also fit. If the scope is clear and the desired duration is of a magnitude that we can cope with, then we can offer a fixed price with a clear conscience.

Günther: Other companies are also active in this market segment. What is the main difference in the PITSS approach compared to the competition?

Bernd Frost: I would like to start by emphasizing once again that we are talking about the migration or modernization of an existing application. Today, this application is used to map a company’s business processes. The application should also map the business processes after the migration or modernization.

Why am I emphasizing this? There have always been consultants in IT who explain to customers that they are making a big mistake if they do not put all business processes to the test at the same time as the IT measure and ideally change/optimize them. Not a week goes by without LinkedIn showing me articles with this advice. If this is done, work is initially carried out against an unknown scope. The new business processes first have to be developed and coordinated within the company. Then you are in a new development project and no longer in a migration or modernization project.

PITSS calculates the cost of migration based on the existing application using an algorithm that has been continuously improved over the years. We take into account the optimization measures that can be carried out with the help of the PITSS.CON product suite: Removing dead code and redundancies, moving business logic to the database, ignoring FORMS code that is no longer necessary in APEX because APEX has standard features for it. We also include the savings from the generation of code fragments in the target architecture, which is achieved with the PITSS.CON FORMS2APEX Modeler. This results in a complexity figure that you can rely on. Multiplied by a velocity, we calculate the effort required. Depending on whether the customer wants to carry out the migration themselves or we do it, we set a different velocity.

Of course, our experience means that we are faster than a customer team that first has to familiarize itself with the system. Of course, we can also take modernization components into account. If it is already clear before the start of the project that some business processes need to be changed, then we can use PITSS.CON Profind to identify the code of the process to be changed and surgically separate it cleanly from the application and implement it differently in APEX. But then only exactly the necessary parts. This is much more efficient than tearing everything down and redoing it.

Above all, the customer can continue to receive a fixed price for the migration parts. We only offer time and material as a service for what needs to be re-specified together and therefore the implementation scope is not yet clear. Last but not least: With us, the customer has the choice of carrying out the project themselves with PITSS.CON or commissioning us to carry out the project.

Günther: So the PITSS.CON toolset is something like the magic ingredient in such projects?

Bernd Frost: Simply: YES, the reason for the “YES” has, I hope, become clear from all that has been said before. PITSS.CON makes the difference, starting with the accuracy of the project calculation, through the reduction of work and duration of the project and thus directly in the reduction of project costs. In addition, the tools integrated into the Code Modeler help with quality assurance and progress control.

Even if I repeat myself: PITSS.CON is not a tool with which only PITSS is able to accelerate projects. PITSS.CON is a product that enables the customer to carry out the project themselves. Of course, I’m delighted when a customer commissions us for the migration. But I am also pleased when PITSS.CON enables a customer to be successful on their own because this confirms the PITSS strategy mentioned at the beginning. We cannot carry out all upcoming migration projects ourselves. But with PITSS.CON, we can help all upcoming migration projects to succeed.

Günther: That’s a nice way to end! Thank you very much and good luck for the future.

Your Contact

Uta Daniels
Assistant of Sales Management

udaniels@pitss.com

+49 711/914-012-12











Continue reading

Webinar Ready for Oracle Forms 14c

[WEBINAR]
Ready for Oracle Forms 14c? 

What the new version offers and how you benefit from it

February 19, 2025 | 10:00 a.m. (EST)

The new Oracle Forms 14c –
more modern than ever!

Oracle Forms has long been a trusted tool for building mission-critical applications.

Now, with the release of Oracle Forms 14c, organizations can look forward to exciting new capabilities that ensure your development platform remains modern, reliable, and secure.

Join us for an exclusive webinar featuring Michael Ferrante, Senior Principal Product Manager at Oracle, as he unveils the latest features and enhancements in Oracle Forms 14c!

What you get from the webinar:

  • Overview of Oracle Forms 14c
  • Deepening of important new features of Forms 14c
  • Easily integrate the new features of Forms 14c
  • Further insights into Forms 14c
  • Access to Forms 14c
  • Q&A

REGISTER NOW FOR THE WEBINAR RECORDING:

Ready for Oracle Forms 14c?










Quelle  
Lead Source
Lead Status  
   


Your Speakers

Michael Ferrante
Senior Principal Product Manager, Oracle
Oracle Forms expert since ’99. He is responsible for the further development of Oracle Forms and is a regular speaker at big Oracle events all around the world.

 

Stephan La Rocca

Business Development Manager, PITSS

Stephan has been helping companies to bring their Forms applications to the next level and maximize profit for over 20 years. He can be seen presenting innovative solutions for Oracle applications at events such as the DOAG (German Oracle Users Group) Conference.

 

Sacha Sander

Global Sales, PITSS

Sacha Sander has been on board since PITSS was founded. He fills the position of Senior Vice President of Global Sales. His customers appreciate him as a competent source of ideas and reliable partner in choosing the right solutions in software modernization.

Your Contact

Uta Daniels Assistant
of Sales Management

udaniels@pitss.com

+49 711/914-012-12











Continue reading

ORACLE REPORTS TO JASPER – Q&A

ORACLE REPORTS
TO JASPERSOFT – Q&A

Your Questions and Answers
about the Migration from
Oracle Reports to Jaspersoft

In our Oracle Reports to JasperReports projects and webinars, we receive numerous questions about the migration. These are questions about the technologies, the migration process, the methodology, the automation, the resources, the effort, the know-how, the organization, and much more.

We have compiled the most urgent questions and answers for you here. If your question is not included, please write to us. Our experts will be happy to help you!

  • 1. Can we integrate Jaspersoft with Oracle Forms?

    Yes, that’s possible. In general there are three different layers, on which you can communicate to the Jaspersoft Server. The easiest one is to build an URL and call the Report via WEB.SHOW_DOCUMENT from the Forms module. The second approach allows more options for treating the output. You could consume the REST-API (described in our BLOG: Jasper Reports – Javascript & PL/SQL Integration) inside any PL/SQL Package.

    If you need to run the Reports asynchronous in the background, JasperServer provides a CLI, which you could integrate via DBMS_SCHEDULER as a one-time job or on a regular base.

  • 2. How does the cost of Jaspersoft compare to the cost of a Oracle Analytics Publisher license?

    Roughly speaking, for Oracle Forms customers with a valid support contract, Oracle Analytics Publisher (nowadays called Analytics Publisher) is part of the Forms/Reports FMW license.

    If you like to use them outside the Forms ecosystem, you have to purchase a license via BI Suite or as a standalone component. Jaspersoft is basically an open source tool without any license fees. You can purchase a support contract for error handling and maintenance.

    Beside Oracle Analytics Publisher, Jaspersoft provides different editions with diverse functionalities. Out of our experience the Community Edition (open source) of Jaspersoft covers all functionalities you got with Oracle Reports as well. The most complex edition is a full BI Solution comparable to Oracle´s BI Suite.

  • 3. Does Jaspersoft have any limitations that Oracle Analytics Publisher does not have?

    The functionality of the Community Edition covers the possibilities of Oracle Reports, but has less functionalities than the Oracle BI Publisher. Oracle BI Publisher provides features like self-service portals, reusable data models, multiple delivery channels, etc. If you need those functionalities you can consider the commercial version of JasperReports that has more features and is similar to BI Publisher. If you need more information, request our whitepaper “JasperReports vs Oracle BI Publisher” at customerservice@pitss.com

  • 4. What´s the difference between Jaspersoft and Oracle Reports?

    When you run the JasperServer you will see a similar concept. You need a WebServer that can be a lightweight one (TomCat), define some data connections and manage a repository, where you deploy your Reports in. If you like to leave Oracle Forms as well, Jaspersoft provides an alternative infrastructure with the server as a JAR-Library that you could deploy next to your application code.
  • 5. What is the most important thing to validate before the change or migration?

    Three things to keep in mind:

    • Migration is a project and you should treat it seriously. It’s not only a click on a button and runs next to the daily work
    • Take the chance to improve your reporting landscape. Jaspersoft provides concepts of reusability that aren’t available for Oracle Reports. Harmonizing the layout, consolidating queries and functions increases the maintainability afterwards
    • Destress yourself and run a fine grained stage approach. You can migrate and deploy one Report after the other, because the customer cannot figure out if the PDF comes from Jaspersoft or Oracle Reports
  • 6. Is the Reports2Jasper Modeler an automated tool with minimum interaction from a developer?

    Yes, that is our “WHY”, so the reason why we do it.

    Our product addresses the three most important issues during a migration:

    1.) #SimplifyComplexity: Finding patterns in 1000 of Reports, proof assumptions of all code fragments before deciding on a new direction, show and follow global dependencies that aren’t calculatable for a developer

    2.) #LegacyCodeMatters: If you start to develop from scratch, you may miss requirements, fail during implementation of complex queries and functions and face a huge test effort. Taking care of the existing code base as a baseline or springboard, reduces the risk and effort.

    3.) #DontRepeateYourself: However, you develop and will reach a point where you step into repeatable actions. That is a point where our product supports generation capabilities that could be highly customized.

  • 7. How long to convert per Report?

    That depends on the complexity of the existing Report. We saw implementations with dozens of queries, nearly infinite loops of repeating frames and thousands of LOC inside functions.

    In some cases, not only the amount of objects derives the effort of finalizing the Report. The question is if the existing code (and requirements) addresses an existing solution in Jaspersoft or not. As an example – DML inside a format trigger is easy in Oracle Reports, but it’s not a good idea in Jaspersoft.

    Before you even calculate your project, our product can easily calculate the effort and obstacles of the migration, based exactly on your sources. Check it out!

  • 8. Does Jaspersoft use the existing FMW Weblogic infrastructure?

    Theoretically speaking yes – you could also deploy Jasper Server on WLS, but I haven’t seen any customer doing it yet. With a lightweight WebServer, the administration overhead is even smaller than with a WLS instance. Beside starting and stopping the managed server there aren’t any benefits for this infrastructure, isn’t it?

  • 9. What about our Oracle Reports that we are executing in batch files? Do we have the same functionality with Jaspersoft?

    Yes – you could run Jasper also from command line

  • 10. What are the componants required to convert from Oracle Reports to Jaspersoft? (server, license, cost, integration time frame, etc….)?

    The typical starting point is: Tomcat with Jaspersoft Server, Jaspersoft Server in open-source community edition, integrate via WebService. Time Frame depends on the complexity of your reports

  • 11. Could you connect more than one database to one report?

    Yes!

  • 12. How does Jaspersoft handle dashboards?

    From the Jaspersoft Server User Guide: “A Jaspersoft Dashboard displays several reports in a single, integrated view. A dashboard can include other dashboards, input controls for choosing the data displayed in one or more frames, and custom frames that point to URLs for other content. By combining different types of related content, you can create appealing, data-rich dashboards that quickly convey trends.”

  • 13. How long does it take for an Reports developer to become competent with Jaspersoft?

    I take a 5 day training and I’m able to migrate the simple reports. My colleague, which are more familiar, have a very cool learning curve and after 2-3 month they are ready to take the biggest one. It’s importent to train on the job and start with the easy once.

  • 14. How to connect with oracle database before migration?

    Use setup database connections via JDBC inside the IDE. The report reference to the name of the db-connection, which could differ from IDE to test and production environment.

  • 15. Are there any Oracle Reports features that the conversion tool has difficulty converting? Such as conditional formatting, Graphs, etc?

    We don’t cover matrix reports by now (matter of not realy used by the customers so far) and we advise to redo graphics, because they are cool in Jaspersoft and fast to setup.

  • 16. Is it possible to send a Jaspersoft report directly to a specified printer ?

    That is typically a task for a java post processing implementation. There is no out-of-the box solution in the Jaspersoft server, but this could be easily enhanced.

  • 17. We call and use a lot of database functions, can they be called and used in Jaspersoft?

    Yes – in the query and within the scriplets.

  • 18. Does Oracle Apex have a report development tool? Can it create complicated reports like Oracle Reports and Jaspersoft?

    There is no APEX internal reporting tool available. You could use the export functionalities of Interactive Grids. Oracle tend to integrate AOP.

  • 19. Is the development tool for the Pro and Community versions the same? Does it have the same functionality?

    If you cover the functionalities from Oracle Reports the „basics“ in Community and Pro are enough and the same. There are some addons in the Pro, which enhance the functionality (e.g. customizable Dashboards, etc.) but we do not rely on this in the migration. Most of our customer use the community edition.

  • 20. Can Jaspersoft reports be called from Oracle Forms? We need to embed Jaspersoft or whatever reporting tool we use into our application.

    Yes – you could integrate this via WebServices and Web.Show_Document features in Oracle Forms.

  • 21. Does Oracle Analytics Publisher have a true development tool like Jaspersoft and Oracle Reports?

    Oracle Analytics Publisher provides three different ways to create a layout for a designed data model:

    1.) There is a webbased online design tool for simple reports. It’s easy to use but with limited functionalities.

    2.) Microsoft Word. With this you create a RTF Template in the way you create classic form letters in Word.

    3.) Direct writing of XSL without an IDE.
    From the developer point of view, none of them is an IDE like Oracle Reports developer or Eclipse.

  • 22. You said that Jaspersoft is open source but on jaspersoft.com I see only a “Try Jaspersoft Free for 30 Days”. It’s open source or not?

    There are different downloads on the Jasper WebSite. There is a community edition and a pro edition available.

  • 23. Beside Oracle Application server also a Jaspersoft Server is needed?

    You could integrate Jaspersoft as a Java-class in your application or you could use the Jaspersoft server. This is usualy deployed on a lightweight server like TomCat or in Forms environment also on a WLS.

  • 24. How the reports can be integrated into our current Banner CIS system and how we can create a Jaspersoft Dashboard to run the reports?

    Jaspersoft typically provide two different ways of integration. On one hand you can use the Jaspersoft Javaclasses and embedding them into a Javabased application. With the API you could run the reports. On the other hand you could use the Jaspersoft Server and communicate with them via webservices.

    Jaspersoft Dashboards are a functionality of the Server and you could configer them directly in the WebUI of the server.

    JasperReports Dashboards are a functionality of the Server and you could configer them directly in the WebUI of the server.

  • 25. Is character based printing (invoices, pay checks) possible?

    Yes, you could also create reports like invoices, pay checks, etc. with Jaspersoft.

  • 26. Is there a way of automatic conversion?

    Yes, try our Reports2Jasper Modeler!

  • 27. What about licensing to Jaspersoft? What about Oracle Analytics Publisher/OAC and another open source reports options?

    Jaspersoft provides different versions (community, professional, etc.) which have different licence costs. The community edition is the only free version of those you mentioned. Oracle Analytics Publisher and OAC are not free and need a licence of the server or the cloud offerings. If you like to discuss other reports solution (BIRT, AOP, PLPDF, etc.) or if you are interested in any kind of licence, please get in contact with sales@pitss.com

  • 28. Is there any solution in APEX that will replace printing with Reports in Forms?

    The answer could be given in two levels of complexity. If reporting is very easy, like a tab report of a query, you could use export functionality of an APEX grid. This allows you to create HTML, Excel or PDF Formats which could slightly be customized.

    If reporting is getting more complex and see a lot of implementation in Oracle Reports, you should consider a separate solution. Preferred frameworks are Jaspersoft, Oracle Analytics Publisher or AOP.

  • 29. We use hyperlinks to drill down between the reports. Is that possible in JasperSoft Reports?

    Yes, Jaspersoft will also support hyperlinks to drill.

Your answer was not included?
Then please feel free to ask us your question:

Your Contact

Uta Daniels Assistant
of Sales Management

udaniels@pitss.com

+49 711/914-012-12











Continue reading