| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: MUST read Oracle Architecture - Abrief Intro
John Weatherman[SMTP:john.weatherman_at_replacements.com] wrote:
> >In general, I agree with the majority opinion that seems to be saying
> that
> >Oracle chugs along
> >perfectly happy when the date changes. Time based recovery might have
> some
> >issues, so I'd
> >run a hot after the change so I could use it as my basis in a restore.
> >
> >The real question in my mind is ... What does the APP do with the dates.
> If
> >you've got a time finder
> >type app, you may need some data cleanup scripts to make sure
> calculations
> >done on the stored
> >data come out right....person clocks in at 7:00 and out at 5:00, that 7
> may
> >need to be brought forward
> >to get the overtime off the clock, for instance. Someone else mentioned
> an
> >accounting issue if
> >invoice 2 goes out before invoice 1. These sorts of issues need to be
> >discussed with "power users".
>
This one in particular is fun to argue with accounts/purchasing people.
Even when they have valid date and time data, they start getting really
antsy (sp?) when you say "the invoice number is just a unique identifier, it
has no inherent meaning". I should take the digital camera with me next
time so I can take a snap of the cherry-red colour their face goes :-)
(Of course, this assumes that the accounting system handles the very date/time problem you're trying to tackle :-) ).
Ciao
Fuzzy
:-)
If swallowed seek medical advice
(Apologies for the excess signature)
This email message (and attachments) may contain information confidential to
TOWER Software. If you are not the intended recipient you cannot use,
distribute or copy the message or message attachments. If you are not the
intended recipient, please notify the sender by return email immediately and
delete all copies of the message and attachments. Opinions, conclusions and
other information in this message and attachments that do not relate to the
official business of TOWER Software, are not given or endorsed by it.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: Grant_at_towersoft.com.au Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Jul 24 2002 - 20:13:24 CDT
 |
 |