Invalid Objects
Date: 21 Jun 99 06:30:06 EDT
From: Dinesh Chandra dchandra@usa.net
Subject: Invalid Objects
Hi All,
What could be the reasons for Objects, like Package Body, Views, becoming
invalid in Oracle Applications?
Cheers
Dinesh Chandra
Date: Mon, 21 Jun 1999 16:24:26 +0530
From: Gopalakrishnan K gopalak@wiproge.med.ge.com
Subject: RE: Invalid Objects
The invalid objects are caused in Oracle Applications
due to the structuralchange in base objects.
For eg the view becomes invalid if the structure of the
base table is changed.
To avoid this oyu have to recompile the objects
whenever you apply a new patch.
The best practice is to run ADADMIN once in a month
Regards !
Gopalakrishnan K
Database Administrator
GE Medical Systems Limited.
Pune 411014, INDIA
Date: Mon, 21 Jun 1999 21:22:42 +0000
From: fushan@gamma.aei.ca
Subject: Re: Invalid Objects
I can be many many reason.
1, the specification does not matched with package body,
2, the object refered by the package are gone or invalid.
in order to get more information. you can do that :
1, try to compile the package or views
2, if there is an error or warning. do the follow :
select text from all_errors where name 'package name or
view name ' It will tell you more information about what causes the
object invalid.
Template.fmb
From: Kelvin Stapleton [SMTP:KStaplet@corp2.pagemart.com]
Sent: Thursday, July 01, 1999 7:59 AM
Subject: Template.fmb
I am looking for a copy of template.fmb for oracle applications release
10.7 to use with forms45 to be able to do some custom development. I have
looked on our install Cd and can only find the fmx.
Date: Thu, 1 Jul 1999 09:32:42 -0700
From: "Borra, Sravanthi" SBorra@dreamworks.com
Subject: RE: Template.fmb
Hi
Loop under $AU_TOP/forms/US
Let me know if u cant find it.
Sravanthi
Date: Thu, 1 Jul 1999 13:18:13 -0400
From: "Govathoti, George, CFCTR" ggovath0458@att.com
Subject: RE: Template.fmb
Kevin,
Install the APPS CD DEVELPER version, not just the runtime, The runtime kit
installs fmx's and the Developer kit install the FMB's.
It is in the FND75\forms\US directory
Thanks,
Best Regards,
George Govathoti
AT&T SOTP AP Development
Show Calendar as LOV
Date: Thu, 17 Jun 1999 06:50:24 -0700 (PDT)
From: Ananth Kumar da_kumar@yahoo.com
Subject: Developer 2000 - Forms 4.5 (Urgent)
Hi All,
I have a requirement to show Calender on a
'date field ' when the user presses the 'F9' (List
Val) key, when the form is in 'Enter Query Mode'. Is
there any way to get this functionality??
PS: The Calender is in a different Block.
TIA
Ananth
Date: Thu, 17 Jun 1999 10:26:25 -0400
From: "Govathoti, George, CFCTR" ggovath0458@att.com
Subject: RE: Developer 2000 - Forms 4.5 (Urgent)
Hi Ananth,
Do this:
Set the LOV on this field to ENABLE_LIST_LAMP
Next create a KEY_LISTVAL trigger on this field and make the following call
in the trigger: Make the trigger's execution style to 'Override' and make
NOT to fire on the enter-query mode, by choosing these in the property sheet
for the trigger.
calendar.show ;
This should take care of your problem.
Thanks,
Best regards,
George Govathoti
Date: Thu, 17 Jun 1999 07:58:05 -0700 (PDT)
From: Ananth Kumar da_kumar@yahoo.com
Subject: RE: Developer 2000 - Forms 4.5 (Urgent)
Hi George,
Thanks for the reply,
I need to show the Calender in Enter-Query mode.
I am able to show the Calender when the user is
entering a New Record.
I am facing problem to show the Calender in the Enter
Query Mode as I cannot use 'go_block' procedure in
this mode.
Do you have any clue on this?
TIA
Ananth
Date: Thu, 17 Jun 1999 18:32:52 +0200
From: "Blaise Rempteaux" brempteaux@auchan.com
Subject: RE: Developer 2000 - Forms 4.5 (Urgent)
Maybe, there is a solution to your problem but, it is not easy.
I never implemented this customisation.
In Enter Query Mode, you can't use 'go_block' procedure.
When you are in enter query mode and when the user hit F9, you will have to
go in normal mode,
showing the calendar and when the user quit the calendar, turn the screen in
enter query mode.
This is the pseudo code of the trigger KEY_LISTVAL
If :system.mode = 'NORMAL' then
calendar.show;
else
--
-- You memorise the values
--
val1 := :block.item1;
val2 := :block.item2;
...
exit_form;
--
-- You are now in normal mode
--
Set_Form_Property(:system.cursor_form,VALIDATION_UNIT,FORM_SCOPE);
Go_Item('block.my_item_date');
:block.item1 := val1;
:block.item2 := val2;
...
calendar.show;
the_value_choosen := :block.my_item_date;
clear_record;
Set_Form_Property(:system.cursor_form,VALIDATION_UNIT,ITEM_SCOPE);
enter_query;
--
-- You are now in enter query mode
-- You can copy the values you keep before
--
:block.item1 := val1;
:block.item2 := val2;
...
:block.my_item_date := the_value_choosen;
end if;
Good Luck.
Blaise Rempteaux
Date: Fri, 18 Jun 1999 02:59:27 -0700 (PDT)
From: Ananth Kumar da_kumar@yahoo.com
Subject: RE: Developer 2000 - Forms 4.5 (Urgent)
Hi,
I have done all that was mentioned below, but the code
below the call to 'enter_query' procedure is not
getting executed at all, the cursor is waiting at the
'item1' in my block as it used to do previously. The
date field is empty once again...
Is this impossible to achieve in Forms45???
TIA
Ananth
Date: Fri, 18 Jun 1999 15:57:33 +0530
From: manoj_bhatnagar/Polaris@polaris.co.in
Subject: RE: Developer 2000 - Forms 4.5 (Urgent)
Hi Ananth
I assume that you are working in Oracle Appliations because the solution
which I am going to tell you is applicable only in Oracle Applications 10.7
and above.
1. Attach the library APPDAYPK in your form.
2. Open the property sheet of trigger KEY-LISTVAL and set the property
FIRE IN ENTER QUERY MODE as TRUE.
3. Write the trigger text as
CALENDAR_SHOW(SYSDATE);
Hope this will solve your problem.
Manoj Bhatnagar
Associate Consultant - Oracle Applications.