Home » Applications » Oracle Fusion Apps & E-Business Suite » Form Personalization - problem in applying date condition (APPS R12 - MFG module)
Form Personalization - problem in applying date condition [message #511169] Thu, 09 June 2011 23:49 Go to next message
chenny
Messages: 10
Registered: May 2010
Location: India
Junior Member
Hi!!

I've to incorporate a rule while 'releasing' (from WIP status) and 'closing' a batch that the actual completion date will be in the same month as that of actual start date, i.e. if actual start date is '14-APR-2011' then actual completion date has to be within '30-APR-2011'. I've been trying this with Form Personalization wher i'm writing :

:CNTRL_EVENT.ACTUAL_COMPLETION_DATE between :CNTRL_EVENT.ACTUAL_DATE and last_day(:CNTRL_EVENT.ACTUAL_DATE)

in condition where CNTRL_EVENt is the trigger and trigger event being WHEN-VALIDATE_RECORD

but the condition evaluates to false.

Can anyone please help in resolving.

Regards,
AD
Re: Form Personalization - problem in applying date condition [message #511174 is a reply to message #511169] Fri, 10 June 2011 00:07 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This looks like an Oracle Apps. (which I don't use) question, so - my suggestion might be plain wrong. However: did you try WHEN-VALIDATE-ITEM trigger on CNTRL_EVENT.ACTUAL_COMPLETION_DATE item:
if :cntrl_event.actual_completion_date not between :cntrl_event.actual_date and
                                                   last_day(:cntrl_event.actual_date)
then
   message('Your error message here');
   raise form_application_error;
end if;
Re: Form Personalization - problem in applying date condition [message #511181 is a reply to message #511174] Fri, 10 June 2011 00:23 Go to previous messageGo to next message
chenny
Messages: 10
Registered: May 2010
Location: India
Junior Member
Well, being a seeded form, preference would be to do it through personlization. Here, the code u had stated is throwing away relational operotor error. Sad
Re: Form Personalization - problem in applying date condition [message #511182 is a reply to message #511181] Fri, 10 June 2011 00:50 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That's what I was afraid of. As I said, I don't know Oracle Apps. Sorry. I could, though, move your question to that (Apps.) forum, if you wish.
Re: Form Personalization - problem in applying date condition [message #511184 is a reply to message #511182] Fri, 10 June 2011 00:55 Go to previous messageGo to next message
chenny
Messages: 10
Registered: May 2010
Location: India
Junior Member
Sure, please feel free to do so. Thanks a lot.

Re: Form Personalization - problem in applying date condition [message #511527 is a reply to message #511169] Mon, 13 June 2011 13:50 Go to previous messageGo to next message
Alien
Messages: 289
Registered: June 1999
Senior Member
Hi,

so what should happen when the actual_completion_date is in another month? Should it be automagically be updated to the last day of the starting month? Or should it show a pop-up message that the date is incorrect?

Regards,

Arian
Re: Form Personalization - problem in applying date condition [message #511830 is a reply to message #511527] Wed, 15 June 2011 05:11 Go to previous messageGo to next message
chenny
Messages: 10
Registered: May 2010
Location: India
Junior Member
Hi Arian,

Well, the former, i.e. it should prompt the user to enter date between the start & end of the same month, this would go with a message.

I'm enclosing the screenshots and the personlaization code I had tried. The fist pic is when I choose to 'Complete' the batch from it's 'WIP' status. It gives the 2nd pic where the user have to enter the completion date and here I want to make the check work. 3rd pic is the snippet of code I tried , but it's working out being 'FALSE'.

Hope this would help you all to understand where I'm stuck with.

Regards..
  • Attachment: pic1.JPG
    (Size: 55.93KB, Downloaded 866 times)

[Updated on: Wed, 15 June 2011 05:15]

Report message to a moderator

Re: Form Personalization - problem in applying date condition [message #511832 is a reply to message #511830] Wed, 15 June 2011 05:17 Go to previous messageGo to next message
chenny
Messages: 10
Registered: May 2010
Location: India
Junior Member
pic 2
  • Attachment: pic2.JPG
    (Size: 50.41KB, Downloaded 870 times)
Re: Form Personalization - problem in applying date condition [message #511833 is a reply to message #511832] Wed, 15 June 2011 05:17 Go to previous message
chenny
Messages: 10
Registered: May 2010
Location: India
Junior Member
pic 3
  • Attachment: pic3.JPG
    (Size: 50.37KB, Downloaded 889 times)
Previous Topic: RW 50015
Next Topic: Error encountered when save SIT (Special Information Type) data
Goto Forum:
  


Current Time: Thu Mar 28 12:12:29 CDT 2024