otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch


 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire

Go Back   Oracle OTM / G-Log GC3 Community Support > OTM / G-Log - Functional Topics > Workflow
Reload this Page

[SOLVED] datachecks before saving business object


Workflow Configuring Workflow components - including Agents, Milestones, Notifications Auto Data Assignment and Events.

Tags: ,

Closed Thread
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old April 19th, 2007, 14:54
Member and Blogger
 
Join Date: Jan 2007
Location: Haalderen, Netherlands
Posts: 117
Blog Entries: 1
Thanks: 7
Thanked 33 Times in 31 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 2
bob_romijn is on a distinguished road
Send a message via Skype™ to bob_romijn
[SOLVED] datachecks before saving business object

Scenario:

A user is only allowed to enter an order release when the early delivery date is not within 2 (configurable) working days.

I have tried a few things with Action Checks, but that doesn't seem to work.

Has somebody have experience on this?

Best regards,

Bob Romijn
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #2 (permalink)  
Old April 26th, 2007, 14:18
Junior Member
 
Join Date: Aug 2006
Posts: 18
Thanks: 0
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 0
samuellevin_mavenwire is on a distinguished road
Wink Re: datachecks before saving business object

The challenge here is with the working days. Its hard through a query to handle calendar days against a system date. I have done action checks around dates like the following
TRUNC (o.early_pickup_date) - TRUNC (SYSDATE) <=2

Hope this helps!
Sam
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Throwing OutOfMemory: allocLargeArray - Object size: 5766688, Num elements: 2883334 Kristof Stevens Hardware and Platforms 9 August 14th, 2008 09:50
Business Monitor cool_brat Execution 3 March 7th, 2008 04:29
Attaching Document to an OTM Object sheriff Workflow 1 October 23rd, 2007 11:05
[SOLVED] Business process in using OTM kaki Training, Certification and Documentation 5 July 13th, 2007 11:29
[SOLVED] Business Monitor Alert Anitha J Workflow 2 June 13th, 2007 17:15



All times are GMT. The time now is 22:57.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37