Reports Builder stopped working in Oracle Apps Upgrade

0
55
views

Working on Oracle Apps upgrade (11i–> R12)  project and retrofitting Oracle Reports from 6i to 10G and facing Reports Builder stopped working. Windows is checking for a solution to the problem…issue. Check solution.

You,

  1. Open report builder 10g
  2. Connect to database
  3. Open a custom report
  4. Report builder goes in not responding stage and after sometime crashes.

Oracle reports builder stopped working


What went wrong? You repeat above steps, still same, report builder is crashing.

Why So? What is the issue? How to resolve it?

There could be many reasons but most probably it happens due to dependency issue. When you open report builder, it checks dependent objects in the database, if those exist or not. If it does not find it, Oracle Reports builder crashes.

Follow below steps to resolve Oracle Reports Builder Crashing issue.

Method 1: Use original report builder version

Open report builder in 6i and connect to 11i database. Identify all custom objects which report is using from your database and also the pll file. Create those object in R12. Now you can open report builder 1og and connect to r12 and open report.

What if you do not have old report builder version? There is workaround,

Method 2: Use Notepad++ to identify object

Oracle RDF is a binary file. The code is not in readable format, but it does show package, table name in a readable format.

Open rdf in NOTEPADD+ and identify all the custom object which report is using and follow steps mentioned in method 1 to resolve the issue.

I hope above method will help you to solve reports builder stopped working issue or report builder crash issue.

LEAVE A REPLY

Please enter your comment!
Please enter your name here