Routing Operation Descriptions
Date: Thu, 12 Aug 1999 7:16:47 -0400
From: steve.johnson@ametek.com
Subject: Routing Operation Descriptions
Hello,
Many of the Operation Masters in our legacy system contain long, very
detailed routing operation instructions We are implementing Oracle Rel 11
and we understand that we are limited to 240 characters in our operation
description This is a major data conversion issue for us Does Oracle
have a place to put these long descriptions? If not, what did you do with your
legacy data prior to conversion?
Thanks for any help
Steve Johnson
AMETEK Rotron
Woodstock, NY
(914) 679-1558
Date: Thu, 12 Aug 1999 13:32:01 +0200
From: Gorre Richard GorreR@fnherstal.com
Subject: RE: Routing Operation Descriptions
Did you think about operation attachments with long text ?
richard
Date: Thu, 12 Aug 1999 15:14:53 -0400
From: steve.johnson@ametek.com
Subject: RE: Routing Operation Descriptions
Richard,
If by "operation attachments" you mean attaching documents that reside
outside Oracle (Excel, Word, Access,etc) yes we have considered that
option
But creating and maintaining all those external, uncontrolled documents
is not an acceptable option We really want a solution that utilizes
Oracle functionality I have been told that the 240 character limitation is for
the "operation description", and that there is a place to put operation
"instructions" that is unlimited in size Am I hearing this correctly?
It sounds like a possible solution
Thanks
Steve
Date: Sun, 15 Aug 1999 00:37:40 PDT
From: "shawish sababa" shawish_sababa@hotmail.com
Subject: RE: Routing Operation Descriptions
Hi Steve
Check the BOM Designator and see If it is what you are looking for.
Shawish
Date: Tue, 17 Aug 1999 17:28:32 +0200
From: Gorre Richard GorreR@fnherstal.com
Subject: RE: Routing Operation Descriptions
Steve
I wans thinking about standard oracle attachments; using clip paper icon.
You could link any kind of text or other document including images.
I never use that for routing operation, but it work find.
My first research on this topics show that Oracle did not provide a use of
these text using standard oracle report.
By comparaison, in Item attachment can be printed automatically on the PO.
I hope it could help you
Richard
Date: Fri, 20 Aug 1999 17:44:31 EDT
From: "Raj P" raj_orapps@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Routing Operation Descriptions
U CAN TRY CAPTURING LONG DISCRIPTIONS IN DESC FF IN OPERATION SEQUENCE OF
ROUTING.
tHIS DFF WILL REFLECT IN WIP OPERATIONS SCREEN.
Description of new Production Item
Date: Thu, 2 Sep 1999 07:21:11 -0500
From: "Schaefer, Mike" MSchaefer@sandc.com
To: "Listserve Oracle (E-mail)" oraapps-l@cpa.qc.ca
Subject: 10.7 SC Procurement
When we have a new production item we load this into our legacy system and
the information migrates over to Procurement etc and that all works just
fine. However now we need to revise the item description. Does anyone know
if there is a way to automatically get this change of the description to
also come across the bridge? It is currently a manual function and it can be
a time consuming pain. Thanks.
Inventory/Purchasing Report
Date: Fri, 10 Sep 1999 16:18:25 -0700 (PDT)
From: DIPANKAR BASU dipankar_99@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Inventory/Purchasing Report problem
Re : Purchasing / Inventory Receiving Value Report By Destination
Account
Has anyone used this report? If so, can anyone please tell me what is
the objective of this report and what is the period tenure of this
report?
When we run this report, we get "No Data Found" even after giving very
open ended parameters.
TIA
Dipankar
Date: Mon, 13 Sep 1999 06:25:22 -0700
From: CFowler@littonapd.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Inventory/Purchasing Report problem
I have not used this report, but here is the description from the online
help:
The Receiving Value Report by Destination Account lists received
items by purchase order destination and distribution account. If you
accrue both inventory and expense at the time of receipt, you may have
both inventory and expense as part of your receiving valuation account.
The Receiving Value Report by Destination Account allocates your
receiving balances by the purchase order line inventory, expense
accounts, and quantities. You can then use this report to manually reclass
the receiving valuation account to the appropriate expense accounts.
HTH
Candace
Date: Mon, 13 Sep 1999 15:36:02 +0200
From: Gorre Richard GorreR@fnherstal.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Inventory/Purchasing Report problem
Hi
The notion of receiving is also what is in the receiving process.
Whe you are using the 2 step rceiving process, you have a fisrt stage where
the goods are in control and not yet in the inventory.
This report show you the values related to these products.
Richard Gorr
Tel 32 4 240 88 37
Date: Mon, 13 Sep 1999 20:54:05 +0700
From: "Nagamohan U." umohan@irs.co.id
To: oraapps-l@cpa.qc.ca
Subject: RE: Inventory/Purchasing Report problem
Hi
This report gives information about the POs for which the receipt
transactions are made but not yet delivered. Once you perform the delivery
transaction this report shows no records. In essence this report gives as on
date how much is yet to be delivered.
It can also be used to check the charge accounts to which you are going to
deliver the material. If the charge accounts are wrong, you can go and
rectify the charge accounts, re-approve them and deliver the goods.
Regards/Nagamohan
UOM - different for sale and stock
Date: Sun, 03 Oct 1999 09:04:26 -0400
From: "Steven C. Kondolf" skondolf@frontiernet.net
To: oraapps-l@cpa.qc.ca
Subject: INV and OE: Sell vs. Stock UOM
Hello all -
We have been on Oracle Apps since 1996 and are currently on 10.7Char with
plans to upgrade to 11 next year. We are also debating installing OE.
Currently we have an in-house written OE package that interfaces with apps
thru INV.
Our company sells many products by the gallon and each. Currently we stock
these products by the case and that's the uom in INV. We're pretty sure
our Marketing and Sales groups won't want to change their sell uom to case
and our planning and inv groups really don't want to work at the gallon or
each level. Does Oracle handle this type of situation so that we can sell
at one uom and stock, plan and process at a different one. Do uom
conversions come into play with OE? How do other companies handle this or
is it pretty uncommon?
I'd appreciate any comments and suggestions regarding this.
Peace
Steve
Date: Fri, 15 Oct 1999 01:28:21 -0400
From: Steve Harper steve.harper@pragmatek.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: INV and OE: Sell vs. Stock UOM
Steve,
Yes, UOM conversions are used in OE. You can set up whatever types of
conversions you need to deal with Purchased UOM, Selling UOM, Stocking UOM,
etc.
Steve Harper
PRAGMATEK Consulting Group, Ltd.
Purge Items / BOMs / Routings
Date: Wed, 20 Oct 1999 08:11:59 -0500
From: GEN OUSER genouser@mcquay.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Purge process - Items / BOMs / Routings
We are a new user and have never purged items . BOMS or Routings. We add
20,000 new ones per week that are only good for 30 -60 days. We need to
purge but are afraid that there is not good documentation from ORACLE.
thanks
Date: Wed, 20 Oct 1999 15:57:46 +0200
From: Clive Calder CliveC@langeberg.co.za
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Purge process - Items / BOMs / Routings
Hi
The purging of transaction history and associated accounting information can
be done where the transaction date is before and including the purge date
you enter and is in a closed period.
You should be extremely cautious when purging transaction information. Once
you commit the process, Oracle Inventory removes all related information
from the database. You cannot view or report on this information once you
purge it. For example, you can no longer report purged information with the
Accrual Reconciliation Report, the Transaction Register, and so on.
You may find the Delete Groups process is more appropriate to your
requirements, where you delete items, BOM's and Routings that will not be
used again, while the transaction history remains intact. In using this you
will probably need to modify the Oracle seeded Delete constraints to allow
deletion.
Regards
Clive Calder
Intercompany Billing / Dropship supplier
From: Basanta Kumar Dash [SMTP:dashbk@hotmail.com]
Sent: Wednesday, October 27, 1999 10:35 AM
To: Multiple recipients of list
Subject: Intercompany Billing
Hi All,
Here we have a scenario on intercompany billing. The scenario is as
follows:
1. We have two different operating units and set of books
2. Operating unit 1 creates the sales order (selling org) and Operaring
unit
2 ships the goods to customer (shipping org)
3. Operating unit 1 sends invoices to the customer and operating unit 2
sends invoices to operating unit 1 with a selling price that is different
from operating unit 1 selling price to the end customer.
If anybody has implemented this scenario please share with me with the
operational steps and accouting transactions in both the operating units.
Both the operating units are profit making organizations.
Regards,
Basanta.
Date: Wed, 27 Oct 1999 14:05:07 -0400
From: Steve Harper steve.harper@pragmatek.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Intercompany Billing
Basanta,
What release of Oracle Apps are you using? This sounds like a classic
dropship supplier situation. Oracle V11 is set up to handle dropship
poorly but somewhat automatically.
Basically, with dropship suppliers in V11 what happens is that:
1) You enter a new order
2) This order generates a Purchase Requisition
3) You convert the Requisition into a Purchase Order and send it to the
supplier
4) You invoice your customer through Receivables
5) The supplier invoices you and you pay them through Payables
Steve Harper
Date: Thu, 28 Oct 1999 02:01:26 -0700
From: "Sadhwani, Suneel" SSadhwani@ea.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Intercompany Billing
Intercompany transactions needs set ups to be done . some of which are
define intercompany relationship between shipping and selling org
also define ar invoce info ( customer , transaction type , sites etc )
define ap invoice info ( vendor , site ect ) . in Inv .
Create Intercompnay AP invoices and Create intercompany AR invoices
automaticaly creates AP and AR invoices for you .
Hope this helps
Suneel