[prev in list] [next in list] [prev in thread] [next in thread]
List: oaug
Subject: OAUGNet Digest #224
From: "OAUGNet ListServ" <OAUGNet () oaug ! com>
Date: 2003-08-21 9:02:55
[Download RAW message or body]
OAUGNet ListServ Digest #224
1) Re: reconciling cheques by Alice Cura <acura@brooktrout.com>
2) AR: Customer Contact Roles through Interface by Jaisimha Rangan \
<Jaisimha.Rangan@reuters.com> 3) Upgrade with accounting periods open by "Kane, \
Chuck" <chuckk@artesyncp.com> 4) Rename segmen3t in GL_CODE_COMBINATIONS table - is \
it possible ?? by "Costello.Chris" <chris.costello@barcrestgroup.com> 5) excluding \
retired assets by "Michael L. Jewell" <mlj3u@virginia.edu> 6) adding crm installed \
base attributes to item by Martin Burger <m.burger@dp.nl> 7) update Inventory \
balances(supply+onhand qty) in oracle from Other Crib Master sy by irfan dogan \
<irfan1523@yahoo.com> 8) Re: excluding retired assets by "Maness, John" \
<John.Maness@Williams.com> 9) Re: update Inventory balances(supply+onhand qty) in \
ora cle from Other Crib Mast by "Leclerc, Marcel A., Jr (Marc)" \
<MARC.LECLERC@timken.com> 10) please stop emails to my id which are not relevant to \
me by Dominic <dd19714@yahoo.com> 11) How to handle Notes Receivable with Factoring \
by "Suggula, Mohana" <Mohana.Suggula@coherentinc.com> 12) Re: update Inventory \
balances(supply+onhand qty) in ora cle from Other Crib Mast by irfan dogan \
<irfan1523@yahoo.com> 13) Re: please stop emails to my id which are not relevantto me \
by Mark Britton <mbritton@colostate.edu> 14) Re: Rename segmen3t in \
GL_CODE_COMBINATIONS table - is it possible ?? by "Solomon, Steven" \
<Steven.Solomon@alcoa.com.au> 15) Advanced Query feature in forms, does it still work \
for r11i? by Gregg Harvey <gregglharvey@yahoo.com> 16) include digital signature in \
AP check - Please Help by L Leung <glorywa@yahoo.com> 17) Re: reconciling cheques by \
Grant_Turner@bankwest.com.au 18) Re: Advanced Query feature in forms, does it still \
work for r11i? by "Costello.Chris" <chris.costello@barcrestgroup.com>
This digest is sent to you because you are subscribed to
the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, E-mail to <OAUGNet-feed@oaug.com>
Send administrative queries to <OAUGNet-request@oaug.com>
----------------------------------------------------------------------
Message-ID: <65787A360C59D4119316009027E779FBE7CA18@geryon.corporate.brooktrout.com>
From: Alice Cura <acura@brooktrout.com>
Subject: [OAUGNet]-Re: reconciling cheques
Date: Wed, 20 Aug 2003 09:01:53 -0400
We use excel.
We run an oracle check register and bring it into excel for each account and
add it to the prior month list of outstanding checks.
We then mark the cleared checks. then sum the cleared checks to make sure
the dollar figure ties to the bank statement amount for cleared checks.
then we delete the purged checks from the worksheet. We have a separate
excel spreadsheet that has all of our bank accounts on it that we do the
actual book to bank reconciliation on and the new outstanding check number
is used here for the reconciliation. Been doing this with Oracle for 6
years and up to 20 different bank accounts.
Hope this helps.
Alice Cura
Brooktrout, Inc.
-----Original Message-----
From: Grant_Turner@bankwest.com.au [mailto:Grant_Turner@bankwest.com.au]
Sent: Wednesday, August 20, 2003 4:59 AM
To: OAUGNet ListServ
Subject: [OAUGNet]-reconciling cheques
Hi, does anybody reconcile their accounts payable cheques not using the
oracle cash management module. If so what alternate software do you use?
Thanks
Grant Turner
Finance Systems Administrator - General Ledger
BankWest Finance Department
Phone:08 94497598
Fax:08 94496266
E-mail:grant.turner@bankwest.com.au
____________________________________________________________________________
___
Unencrypted electronic mail is not secure and may not be authentic.
If you have any doubts as to the contents please telephone to confirm.
This electronic transmission is intended only for those to whom it is
addressed. It may contain information that is confidential, privileged
or exempt from disclosure by law. Any claim to privilege is not waived
or lost by reason of mistaken transmission of this information.
If you are not the intended recipient you must not distribute or copy this
transmission and should please notify the sender. Your costs for doing
this will be reimbursed by the sender.
____________________________________________________________________________
___
#############################################################
This message is sent to you because you are subscribed to the mailing list
<OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to <OAUGNet-request@oaug.com>
------------------------------
Message-ID: <T642c3a87d8c407b71188c@dtcseuvig5.dtc.lon.ime.reuters.com>
Date: Wed, 20 Aug 2003 14:45:05 +0100
From: Jaisimha Rangan <Jaisimha.Rangan@reuters.com>
Subject: [OAUGNet]-AR: Customer Contact Roles through Interface
Hi,
Can the assigning of 'Roles' (such as Bill To' role), to Customer
Contacts, also be done through the Interface. I believe, the standard
interface does not allow this. If it doesn't, is there any other
(supported?) way of doing it?
Thanks,
Jai
-----Original Message-----
From: Alice Cura [mailto:acura@brooktrout.com]
Sent: 20 August 2003 14:02
To: OAUGNet ListServ
Subject: [spam] [OAUGNet]-Re: reconciling cheques
We use excel.
We run an oracle check register and bring it into excel for each account
and add it to the prior month list of outstanding checks. We then mark
the cleared checks. then sum the cleared checks to make sure the dollar
figure ties to the bank statement amount for cleared checks. then we
delete the purged checks from the worksheet. We have a separate excel
spreadsheet that has all of our bank accounts on it that we do the
actual book to bank reconciliation on and the new outstanding check
number is used here for the reconciliation. Been doing this with Oracle
for 6 years and up to 20 different bank accounts. Hope this helps. Alice
Cura
Brooktrout, Inc.
-----Original Message-----
From: Grant_Turner@bankwest.com.au [mailto:Grant_Turner@bankwest.com.au]
Sent: Wednesday, August 20, 2003 4:59 AM
To: OAUGNet ListServ
Subject: [OAUGNet]-reconciling cheques
Hi, does anybody reconcile their accounts payable cheques not using the
oracle cash management module. If so what alternate software do you use?
Thanks
Grant Turner
Finance Systems Administrator - General Ledger
BankWest Finance Department
Phone:08 94497598
Fax:08 94496266
E-mail:grant.turner@bankwest.com.au
________________________________________________________________________
____
___
Unencrypted electronic mail is not secure and may not be authentic. If
you have any doubts as to the contents please telephone to confirm.
This electronic transmission is intended only for those to whom it is
addressed. It may contain information that is confidential, privileged
or exempt from disclosure by law. Any claim to privilege is not waived
or lost by reason of mistaken transmission of this information. If you
are not the intended recipient you must not distribute or copy this
transmission and should please notify the sender. Your costs for doing
this will be reimbursed by the sender.
________________________________________________________________________
____
___
#############################################################
This message is sent to you because you are subscribed to the mailing
list <OAUGNet@oaug.com>. To unsubscribe, E-mail to:
<OAUGNet-off@oaug.com> To switch to the FEED mode, send any message to
<OAUGNet-feed@oaug.com> To switch to the DIGEST mode, E-mail to
<OAUGNet-digest@oaug.com> To switch to the INDEX mode, E-mail to
<OAUGNet-index@oaug.com> Send administrative queries to
<OAUGNet-request@oaug.com>
#############################################################
This message is sent to you because you are subscribed to the mailing
list <OAUGNet@oaug.com>. To unsubscribe, E-mail to:
<OAUGNet-off@oaug.com> To switch to the FEED mode, send any message to
<OAUGNet-feed@oaug.com> To switch to the DIGEST mode, E-mail to
<OAUGNet-digest@oaug.com> To switch to the INDEX mode, E-mail to
<OAUGNet-index@oaug.com> Send administrative queries to
<OAUGNet-request@oaug.com>
--------------------------------------------------------------- -
Visit our Internet site at http://www.reuters.com
Get closer to the financial markets with Reuters Messaging - for more
information and to register, visit http://www.reuters.com/messaging
Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Reuters Ltd.
------------------------------
Message-ID: <F9102D41F595D311ACA7009027DE2C8405C07E9B@c3po.heurikon.com>
From: "Kane, Chuck" <chuckk@artesyncp.com>
Subject: [OAUGNet]-Upgrade with accounting periods open
Date: Wed, 20 Aug 2003 09:38:20 -0500
We are hoping to be able to upgrade from 11.0.3 to 11.5.9 without closing
the accounting periods. I've seen some forum postings where others have
done this successfully. Has any one done their 11i upgrade with the
accounting periods open? If so, what steps did you take to verify no data
was corrupted?
------------------------------
Message-ID: <86F845FB0B46BB4F951BA1CA812C16A1403526@man9452ks010.intgame.com>
From: "Costello.Chris" <chris.costello@barcrestgroup.com>
Subject: [OAUGNet]-Rename segmen3t in GL_CODE_COMBINATIONS table - is
it possible ??
Date: Wed, 20 Aug 2003 07:58:02 -0700
Hello,
We want to rename the values within segment3 of the GL_CODE_COMBINATIONS
e.g. from 13505 to 20000. We have tested it by adding the value '20000' in
the Key Flexfields values form and then run an update script to update all
records where segment3 = 13505 and set it to 20000.
We have not conducted extensive testing yet, I was wondering whether anyone
has performed such an update, is such an update possible, is there a simpler
method for achieving our desired result?
Chris
------------------------------
From: "Michael L. Jewell" <mlj3u@virginia.edu>
Subject: [OAUGNet]-excluding retired assets
Message-ID: <SIMEON.10308201355.E@ADS-JYPYX11-W2K.config.mail.virginia.edu>
Date: Wed, 20 Aug 2003 13:32:55 -0400 (Eastern Daylight Time)
FA users,
Any suggestions for handling retired assets since they are not
readily identified as being retired when they show up on FA
forms/queries and in Self Service?
Thanks.
--
Mike Jewell mlj3u@virginia.edu 434-982-2175
------------------------------
Message-ID: <8AB2A24A715BD5119DE400B0D0D115F7DBE749@FSDPINL3>
From: Martin Burger <m.burger@dp.nl>
Subject: [OAUGNet]-adding crm installed base attributes to item
Date: Wed, 20 Aug 2003 19:34:04 +0200
we are implementing CRM Service and Contracts
For implementing service and contracts we need to add some attributes to
the items.
(trackable, serviceable, etc)
This can only be done by setting the stock level to zero
To do so, we need to do the following actions
· stop pick release
· backorder all salesorders , which lines have been released
· put message in shipping instructions: !!!!!!!!DO NOT PICK!!!!!!!!!
· check production orders
· save stocklevel of relevant items
· do a miscellaneous trx of the items, bring down to zero
· change attributes
· do a miscellaneous trx of the items, bring back to original stock
level
· checking/modfiying status production orders
· start pick release again
We do have a great number of sales orders , with pick released ( about 300)
Is there any other/better way to do it.
Martin Burger
IT
t (0172) 488 348
f (0172) 468 947
m 0031 654258125
m.burger@dp.nl <mailto:m.burger@dp.nl>
--
-----Oorspronkelijk bericht-----
Van: OAUGNet ListServ [mailto:OAUGNet@oaug.com]
Verzonden: zaterdag 16 augustus 2003 11:02
Aan: OAUGNet ListServ
Onderwerp: OAUGNet Digest #219
OAUGNet ListServ Digest #219
1) Re: BOM and Planning Experts - How to handle tricky BOM usage. by "Tom
Hery" <tomhery@cox.net>
2) Re: OM Header not closing after ONT H applied by "Tom Hery"
<tomhery@cox.net>
3) Re: SSP to I-Procurement Upgrade by Peter Lane <Peter.Lane@pace.co.uk>
4) Question on Displaying Output in SQL by "Reyes, Joe"
<joreyes@firstam.com>
5) Re: Question on Displaying Output in SQL by Shashi.Nair@prudential.com
6) Re: DFF in Item Relationship Form by Kevin Brown
<kbrown@symmetricom.com>
7) Re: Question on Displaying Output in SQL by Rashmi Kumar
<rashmikumar2000@yahoo.com>
8) Re: Corp Credit Cards with iExpenses by Paul Fernandez
<paulfernz@yahoo.com>
9) Invoice Approval Workflow:Create Accounting after Invoice is Validated
but befor by "Muzaffer Lakdawala" <muzaffarl@comcast.net>
This digest is sent to you because you are subscribed to
the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, E-mail to <OAUGNet-feed@oaug.com>
Send administrative queries to <OAUGNet-request@oaug.com>
----------------------------------------------------------------------
From: "Tom Hery" <tomhery@cox.net>
Subject: [OAUGNet]-Re: BOM and Planning Experts - How to handle tricky
BOM usage.
Date: Thu, 14 Aug 2003 23:29:15 -0700
Message-ID: <HMEFKKBDCKCNEBDCNCPKIEHECEAA.tomhery@cox.net>
I would do this. Make 24 items with a primary UOM of Bar. For example,
ItemB24, ItemB23, ItemB22...ItemB3, ItemB2, ItemB1. Then the BOM, for
examle on an parent ItemA that uses 17 feet, would look as follows.
Parent ItemA (17 feet long)
qty 1 of Component ItemB24
qty -1 of Component ItemB7
This makes ItemB24 a required component and ItemB7 a by-product of a work
order. For example, when there is a work order for qty 3 of ItemA, ItemB
is require and three units will be issued. When the work order is
completed, three of ItemA (17 foot parent) is put in stock. ALSO, three of
ItemB7 are returned to stock (the by-product) by de-issueing them from the
work order. You now have qty 3 of the 7 foot bars in stock. This also
keeps the cost correct, as the net cost to the work order is (3 x ItemB24) -
(3 x ItemB7), a net cost of 51 feet.
Of course, after this work order, there is now qty 3 of ItemB7 in stock. A
subsequent work order for ItemC (a seven foot parent), that may use ItemB7,
can get them directly from stock. Of course its BOM would have 1 ItemB24
and -1 ItemB17 (by-product). If there are ItemB7 in stock, merely issue
them instead of ItemB24, if not perform the normal issue of the 24 foot bar.
After a short period of time, I would guest that all item lengths would have
inventory and the system would flow smoothly. This might also work well
with a kanban pull system.
You could also go wild and make ItemB7 a parent with a BOM of qty .3333
ItemB24 and qty -.1111 of ItemB3 such that when a work order was released
for qty 3 (order multiplier) of ItemB7 then qty 1 of ItemB24 is issued and
qty 3 of ItemB7 are put into stock. Then de-issue qty 1 of ItemB3. Stock
on hand = 3 of ItemB7 and 1 of ItemB3
Food for thought!
-----Original Message-----
From: OAUGNet ListServ [mailto:OAUGNet@oaug.com]On Behalf Of Rowe,
Jaimie
Sent: Monday, August 11, 2003 6:25 AM
To: OAUGNet ListServ
Subject: [OAUGNet]-BOM and Planning Experts - How to handle tricky BOM
usage.
Here is the scenario;
We purchase various raw materials in fixed lengths that we then cut to
length for that particular application. I will use steel rod in this
example.
We purchase and inventory steel rod in 24 foot lengths. We then cut it as
the first step in a fabrication operation. On any given day that steel rod
will be cut into any number of lengths (3 feet, 7 feet, 16 feet, 23 feet,
etc). The issue is that if we inventory that rod in feet then MRP will
under-plan if we cut the rod in long lengths. Example below;
Discrete Job Requirement - 3 pieces
Operation 10 - Cut rod into 16 foot lengths.
Material Requirements: Steel Rod BOM Usage:
16 feet
Assuming no on-hand inventory MRP will tell us to order 48 feet (3 pieces x
16 feet) when in fact I need 3 rods at 24 feet each or 72 feet ( I cannot
weld pieces together). If the pieces had been less than half the rod length
MRP would have planned more accurately e.g. 3 pieces x 7 feet.
If I inventory the rod as EACH I can resolve some of the issues but not all.
Discrete Job Requirement - 3 pieces
Operation 10 - Cut rod into 16 foot lengths.
Material Requirements: Steel Rod BOM Usage: 1
EACH
In this case MRP will tell me to order 3 rods but I have done two things
wrong. One, I have over-costed the item because in actuality I am only
using 0.66 of the rod. Two, the remaining 8 feet that was left over from
each cut will most likely be used on another discrete job where the cut
length is short, say 3 feet.
I am not sure there is any perfect solution to this but I know that we are
not the only company with this issue. I would like to get some input on how
other companies handle this situation or just your personal opinion on how
to best plan (and cost) this type of material.
I look forward to you input.
Regards,
Jaimie
#############################################################
This message is sent to you because you are subscribed to the mailing list
<OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to <OAUGNet-request@oaug.com>
------------------------------
From: "Tom Hery" <tomhery@cox.net>
Subject: [OAUGNet]-Re: OM Header not closing after ONT H applied
Date: Thu, 14 Aug 2003 23:34:15 -0700
Message-ID: <HMEFKKBDCKCNEBDCNCPKAEHFCEAA.tomhery@cox.net>
We have implemented this change and have had no problem with Oracle support.
They are fully aware of this change and it does not cause any issues for
them.
-----Original Message-----
From: OAUGNet ListServ [mailto:OAUGNet@oaug.com]On Behalf Of
Shingireddy,Ahalya
Sent: Wednesday, August 13, 2003 2:02 PM
To: OAUGNet ListServ
Subject: [OAUGNet]-Re: OM Header not closing after ONT H applied
Then that would not be supported by oracle if something happens right? The
reason why I am asking is everyone would have upgraded orders in the system
when they go live and I am facing the same situation. Trying to get a script
from oracle so that they would support it down the road.
Ahalya.
-----Original Message-----
From: Viswanatha, Prasad [SMTP:ViswanathaP@AETNA.com]
Sent: Wednesday, August 13, 2003 4:44 PM
To: OAUGNet ListServ
Subject: [OAUGNet]-Re: OM Header not closing after ONT H
applied
No. It will not effect already processed orders. If you want to
close
them you have to update the attribute value in the workflow tables
and
rerun the background process.
Prasad
-----Original Message-----
From: Shingireddy,Ahalya [mailto:AShingireddy@bioreliance.com]
Sent: Wednesday, August 13, 2003 4:36 PM
To: OAUGNet ListServ
Subject: [OAUGNet]-Re: OM Header not closing after ONT H applied
How would you fix the orders that is already processed and took the
values which has last day of the month? By modifying the value to 1
day
it would take into effect for the order that are going to be created
from then on... isn't it? Will this change take into effect for the
existing ones also?
Ahalya
-----Original Message-----
From: Viswanatha, Prasad [SMTP:ViswanathaP@AETNA.com]
Sent: Wednesday, August 13, 2003 3:49 PM
To: OAUGNet ListServ
Subject: [OAUGNet]-Re: OM Header not closing after
ONT H
applied
It is because in the OM Order Header workflow , there is a
wait
activity
and the attribute value is end of the month. We
customized the workflow in my previous site and changed the
attribute
value to 1 day, so the order will get closed one day after
all
the lines
are closed as per our business requirements. If you want the
order to
get closed immediately you can remove the wait activity
completely from
the OM Order Header workflow.
Prasad
-----Original Message-----
From: OBeirne, Sean [mailto:Sean.OBeirne@fallon-clinic.com]
Sent: Wednesday, August 13, 2003 3:39 PM
To: OAUGNet ListServ
Subject: [OAUGNet]-Re: OM Header not closing after ONT H
applied
Margie,
We experienced the same thing, and found that the order
header
closes at
month end even though the order lines closed during the
month.
We have
not found a solution.
Sean
-----Original Message-----
From: Graham, Margie [mailto:grahama@sierrahealth.com]
Sent: Wednesday, August 13, 2003 3:35 PM
To: OAUGNet ListServ
Subject: [OAUGNet]-OM Header not closing after ONT H applied
Hello,
Has anyone else had this issue....
We upgraded from 11iOM_PF_G to 11iOM_PF_H ONT and now
eventho
the lines
of our sales orders are closed, the sales order header (OM
Order
Header)
still says booked. Oracle says it is now standard
functionality
for
orders to close only at the end of the month. We want our
orders
to
close immediately after the workflow backgrouind processor
completes
like they used to. We have tried changing the attribute of
the
OM Order
Header workflow but we have had no success. Any help would
be
appreciated. Margie Graham
Sr. Financial Systems Analyst
Sierra Health Services, Inc.
Las Vegas, Nevada
702-240-8834
grahama@sierrahealth.com
This communication, including any attachments, may contain
confidential
information and is intended only for the individual or
entity to
whom it
is addressed. Any review, dissemination, or copying of this
communication by anyone other than the intended recipient is
strictly
prohibited. If you are not the intended recipient, please
contact the
sender by reply e-mail, delete and destroy all copies of the
original
message.
#############################################################
This message is sent to you because you are subscribed to
the
mailing
list <OAUGNet@oaug.com>. To unsubscribe, E-mail to:
<OAUGNet-off@oaug.com> To switch to the FEED mode, send any
message to
<OAUGNet-feed@oaug.com> To switch to the DIGEST mode, E-mail
to
<OAUGNet-digest@oaug.com> To switch to the INDEX mode,
E-mail to
<OAUGNet-index@oaug.com> Send administrative queries to
<OAUGNet-request@oaug.com>
Note: The information contained in this message is intended
only
for the
use by the individual or entity to which it is addressed.
This
message
may contain information that is privileged, confidential and
exempt from
disclosure under applicable law. If you are not the intended
recipient,
you are hereby notified that any dissemination, distribution
or
copying
of this information is strictly prohibited. If you received
this
communication in error, please notify
us immediately and delete the original message.
#############################################################
This message is sent to you because you are subscribed to
the
mailing
list <OAUGNet@oaug.com>. To unsubscribe, E-mail to:
<OAUGNet-off@oaug.com> To switch to the FEED mode, send any
message to
<OAUGNet-feed@oaug.com> To switch to the DIGEST mode, E-mail
to
<OAUGNet-digest@oaug.com> To switch to the INDEX mode,
E-mail to
<OAUGNet-index@oaug.com> Send administrative queries to
<OAUGNet-request@oaug.com>
This e-mail may contain confidential or privileged
information.
If you
think you have received this e-mail in error, please advise
the
sender by
reply e-mail and then delete this e-mail immediately. Thank
you. Aetna
#############################################################
This message is sent to you because you are subscribed to
the
mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to
<OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to
<OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to
<OAUGNet-index@oaug.com>
Send administrative queries to <OAUGNet-request@oaug.com>
#############################################################
This message is sent to you because you are subscribed to the
mailing
list <OAUGNet@oaug.com>. To unsubscribe, E-mail to:
<OAUGNet-off@oaug.com> To switch to the FEED mode, send any message
to
<OAUGNet-feed@oaug.com> To switch to the DIGEST mode, E-mail to
<OAUGNet-digest@oaug.com> To switch to the INDEX mode, E-mail to
<OAUGNet-index@oaug.com> Send administrative queries to
<OAUGNet-request@oaug.com>
#############################################################
This message is sent to you because you are subscribed to the
mailing list
<OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to
<OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to <OAUGNet-request@oaug.com>
#############################################################
This message is sent to you because you are subscribed to the mailing list
<OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to <OAUGNet-request@oaug.com>
------------------------------
Message-ID:
<44632C76B97BD211AF6B00805FADCAB21118D6AD@exchange.saltaire.pace.co.uk>
From: Peter Lane <Peter.Lane@pace.co.uk>
Subject: [OAUGNet]-Re: SSP to I-Procurement Upgrade
Date: Fri, 15 Aug 2003 11:17:11 +0100
We went from 11.0.3 to 11.5.8 in March - we have 3 o/s tars re SSP - the
system works but they are very irritating.
No question I would wait to implement - I think you will have enough to do
with your upgrade alone.
Peter Lane
Pace Micro Technology plc
peter.lane@pace.co.uk
> -----Original Message-----
> From: Bill Kafouse [SMTP:Bill.Kafouse@alkermes.com]
> Sent: Thursday, August 14, 2003 6:43 PM
> To: OAUGNet ListServ
> Subject: [OAUGNet]-SSP to I-Procurement Upgrade
>
>
> I am preparing to upgrade our Oracle apps from 11.0.3 to 11.5.9
> and our data base from 8i to 9i.
>
> I am in the process of implementing SSP v5 (Self Service Purchasing)
> in our current 11.0.3 environment.
>
> Has anyone upgraded SSP v5 in 11.0.x to I-Procurement in 11.5.9
>
> Were there any problems or issues encountered.
>
> Should I proceed with the SSP implementation or wait and implement
> a new/clean version of I-Procurement during or after the upgrade.
>
>
>
> Thanks,
>
> Bill Kafouse
>
>
> Alkermes Inc.
> 617 583 6161
> bill.kafouse@alkermes.com
>
>
>
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing list
<OAUGNet@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
> To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
> To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
> To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
> Send administrative queries to <OAUGNet-request@oaug.com>
------------------------------
Message-ID:
<9B877D7894B5D31196FA00508B6F0C0014653670@mailhost.res.firstam.com>
From: "Reyes, Joe" <joreyes@firstam.com>
Subject: [OAUGNet]-Question on Displaying Output in SQL
Date: Fri, 15 Aug 2003 07:42:03 -0700
Hi y'all,
Current SQL output format looks like this:
ITEM_ID LOCATION
0001 AR
0001 AZ
0001 CA
0002 AR
0002 AZ
0002 CA
0003 AZ
I would like to have the format display as follows (with or without the
column headings):
ITEM_ID LOCATION
0001 AR AZ CA
0002 AR AZ CA
0003 AZ
The reason being is that we have a lot of items in the table, with each item
having at least 20 locations... I would like to reduce the number of rows
displayed.
Can someone help me out on this?
Thanks in advance.
**********************************************************************
This message contains confidential information intended only for the
use of the addressee(s) named above and may contain information that
is legally privileged. If you are not the addressee, or the person
responsible for delivering it to the addressee, you are hereby
notified that reading, disseminating, distributing or copying this
message is strictly prohibited. If you have received this message by
mistake, please immediately notify us by replying to the message and
delete the original message immediately thereafter.
Thank you. FADLD Tag
**********************************************************************
------------------------------
Subject: [OAUGNet]-Re: Question on Displaying Output in SQL
Message-ID:
<OF1927DABB.9BBE4FB1-ON07256D83.005144DD-07256D83.0052076E@prudential.com>
From: Shashi.Nair@prudential.com
Date: Fri, 15 Aug 2003 07:52:02 -0700
similar question came up yesterday ...here's the reply from
siva.marakani@wgint.com (Siva Marakani)
One way of doing it is build your own pl/sql as mentioned below
----------------------
declare
v_customer varchar(100) := null;
v_doctor varchar2(100) := null;
begin
for CursCust in (select distinct customer from customer) loop
v_customer := CursCust.customer;
for CursDoct in (select doctor from customer where customer =
v_customer) loop
if v_doctor is null then
v_doctor := CursDoct.doctor;
else
v_doctor := v_doctor||','||CursDoct.doctor;
end if;
end loop;
dbms_output.put_line(v_customer||' '||v_doctor);
v_customer := null;
v_doctor := null;
end loop;
end;
----------------------
-----Original Message-----
From: OAUGNet ListServ [mailto:OAUGNet@oaug.com]On Behalf Of Prakash
Tallapragada
Sent: Tuesday, August 12, 2003 3:48 PM
To: OAUGNet ListServ
Subject: [OAUGNet]-SQL
Hi,
I've the following data structure:
Customer Doctor
------------------------
ABC 123
ABC 234
ABC 345
BCA 123
BCA 456
I would like to show the above data in two dimensions as following:
Customer Doctor
-----------------------
ABC 123,234,345
BCA 123,456
Doctor Customer
---------------------------
123 ABC, BCA
234 ABC
345 ABC
456 BCA
Appreciate any of your suggestions in this regard.
Thanks,
Prakash-
==========================================
"Reyes, Joe" <joreyes@firstam.com>
To:
"OAUGNet ListServ"
Sent by: "OAUGNet ListServ"
<OAUGNet@oaug.com>
<OAUGNet@oaug.com> cc:
Subject:
[OAUGNet]-Question on Displaying Output in SQL
Friday August 15, 2003 07:42 AM
Please respond to "OAUGNet ListServ"
Hi y'all,
Current SQL output format looks like this:
ITEM_ID LOCATION
0001 AR
0001 AZ
0001 CA
0002 AR
0002 AZ
0002 CA
0003 AZ
I would like to have the format display as follows (with or without the
column headings):
ITEM_ID LOCATION
0001 AR AZ CA
0002 AR AZ CA
0003 AZ
The reason being is that we have a lot of items in the table, with each
item
having at least 20 locations... I would like to reduce the number of rows
displayed.
Can someone help me out on this?
Thanks in advance.
**********************************************************************
This message contains confidential information intended only for the
use of the addressee(s) named above and may contain information that
is legally privileged. If you are not the addressee, or the person
responsible for delivering it to the addressee, you are hereby
notified that reading, disseminating, distributing or copying this
message is strictly prohibited. If you have received this message by
mistake, please immediately notify us by replying to the message and
delete the original message immediately thereafter.
Thank you. FADLD Tag
**********************************************************************
#############################################################
This message is sent to you because you are subscribed to the mailing list
<OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to <OAUGNet-request@oaug.com>
------------------------------
Message-ID:
<AF449FA252F4D311A01B00508B60540F0782D773@exchange.symmetricom.com>
From: Kevin Brown <kbrown@symmetricom.com>
Subject: [OAUGNet]-Re: DFF in Item Relationship Form
Date: Fri, 15 Aug 2003 08:09:45 -0700
Charles,
> From the form where you can view the DFF select Help -> Diagnostics ->
Examine (or Help -> Tools -> Examine pre 11i) and change the block value to
$DESCRIPTIVE_FLEXFIELD$. In the Field field select the value that is matches
the form you are on and press Tab. The name of the DFF and the Application
will then appear in the Value field.
Kevin
-----Original Message-----
From: Charles Setiawan [mailto:Charles.Setiawan@metrodata.co.id]
Sent: Thursday, August 14, 2003 7:34 PM
To: OAUGNet ListServ
Subject: [OAUGNet]-DFF in Item Relationship Form
Hi all,
Has anyone ever defined DFF in Item Relationship form?
We can't find the title of "Item Relationship" in Oracle Inventory when
we're
trying to define DFF.
Your input are appreciated,
Regards,
Charles
#############################################################
This message is sent to you because you are subscribed to the mailing list
<OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to <OAUGNet-request@oaug.com>
------------------------------
Message-ID: <20030815162856.72626.qmail@web40512.mail.yahoo.com>
Date: Fri, 15 Aug 2003 09:28:56 -0700 (PDT)
From: Rashmi Kumar <rashmikumar2000@yahoo.com>
Subject: [OAUGNet]-Re: Question on Displaying Output in SQL
Check this tip from OTN
http://otn.oracle.com/oramag/code/tips2003/072703.html.
Hope that helps.
--- "Reyes, Joe" <joreyes@firstam.com> wrote:
> Hi y'all,
>
> Current SQL output format looks like this:
>
> ITEM_ID LOCATION
> 0001 AR
> 0001 AZ
> 0001 CA
> 0002 AR
> 0002 AZ
> 0002 CA
> 0003 AZ
>
>
> I would like to have the format display as follows
> (with or without the
> column headings):
>
> ITEM_ID LOCATION
> 0001 AR AZ CA
> 0002 AR AZ CA
> 0003 AZ
>
>
> The reason being is that we have a lot of items in
> the table, with each item
> having at least 20 locations... I would like to
> reduce the number of rows
> displayed.
>
> Can someone help me out on this?
>
> Thanks in advance.
>
>
>
**********************************************************************
> This message contains confidential information
> intended only for the
> use of the addressee(s) named above and may contain
> information that
> is legally privileged. If you are not the
> addressee, or the person
> responsible for delivering it to the addressee, you
> are hereby
> notified that reading, disseminating, distributing
> or copying this
> message is strictly prohibited. If you have
> received this message by
> mistake, please immediately notify us by replying to
> the message and
> delete the original message immediately thereafter.
>
> Thank you.
> FADLD Tag
>
**********************************************************************
>
>
>
#############################################################
> This message is sent to you because you are
> subscribed to the mailing list <OAUGNet@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
> To switch to the FEED mode, send any message to
> <OAUGNet-feed@oaug.com>
> To switch to the DIGEST mode, E-mail to
> <OAUGNet-digest@oaug.com>
> To switch to the INDEX mode, E-mail to
> <OAUGNet-index@oaug.com>
> Send administrative queries to
> <OAUGNet-request@oaug.com>
>
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
------------------------------
Message-ID: <20030815194016.54560.qmail@web10503.mail.yahoo.com>
Date: Fri, 15 Aug 2003 12:40:16 -0700 (PDT)
From: Paul Fernandez <paulfernz@yahoo.com>
Subject: [OAUGNet]-Re: Corp Credit Cards with iExpenses
Shannon,
I sense that your situtation is such that you have
Corp Credit cards, but it is 'Invidual Pay'. In this
situation, you can have the 'Individual Pay' as well
as 'Itemize'.
When an employee submits an expense (e.g. hotel bill)
that has some personal items (not allowed by the
company), he/she can deduct it from the expense line
by itemizing that line. For example, if his receipt is
for 1,000.00 and it contains 100.00 personal expenses,
in the Itemize area, he should enter only 900.00 and
then the 100.00 gets treated as Personal expense and
it shows up as Personal at the bottom of that page.
I don't know which version of iExpense you are
implemetning. I am implementing OIE.G currently, and
this feature is avialble.
Feel free to contact, if you have any questions.
Paul
From: "Rea, Shannon" <srea@empirix.com>
Subject: [OAUGNet]-Re: Corp Credit Cards with
iExpenses
Date: Wed, 13 Aug 2003 16:36:14 -0400
We're actually using "Individual" where we don't have
anyone entering
personal expenses. Is there anything that we can do
that is similar?
Best regards,
Shannon
-----Original Message-----
From: Brent Hanke [mailto:Brent.Hanke@meredith.com]
Sent: Wednesday, August 13, 2003 3:06 PM
To: OAUGNet ListServ
Subject: [OAUGNet]-Re: Corp Credit Cards with
iExpenses
They can itemize that line amount (split it out) and
any amount left
over will get marked as personal.
We are using "company pay" and that's how it is
handled here.
Brent Hanke
Meredith Corporation
-----Original Message-----
From: Rea, Shannon [mailto:srea@empirix.com]
Sent: Wednesday, August 13, 2003 12:53 PM
To: OAUGNet ListServ
Subject: [OAUGNet]-Corp Credit Cards with iExpenses
We are just implementing Corporate Credit Cards with
iExpenses and AP.
Is
it possible to allow users to change the amount of the
transaction when
generating an expense report? We will have some
employees that will be
submitting expense reports that have personal costs in
a hotel bill
charge
that will need to reduce the overall amount of the
transaction.
Best regards,
Shannon Rea
Business Systems Analyst
p| 781.993.8584 f| 781.993.8601
email | srea@empirix.com <mailto:srea@empirix.com>
1430 Main Street| Waltham, MA | 02451
E M P I R I X
www.empirix.com
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
------------------------------
From: "Muzaffer Lakdawala" <muzaffarl@comcast.net>
Subject: [OAUGNet]-Invoice Approval Workflow:Create Accounting after
Invoice is Validated but before Approved
Date: Fri, 15 Aug 2003 18:50:25 -0700
Message-ID: <JAEKLMKDEMHEEDDFCCKHAECFECAA.muzaffarl@comcast.net>
We have configured Invoice Approval Workflow, where set-up option is to
Validate Invoice prior to Initiate Approval.
Invoice is Validated, then Initiated for Approval. However we have a weekly
Concurrent Program to create Accounting and transfer it to GL, which creates
accounting for VALIDATED invoices and transfers them to GL. When this is
done, not necessarily all invoices are APPROVED. There may be some in
approval process. Next thing you know is somebody has REJECTED the invoice.
This does not pulls data out of General Ledger nor reverses Accounting, even
though we run our create accounting program again. Am I missing something or
others out there have also faced similar problem and what is the resolution
they have taken.
Regards,
ML
'Most people see things as they are and wonder why. I see things that never
were and say why not.' Once our leaders start with this mindset, the
solution is very simple. We have to see beyond the constraint, using it as
an opportunity. It's all in the mind.
*****************************************
* I M P O R T A N T N O T I C E *
*****************************************
This E-mail is confidential. It may also be legally privileged. If you are
not the addressee you may not copy, forward, disclose or use any part of it.
If you have received this message in error, please delete it and all copies
from your system and notify the sender immediately by return E-mail. When
addressed to our clients any opinions or advice contained in this email are
subject to the terms and conditions expressed in the governing client
engagement letter.
Internet communications cannot be guaranteed to be timely, secure, error or
virus-free. The sender does not accept liability for any errors or
omissions.
------------------------------
End of OAUGNet ListServ Digest #219
***********************************
------------------------------
Message-ID: <20030820173531.89943.qmail@web14309.mail.yahoo.com>
Date: Wed, 20 Aug 2003 10:35:31 -0700 (PDT)
From: irfan dogan <irfan1523@yahoo.com>
Subject: [OAUGNet]-update Inventory balances(supply+onhand qty) in
oracle from Other Crib Master system
Hi All,
We used to use Min-max planning for crib items in
oracle. Purchasing got smart idea, and moved this to
third part crib master system. We have been using this
system about 6 months. Now we want to transfer all the
purchase orders and inventory/min-max balances to
Oracle back. Crib items are in oracle, but purchase
orders, supply, and onhand quantities are way off.
I have been looking at this, and try to develop a
strategy to accomplish this task. I got some ideas,
like importing purchase orders that should create
supply balances and onhand quantities.
I guess I should update/insert mtl_supply,
mtl_material_transactions, and mtl_onhand_quantities.
I am not sure about any API that could help me on
this.
I would like to get any solution/idea that you may
share with me.
Thanks a lot for any input.
Irfan
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
------------------------------
Subject: [OAUGNet]-Re: excluding retired assets
Date: Wed, 20 Aug 2003 12:38:07 -0500
Message-ID: <A5C8BA339DBAC44DB7F52DC8371ACB1C10EB43@wmstutem02.williams.com>
From: "Maness, John" <John.Maness@Williams.com>
To exclude retired assets in a report, in our reporting tool (Impromptu)
we use the following in the summary filter:
COST <>0
This has to be done in the summary filter. If it is done in the detail
filter, it could exclude the last record of zero on a retired asset but
then pick up the previous record with a cost of something other than
zero. So if you use the detail filter you would end up with retired
assets with a cost in your report which you don't want.
-----Original Message-----
From: Michael L. Jewell [mailto:mlj3u@virginia.edu]
Sent: Wednesday, August 20, 2003 12:33 PM
To: OAUGNet ListServ
Subject: [OAUGNet]-excluding retired assets
FA users,
Any suggestions for handling retired assets since they are not
readily identified as being retired when they show up on FA
forms/queries and in Self Service?
Thanks.
--
Mike Jewell mlj3u@virginia.edu 434-982-2175
#############################################################
This message is sent to you because you are subscribed to the mailing
list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to <OAUGNet-request@oaug.com>
------------------------------
Message-ID: <CD6B986D72B95B4CA7FE3E3743687E26CD751B@trnhemail01.corp.timken.com>
From: "Leclerc, Marcel A., Jr (Marc)" <MARC.LECLERC@timken.com>
Subject: [OAUGNet]-Re: update Inventory balances(supply+onhand qty) in
ora
cle from Other Crib Master system
Date: Wed, 20 Aug 2003 16:57:09 -0400
What version of Oracle ?
There is a standard API for the onhand balances ..
You can use the item master import .. choose change items for the min-max
qty's reorder pts etc etc.
Just not sure about the PO's.
Marc LeClerc
-----Original Message-----
From: irfan dogan [mailto:irfan1523@yahoo.com]
Sent: Wednesday, August 20, 2003 1:36 PM
To: OAUGNet ListServ
Subject: [OAUGNet]-update Inventory balances(supply+onhand qty) in
oracle from Other Crib Master system
Hi All,
We used to use Min-max planning for crib items in
oracle. Purchasing got smart idea, and moved this to
third part crib master system. We have been using this
system about 6 months. Now we want to transfer all the
purchase orders and inventory/min-max balances to
Oracle back. Crib items are in oracle, but purchase
orders, supply, and onhand quantities are way off.
I have been looking at this, and try to develop a
strategy to accomplish this task. I got some ideas,
like importing purchase orders that should create
supply balances and onhand quantities.
I guess I should update/insert mtl_supply,
mtl_material_transactions, and mtl_onhand_quantities.
I am not sure about any API that could help me on
this.
I would like to get any solution/idea that you may
share with me.
Thanks a lot for any input.
Irfan
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
#############################################################
This message is sent to you because you are subscribed to the mailing list
<OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to <OAUGNet-request@oaug.com>
------------------------------
Message-ID: <20030820215002.28040.qmail@web11701.mail.yahoo.com>
Date: Wed, 20 Aug 2003 14:50:02 -0700 (PDT)
From: Dominic <dd19714@yahoo.com>
Subject: [OAUGNet]-please stop emails to my id which are not relevant
to me
Attention listserv admin,
Why am i getting all these emails. I have subscribed
to the list serv but I do not want to recieve emails
on topics that I am not concerned with.
Thanks,
--- "Leclerc, Marcel A., Jr (Marc)"
<MARC.LECLERC@timken.com> wrote:
> What version of Oracle ?
>
> There is a standard API for the onhand balances ..
>
> You can use the item master import .. choose change
> items for the min-max
> qty's reorder pts etc etc.
>
> Just not sure about the PO's.
>
> Marc LeClerc
>
>
> -----Original Message-----
> From: irfan dogan [mailto:irfan1523@yahoo.com]
> Sent: Wednesday, August 20, 2003 1:36 PM
> To: OAUGNet ListServ
> Subject: [OAUGNet]-update Inventory
> balances(supply+onhand qty) in
> oracle from Other Crib Master system
>
>
> Hi All,
>
> We used to use Min-max planning for crib items in
> oracle. Purchasing got smart idea, and moved this to
> third part crib master system. We have been using
> this
> system about 6 months. Now we want to transfer all
> the
> purchase orders and inventory/min-max balances to
> Oracle back. Crib items are in oracle, but purchase
> orders, supply, and onhand quantities are way off.
> I have been looking at this, and try to develop a
> strategy to accomplish this task. I got some ideas,
> like importing purchase orders that should create
> supply balances and onhand quantities.
>
> I guess I should update/insert mtl_supply,
> mtl_material_transactions, and
> mtl_onhand_quantities.
> I am not sure about any API that could help me on
> this.
>
> I would like to get any solution/idea that you may
> share with me.
>
> Thanks a lot for any input.
>
> Irfan
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site
> design software
> http://sitebuilder.yahoo.com
>
>
#############################################################
> This message is sent to you because you are
> subscribed to the mailing list
> <OAUGNet@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
> To switch to the FEED mode, send any message to
> <OAUGNet-feed@oaug.com>
> To switch to the DIGEST mode, E-mail to
> <OAUGNet-digest@oaug.com>
> To switch to the INDEX mode, E-mail to
> <OAUGNet-index@oaug.com>
> Send administrative queries to
> <OAUGNet-request@oaug.com>
>
>
#############################################################
> This message is sent to you because you are
> subscribed to the mailing list <OAUGNet@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
> To switch to the FEED mode, send any message to
> <OAUGNet-feed@oaug.com>
> To switch to the DIGEST mode, E-mail to
> <OAUGNet-digest@oaug.com>
> To switch to the INDEX mode, E-mail to
> <OAUGNet-index@oaug.com>
> Send administrative queries to
> <OAUGNet-request@oaug.com>
>
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
------------------------------
Subject: [OAUGNet]-How to handle Notes Receivable with Factoring
Date: Wed, 20 Aug 2003 14:58:30 -0700
Message-ID: <83BB2C958553B9419735D2F9C0F9E9DFFCBBCC@cndexc01.na.coherentinc.com>
From: "Suggula, Mohana" <Mohana.Suggula@coherentinc.com>
Hi All,
I would like to know how to handle Notes Receivable in AR and also how to factor \
them. If you can provide me the setup suggestions, I would appreciate it.
Thanks,
------------------------------
Message-ID: <20030820220715.65020.qmail@web14302.mail.yahoo.com>
Date: Wed, 20 Aug 2003 15:07:15 -0700 (PDT)
From: irfan dogan <irfan1523@yahoo.com>
Subject: [OAUGNet]-Re: update Inventory balances(supply+onhand qty) in
ora cle from Other Crib Master system
Marc,
Thanks. We are on 10.7SC. Items are already on the
system. Problem is po numbers, onhand quantities,
and supply balances which are off due to purchase
orders created in other system other than oracle
applications.
Here is what I think I should follow to accomplish
this task:
1. Create open purchase orders(thru API/Interface)
that are created in third party system.
2.Receive crib items into Inventory with PO receipts
through receipts open interface or API.
3. Adjust supply and onhand quantity balances.
Lets'say:
Item# 1230 has onhand qty 0 supply with diff. po
Now third party system shows that
Item# 1230 has onhand qty00 supplyP0
I guess It needs to be adjusted because when you look
at Supply/Deman and Onhand quantity screens you will
see differences.
Any help appreciated.
Thanks
Irfan
--- "Leclerc, Marcel A., Jr (Marc)"
<MARC.LECLERC@timken.com> wrote:
> What version of Oracle ?
>
> There is a standard API for the onhand balances ..
>
> You can use the item master import .. choose change
> items for the min-max
> qty's reorder pts etc etc.
>
> Just not sure about the PO's.
>
> Marc LeClerc
>
>
> -----Original Message-----
> From: irfan dogan [mailto:irfan1523@yahoo.com]
> Sent: Wednesday, August 20, 2003 1:36 PM
> To: OAUGNet ListServ
> Subject: [OAUGNet]-update Inventory
> balances(supply+onhand qty) in
> oracle from Other Crib Master system
>
>
> Hi All,
>
> We used to use Min-max planning for crib items in
> oracle. Purchasing got smart idea, and moved this to
> third part crib master system. We have been using
> this
> system about 6 months. Now we want to transfer all
> the
> purchase orders and inventory/min-max balances to
> Oracle back. Crib items are in oracle, but purchase
> orders, supply, and onhand quantities are way off.
> I have been looking at this, and try to develop a
> strategy to accomplish this task. I got some ideas,
> like importing purchase orders that should create
> supply balances and onhand quantities.
>
> I guess I should update/insert mtl_supply,
> mtl_material_transactions, and
> mtl_onhand_quantities.
> I am not sure about any API that could help me on
> this.
>
> I would like to get any solution/idea that you may
> share with me.
>
> Thanks a lot for any input.
>
> Irfan
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site
> design software
> http://sitebuilder.yahoo.com
>
>
#############################################################
> This message is sent to you because you are
> subscribed to the mailing list
> <OAUGNet@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
> To switch to the FEED mode, send any message to
> <OAUGNet-feed@oaug.com>
> To switch to the DIGEST mode, E-mail to
> <OAUGNet-digest@oaug.com>
> To switch to the INDEX mode, E-mail to
> <OAUGNet-index@oaug.com>
> Send administrative queries to
> <OAUGNet-request@oaug.com>
>
>
#############################################################
> This message is sent to you because you are
> subscribed to the mailing list <OAUGNet@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
> To switch to the FEED mode, send any message to
> <OAUGNet-feed@oaug.com>
> To switch to the DIGEST mode, E-mail to
> <OAUGNet-digest@oaug.com>
> To switch to the INDEX mode, E-mail to
> <OAUGNet-index@oaug.com>
> Send administrative queries to
> <OAUGNet-request@oaug.com>
>
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
------------------------------
Message-ID: <3F43F115.17EF8CF7@colostate.edu>
Date: Wed, 20 Aug 2003 16:07:17 -0600
From: Mark Britton <mbritton@colostate.edu>
Subject: [OAUGNet]-Re: please stop emails to my id which are not
relevantto me
ROFL
Now that would be quite an advance in software technology....I guess the main loop \
would go something like this:
begin
main_loop:
message := receive_mail;
subject := get_mail_subject;
for c1 in csr_subscribers loop
read_subscribers_mind; -- this will be the tough one to write
if mail_is_relevant_to_subscriber(c1.subscriber, subject) then
send_mail(message,subscriber);
end;
end loop;
goto main_loop
end;
Seriously...if you don't want every single email, subscribe to the digest mode. Then \
you get a list of all the messages for the day and you can pick and choose which ones \
you want to read.
Dominic wrote:
> Attention listserv admin,
>
> Why am i getting all these emails. I have subscribed
> to the list serv but I do not want to recieve emails
> on topics that I am not concerned with.
>
> Thanks,
>
> --- "Leclerc, Marcel A., Jr (Marc)"
> <MARC.LECLERC@timken.com> wrote:
> > What version of Oracle ?
> >
> > There is a standard API for the onhand balances ..
> >
> > You can use the item master import .. choose change
> > items for the min-max
> > qty's reorder pts etc etc.
> >
> > Just not sure about the PO's.
> >
> > Marc LeClerc
> >
> >
> > -----Original Message-----
> > From: irfan dogan [mailto:irfan1523@yahoo.com]
> > Sent: Wednesday, August 20, 2003 1:36 PM
> > To: OAUGNet ListServ
> > Subject: [OAUGNet]-update Inventory
> > balances(supply+onhand qty) in
> > oracle from Other Crib Master system
> >
> >
> > Hi All,
> >
> > We used to use Min-max planning for crib items in
> > oracle. Purchasing got smart idea, and moved this to
> > third part crib master system. We have been using
> > this
> > system about 6 months. Now we want to transfer all
> > the
> > purchase orders and inventory/min-max balances to
> > Oracle back. Crib items are in oracle, but purchase
> > orders, supply, and onhand quantities are way off.
> > I have been looking at this, and try to develop a
> > strategy to accomplish this task. I got some ideas,
> > like importing purchase orders that should create
> > supply balances and onhand quantities.
> >
> > I guess I should update/insert mtl_supply,
> > mtl_material_transactions, and
> > mtl_onhand_quantities.
> > I am not sure about any API that could help me on
> > this.
> >
> > I would like to get any solution/idea that you may
> > share with me.
> >
> > Thanks a lot for any input.
> >
> > Irfan
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free, easy-to-use web site
> > design software
> > http://sitebuilder.yahoo.com
> >
> >
> #############################################################
> > This message is sent to you because you are
> > subscribed to the mailing list
> > <OAUGNet@oaug.com>.
> > To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
> > To switch to the FEED mode, send any message to
> > <OAUGNet-feed@oaug.com>
> > To switch to the DIGEST mode, E-mail to
> > <OAUGNet-digest@oaug.com>
> > To switch to the INDEX mode, E-mail to
> > <OAUGNet-index@oaug.com>
> > Send administrative queries to
> > <OAUGNet-request@oaug.com>
> >
> >
> #############################################################
> > This message is sent to you because you are
> > subscribed to the mailing list <OAUGNet@oaug.com>.
> > To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
> > To switch to the FEED mode, send any message to
> > <OAUGNet-feed@oaug.com>
> > To switch to the DIGEST mode, E-mail to
> > <OAUGNet-digest@oaug.com>
> > To switch to the INDEX mode, E-mail to
> > <OAUGNet-index@oaug.com>
> > Send administrative queries to
> > <OAUGNet-request@oaug.com>
> >
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing list \
> <OAUGNet@oaug.com>. To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
> To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
> To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
> To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
> Send administrative queries to <OAUGNet-request@oaug.com>
--
Mark Britton
mbritton@colostate.edu
(970) 491-2948
--
What if the hokey pokey really IS what it's all about?
------------------------------
Message-ID: <ED0253D4AD5BD511828B0060948AC6B605CE5753@auabgn-mxu.wao.alcoa.com>
From: "Solomon, Steven" <Steven.Solomon@alcoa.com.au>
Subject: [OAUGNet]-Re: Rename segmen3t in GL_CODE_COMBINATIONS table -
is
it possible ??
Date: Thu, 21 Aug 2003 07:52:16 +0800
Hi Chris,
I have done something very similar to this in the past, however instead of
creating the new value is the same value set we created a new one. In that
we had our new values as well as a descriptive flexfield with the old value
in it. We then ran a script with updated the GL_CODE_COMBINATIONS with the
new values.
If you want a copy of the script let me know and I'll send it to you, I
think I might also have a design document some where as well.
Cheers
Stephen
Stephen Solomon
Technical Track Lead
EBS - Financial Data Warehouse Project
Alcoa of Australia
* Phone: 61 8 9316 5753 Fax: 61 8 9316 5800
* E-mail: steven.solomon@alcoa.com.au
-----Original Message-----
From: Costello.Chris [mailto:chris.costello@barcrestgroup.com]
Sent: Wednesday, August 20, 2003 10:58 PM
To: OAUGNet ListServ
Subject: [OAUGNet]-Rename segmen3t in GL_CODE_COMBINATIONS table - is it
possible ??
Hello,
We want to rename the values within segment3 of the GL_CODE_COMBINATIONS
e.g. from 13505 to 20000. We have tested it by adding the value '20000' in
the Key Flexfields values form and then run an update script to update all
records where segment3 = 13505 and set it to 20000.
We have not conducted extensive testing yet, I was wondering whether anyone
has performed such an update, is such an update possible, is there a simpler
method for achieving our desired result?
Chris
#############################################################
This message is sent to you because you are subscribed to the mailing list
<OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to <OAUGNet-request@oaug.com>
------------------------------
Message-ID: <20030821070620.33735.qmail@web14310.mail.yahoo.com>
Date: Thu, 21 Aug 2003 00:06:20 -0700 (PDT)
From: Gregg Harvey <gregglharvey@yahoo.com>
Subject: [OAUGNet]-Advanced Query feature in forms, does it still work
for r11i?
In R10.7 I used to be able to use a feature someone
told me was called 'advanced query' though that may
not have been an official name. I have summarized the
steps you would go through below. I have not had any
occasion to use it for a long time but a user just
asked me a question recently where this would have
been useful. However, I was unable to make it work in
r11.5.x. Does anyone know of a way? Specific example
is that he wanted to query all PR lines where the
suggested buyer is null. Its a simple sql query but
the user does not have access.
thanks - Gregg
example from 10.7 (1999)
-----------------------------------
Put form into Query mode: Enter Query.
Enter ‘:a’ in any field - :a.
Execute the Query.
A query form will come up where criteria can be
entered to search on. It executes when ‘OK’ is
clicked.
Operators include - =<aaa>; !=<aaa>; < <aaa>; >
<aaa>; like <’aaa’>; between a and b; in (a,b,…);
is null.
Can use AND or OR to group criteria into the same
statement.
Example - invoice_num in (1234, 5678).
Example - (print_date is null) and (approval_flag ‘Y’).
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
------------------------------
Message-ID: <20030821073447.15427.qmail@web20104.mail.yahoo.com>
Date: Thu, 21 Aug 2003 00:34:47 -0700 (PDT)
From: L Leung <glorywa@yahoo.com>
Subject: [OAUGNet]-include digital signature in AP check - Please Help
Hi
My company just buy the digital signature from Troy.
But Troy does not have any good instruction on how to
modify the APLASP.prt for my APXPBFEL ( Format Payment
Laser ).
so far the signature was print in the right location
but the rest of the data are shift to after the
signature. I want the signature shows up in the
bottom right side of the paper P1500X and P2800Y is
about 5 inch from left and 9.7 inch from top. But
look like oracle does not understand. It first prints
the signature in the right location then the rest of
data.. so it turns out the check was print in the
second page but the signature is in the first page
Here is what I understand ( try many time ) to make it
happened :
1) In the Concurrent program define. remove all the
p_printer_mark_code except the 121 ( the first
signature .. we are only have one signature ).
2) Update APLASP.prt code 121 to include something
like this : esc "(201Q" esc "(s0pxxxxx 201T" esc
"*p1500X" esc "*p2800Y" esc "abcdef" <-- abcdef is the
ASIIC store the digital signature.
PLEASE HELP
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
------------------------------
Subject: [OAUGNet]-Re: reconciling cheques
Message-ID: <OFD675CEDB.2E430865-ON48256D89.002C60F5@bankwest.com>
From: Grant_Turner@bankwest.com.au
Date: Thu, 21 Aug 2003 16:06:20 +0800
Hi Alice, thanks for the quick response. Can I clarify one thing- what is
an "oracle check register" is that a standard program or a customisation.
Thanks
Grant Turner
Finance Systems Administrator - General Ledger
BankWest Finance Department
Phone:08 94497598
Fax:08 94496266
E-mail:grant.turner@bankwest.com.au
Alice Cura
<acura@brooktrou To: "OAUGNet ListServ" \
<OAUGNet@oaug.com> t.com> cc:
Sent by: Subject: [OAUGNet]-Re: reconciling \
cheques "OAUGNet
ListServ"
<OAUGNet@oaug.co
m>
20/08/03 21:01
Please respond
to "OAUGNet
ListServ"
We use excel.
We run an oracle check register and bring it into excel for each account
and
add it to the prior month list of outstanding checks.
We then mark the cleared checks. then sum the cleared checks to make sure
the dollar figure ties to the bank statement amount for cleared checks.
then we delete the purged checks from the worksheet. We have a separate
excel spreadsheet that has all of our bank accounts on it that we do the
actual book to bank reconciliation on and the new outstanding check number
is used here for the reconciliation. Been doing this with Oracle for 6
years and up to 20 different bank accounts.
Hope this helps.
Alice Cura
Brooktrout, Inc.
-----Original Message-----
From: Grant_Turner@bankwest.com.au [mailto:Grant_Turner@bankwest.com.au]
Sent: Wednesday, August 20, 2003 4:59 AM
To: OAUGNet ListServ
Subject: [OAUGNet]-reconciling cheques
Hi, does anybody reconcile their accounts payable cheques not using the
oracle cash management module. If so what alternate software do you use?
Thanks
Grant Turner
Finance Systems Administrator - General Ledger
BankWest Finance Department
Phone:08 94497598
Fax:08 94496266
E-mail:grant.turner@bankwest.com.au
____________________________________________________________________________
___
Unencrypted electronic mail is not secure and may not be authentic.
If you have any doubts as to the contents please telephone to confirm.
This electronic transmission is intended only for those to whom it is
addressed. It may contain information that is confidential, privileged
or exempt from disclosure by law. Any claim to privilege is not waived
or lost by reason of mistaken transmission of this information.
If you are not the intended recipient you must not distribute or copy this
transmission and should please notify the sender. Your costs for doing
this will be reimbursed by the sender.
____________________________________________________________________________
___
#############################################################
This message is sent to you because you are subscribed to the mailing list
<OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to <OAUGNet-request@oaug.com>
#############################################################
This message is sent to you because you are subscribed to the mailing list
<OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to <OAUGNet-request@oaug.com>
_______________________________________________________________________________
Unencrypted electronic mail is not secure and may not be authentic.
If you have any doubts as to the contents please telephone to confirm.
This electronic transmission is intended only for those to whom it is
addressed. It may contain information that is confidential, privileged
or exempt from disclosure by law. Any claim to privilege is not waived
or lost by reason of mistaken transmission of this information.
If you are not the intended recipient you must not distribute or copy this
transmission and should please notify the sender. Your costs for doing
this will be reimbursed by the sender.
_______________________________________________________________________________
------------------------------
Message-ID: <86F845FB0B46BB4F951BA1CA812C16A1403536@man9452ks010.intgame.com>
From: "Costello.Chris" <chris.costello@barcrestgroup.com>
Subject: [OAUGNet]-Re: Advanced Query feature in forms, does it still
work
for r11i?
Date: Thu, 21 Aug 2003 01:48:37 -0700
Just checked for you Gregg and it still seems to work well.
Chris
-----Original Message-----
From: Gregg Harvey [mailto:gregglharvey@yahoo.com]
Sent: 21 August 2003 08:06
To: OAUGNet ListServ
Subject: [OAUGNet]-Advanced Query feature in forms, does it still work
for r11i?
In R10.7 I used to be able to use a feature someone
told me was called 'advanced query' though that may
not have been an official name. I have summarized the
steps you would go through below. I have not had any
occasion to use it for a long time but a user just
asked me a question recently where this would have
been useful. However, I was unable to make it work in
r11.5.x. Does anyone know of a way? Specific example
is that he wanted to query all PR lines where the
suggested buyer is null. Its a simple sql query but
the user does not have access.
thanks - Gregg
example from 10.7 (1999)
-----------------------------------
Put form into Query mode: Enter Query.
Enter ':a' in any field - :a.
Execute the Query.
A query form will come up where criteria can be
entered to search on. It executes when 'OK' is
clicked.
Operators include - =<aaa>; !=<aaa>; < <aaa>; >
<aaa>; like <'aaa'>; between a and b; in (a,b,...);
is null.
Can use AND or OR to group criteria into the same
statement.
Example - invoice_num in (1234, 5678).
Example - (print_date is null) and (approval_flag 'Y').
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
#############################################################
This message is sent to you because you are subscribed to the mailing list
<OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to <OAUGNet-request@oaug.com>
------------------------------
End of OAUGNet ListServ Digest #224
***********************************
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic