Solved

oracle Forms from 6i to 10g -only blank screen is displaying after deployment

Posted on 2008-10-08
9
1,728 Views
Last Modified: 2013-12-18
I have converted oracle Forms from 6i to 10g (almost 10 forms). In the development environment all 10 forms are working fine without any problems. I have deployed the forms in the server. Now all the forms are working fine except one form. Only blank screen is displaying in this case. What could be the reason? How to resolve this issue? This form is also working fine in the development environment.
Thanks for all your suggestions.
0
Comment
Question by:jyothsna1803
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
9 Comments
 
LVL 12

Accepted Solution

by:
jwahl earned 500 total points
ID: 22676059
hard to say what's the reason ... try to put some message codes to have control over the form.
start with the PRE-FORM trigger:

BEGIN
    MESSAGE(1);PAUSE;
    ...
    ... [your code]
    ...
    MESSAGE(2);PAUSE;
END;

then WHEN-NEW-FORM-INSTANCE, then on block level PRE-BLOCK, WHEN-NEW-BLOCK-INSTANCE and so on.

so maybe you are able to locate where the form stops ....
0
 

Author Comment

by:jyothsna1803
ID: 22679886
WHEN-NEW-FORM-INSTANCE is not firing and PRE-FORM trigger is firing. What could be the reson, how to tesrt/resolve this issue,
Thanks!
0
 
LVL 12

Expert Comment

by:jwahl
ID: 22680218
PRE-FORM fires before WHEN-NEW-FORM-INSTANCE ... does PRE-FORM finish completly?
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Author Comment

by:jyothsna1803
ID: 22680283
Just one small alert i have used in PRE-FORM Trigger. i am using the below line and it is displaying the message.
message( 'pre form Trigger');
Even i have written the same alery in the WHEN-NEW-FORM-INSTANCE trigger. but i am not seeing this messge. I thought after firing PRE-FORM trigger the process is stopped, but in the development it is working fine and i am seeing messages successfully.
0
 

Author Comment

by:jyothsna1803
ID: 22681725
I have written alert messages in the following triggers to verify above problem
pre form
pre block
pre record
pre text item
when new form instance

I got alert messages for pre form,pre block and pre record triggers. But not to pre text item. So is it the real issue with pre text item, anyway i am not getting any kind response to when new form instance trigger. Any suggestions please
0
 
LVL 12

Expert Comment

by:jwahl
ID: 22684792
i'm not sure if Forms 10g supports this, in 6i you can debug the form by turning on Debug Mode: Tools --> Preferences --> Runtime --> Debug Messages
at runtime you will get a message for every trigger that is fired.
maybe this will help you to locate the problem ...?
0
 

Author Comment

by:jyothsna1803
ID: 22687580
Still no luck Jwahl. Thanks for all your help. I am developing a new form.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question