Home » Applications » Oracle Fusion Apps & E-Business Suite » CALENDAR
CALENDAR [message #379064] Sun, 04 January 2009 05:55 Go to next message
hany_marawan
Messages: 198
Registered: April 2005
Location: Cairo - Egypt
Senior Member
Hello
I read in pdf that I can appear CALENDAR by command "CALENDAR.SHOW".
I did this command in KEY-LISTVAL trigger but it's not working.
How can this working
Thanks
Re: CALENDAR [message #382174 is a reply to message #379064] Wed, 21 January 2009 04:18 Go to previous messageGo to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
While creating calendar on any date field, use following:

Steps:
a) Use Property Class TEXT_ITEM_DATE
b) To show calendar also set following:
List of Values to ENABLE_LIST_LAMP and Validate from List to 'No'
c) Add a KEY-LISTVAL trigger (calendar.show) that shows the Calendar with execution Hierarchy set to Override and
should not fire in query mode
d) Write this code in Key-Listval trigger calendar.show
e) To default to the current date as $$DBDATE$$
Re: CALENDAR [message #382418 is a reply to message #379064] Thu, 22 January 2009 04:00 Go to previous messageGo to next message
hany_marawan
Messages: 198
Registered: April 2005
Location: Cairo - Egypt
Senior Member
Hello,
First, thanks for attention
Second, I did all these steps but I found that this item disappeared from the form run?
can you conclude why this happened.

Thanks
Re: CALENDAR [message #382419 is a reply to message #379064] Thu, 22 January 2009 04:08 Go to previous messageGo to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
I hope you are working on Oracle Apps.
The reason for the item not getting appeared on the form at runtime, is because you might not have given TEXT_ITEM_DATE property class to that item.

I guess you have put the form in AU_TOP and compiling there and then moving .fmx to custom_top.
Re: CALENDAR [message #382452 is a reply to message #379064] Thu, 22 January 2009 06:36 Go to previous messageGo to next message
hany_marawan
Messages: 198
Registered: April 2005
Location: Cairo - Egypt
Senior Member
Hello,
Thanks again for attention.
I'm very happy for your comments,
but I want to tell you that I build complete and integraed modules like payroll and time and labor for my company, so I know how to build,compile and run the forms not one form.
So if you built the calenadr before, please send me your form with only this item not more - If you realy built this form not just give your recommendations -.

Thanks

Re: CALENDAR [message #382626 is a reply to message #379064] Fri, 23 January 2009 04:40 Go to previous messageGo to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
In the attached form, in EGA_REQ_HEADER block i have used "need by date" field.

Re: CALENDAR [message #384121 is a reply to message #379064] Mon, 02 February 2009 03:47 Go to previous messageGo to next message
alaa_fouad2004
Messages: 64
Registered: January 2009
Member
i dowanload the form and i updated my form like your form but it is still not working please advise me if you have more information
Re: CALENDAR [message #384131 is a reply to message #379064] Mon, 02 February 2009 04:41 Go to previous messageGo to next message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
I assume following things: Please tell me if any of following is not happening with you:

1. You are working on Oracle apps?
2. while opening the form in form builder you haven't got any error?
3. or if you are developing form , you have started development from TEMPLATE.fmb from au_top.
4. if possible attach a scree shot of your form where that date field is not appearing.

My guess is there is something wrong in my understanding.
Re: CALENDAR [message #384546 is a reply to message #379064] Wed, 04 February 2009 04:39 Go to previous messageGo to next message
alaa_fouad2004
Messages: 64
Registered: January 2009
Member
I created this form and the item dates not appeared on the run except it's prompt only
Re: CALENDAR [message #384602 is a reply to message #379064] Wed, 04 February 2009 07:07 Go to previous message
parag_narkhede
Messages: 110
Registered: January 2008
Location: Pune
Senior Member
OK. I think during compilation, it is not getting some libraries.
I know you have worked on forms before as well, But still Answer following questions..

are you putting the fmb in AU_TOP and the compile it?

1. You are working on Oracle apps?
2. while opening the form in form builder you haven't got any error?
3. or if you are developing form , you have started development from TEMPLATE.fmb from au_top.
4. if possible attach a scree shot of your form where that date field is not appearing.
Previous Topic: Concurrent program writing in excel file automatically removing leading zeros
Next Topic: Sales Order Localization Import
Goto Forum:
  


Current Time: Sun May 26 08:40:17 CDT 2024