OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Form Personalization

Home » Applications » Oracle Fusion Apps & E-Business Suite » Form Personalization - problem in applying date condition (APPS R12 - MFG module)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Form Personalization - problem in applying date condition [message #511169]

Thu, 09 June 2011 23:49

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

Report message to a moderator

Re: Form Personalization - problem in applying date condition [message #511174 is a reply to message #511169]

Fri, 10 June 2011 00:07

Littlefoot
Messages: 21823
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;

Report message to a moderator

Re: Form Personalization - problem in applying date condition [message #511181 is a reply to message #511174]

Fri, 10 June 2011 00:23

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

Report message to a moderator

Re: Form Personalization - problem in applying date condition [message #511182 is a reply to message #511181]

Fri, 10 June 2011 00:50

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Form Personalization - problem in applying date condition [message #511184 is a reply to message #511182]

Fri, 10 June 2011 00:55

chenny
Messages: 10
Registered: May 2010
Location: India

Junior Member

Sure, please feel free to do so. Thanks a lot.

Report message to a moderator

Re: Form Personalization - problem in applying date condition [message #511527 is a reply to message #511169]

Mon, 13 June 2011 13:50

Alien
Messages: 292
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

Report message to a moderator

Re: Form Personalization - problem in applying date condition [message #511830 is a reply to message #511527]

Wed, 15 June 2011 05:11

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..