Organizations - Define
Date: 4 Sep 99 09:18:17 MDT
From: Ora-Tech Systems ora-tech@usa.net
To: OraApps Mailing List oraapps-l@cpa.qc.ca
Subject: [INV] Defining organizations
Hi,
Q1) Is there any way to define different "Material GL Account" within
one Inventory Organization? Is it possible to defined it at
Sub-Inventory or based on an Item Template?
Q2) Also, is there any way to restrict the users to only do
transactions for a defined range of codes or categories.
Creating Organiztion based on categories might solve both the problems,
but that would require creating so may Organiztions, which is practically
not possible.
Any help will be appreciated. TIA.
Ahmed.
Date: Sat, 04 Sep 1999 23:22:58 EDT
From: "Raj P" raj_orapps@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: [INV] Defining organizations
if u work on standard costing basis, U can define material account at
subinventory level...u cannot have different material gl account at template
level as this account is not defined at item level..
2.. in fact we wanted to do restrict the material transactions by
planners... but the problem is
once transaction form is accessible to the user, the user can do transaction
for all active items that are assigned to that specific org.
Raj panchat
Date: Sun, 5 Sep 1999 17:08:16 -0700 (PDT)
From: Ravi Krishnamurthy ravi_krishna@rocketmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: [INV] Defining organizations
Ahmed,
You may define security rules wherein you can restrict segment values
by responsibility. Refer to Applications Flexfields Guide to set it up.
HTH.
Ravi Krishnamurthy
Senior Consultant
Oracle Applications
Routing sans completion subinventory - Report
Date: Mon, 6 Sep 1999 09:39:27 -0000
From: "Janik Thorez" jthorez@paramconsult.com
To: oraapps-l@cpa.qc.ca
Subject: Check if routing completion subinventory exists
Hello,
Does somebody know if there is a standard report where it is possible to get
a report with all items that have a routing without completion subinventory
(locator) ? I already looked in the Audit information report, but no
information exists.
Thanks,
Janik Thorez
Mixed queries on Inv. Tables
Date: Tue, 07 Sep 1999 17:04:46 +0300
From: aragab a_ragab@tccbce.com
To: oraapps-l@cpa.qc.ca
Subject: [Fwd: question_to_inv_expert]
HI
from your answers i know that you inv expert
my question
q1 - is mtl_matrial_transaction and mtl_transaction_accounts are the
main tables in the
inv module, i mean if i update any transaction there will affecte all
the module views
q2- if yes how i can select ans sales order no from the
mtl_material_transactions
and how i can update them, what is the uniqe key.
q3- if i have an sales order in period no8 and we made inventory
interface to that sales order it mean the transaction made in period 8
can i update the date of transaction and the period , how to update and
how to select to be confirm that the update is right.
Best Regards/A.ragab
Patchset C - FRM - 41832 error
Date: Tue, 7 Sep 1999 08:28:48 -0500
From: "Carver, Elizabeth" ecarver@MarkAndy.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: INV patchset C
Hello
After applying INV C and OE G we are receiving an error when we open the WIP
Material Transaction form.
FRM - 41832 Error:Program Unit MODAL_SERIAL in library invslent.pll is
uncompiled. We have tried compiling and generating this library (as per
Support) with no success. Support then had us apply WIP PatchSet A. We have
applied this patch but we are still receiving this error. Has anyone else
had this problem? If so any suggestions on how to fix?
Thanks
Beth Carver
Date: Tue, 07 Sep 1999 10:33:23 EDT
From: "Raj P" raj_orapps@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: INV patchset C
We had some problem in wip import programs after attaching those patchsets
and we replaced with old wip import files and it worked.
u may try any of the following.
alternative -1
As wip - A is the pre-requisite for inv-c, u have to attach inv-c again
after u attached wip-A patchset.
and oe-g needs to be attached again as inv-c is the pre-requisite to oe-g..
Server side patches needs sequential load of patch sets.
alternative-2
if u have not recd any error before attaching these patchsets., u can try
copying the old .pll files.
ensure, u take backup of new .pll files before u do so...
Rajagopalan Panchatsharam
Manufacturing consultant
Organization - creation - FRM-40735 and ORA-06512 errors
Date: 7 Sep 99 14:21:34 MDT
From: Ora-Tech Systems ora-tech@usa.net
To: OraApps Mailing List oraapps-l@cpa.qc.ca
Subject: [INV] Organization Error
Hi,
We are running Oracle Apps Rel 11.o.3 on Digital Unix and facing the following
problem in creating Inventory Organization. Any help regarding this problem
would be appreciated. TIA.
Problem Description :
------------------------------------------------------------------
We created an Organization named "CSC".
We assigned "Inventory Organization" to this Organization in the
Organization Classification region and then selected;
[Others]
Additional Organization Information
Inventory Information
We specified all the parameters in the related Alternate regions and
tried to save the record and but it gives the following error.
------------------------------------------------------------------
Error Text :
FRM-40735:PRE-INSERT trigger raised unhandeled exception ORA-06512
----------------------------------------------
ORA-06512: at "APPS.FND_FLEX_KEY_API", line 2548
ORA-06512: at "APPS.PJM_INSTALL", line 198
ORA-06512: at "APPS.PJM_INSTALL", line 70
ORA-06512: at line 1
Regards,
Ahmed Bham
ahmed_bham@hotmail.com
Date: Tue, 07 Sep 1999 22:56:01 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Reply: [INV] Organization Error
Hi
Have you verified the Locator Flexfield. It may reference segments related
to Project and Task. If so, you need to speak with support to provide you
with the patch.
Hope this helped
Ananth
Senior Applications Consultant
Date: Tue, 07 Sep 1999 22:42:39 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Re: [INV] Organization Error
Hi!
This error arises from the locator flexfield. The locator flexfield has by
default allotted 19 & 20 to PJM which while compiling gives this error.
There is a patch 851461 to sort this problem.
Ravi
Attatchment to Master level viewable at Org level
Date: Tue, 7 Sep 1999 14:40:53 -07:0
From: "Craig Christensen" craig-c@campbellsci.com
To: oraapps-l@cpa.qc.ca
Subject: Attached Documents in Version 11
Hello,
Is there away to attach an Oracle "long" or "short" text document
to an item at the Item Master level and have these viewable at the
Organization level?
Thanks for your help.
Craig Christensen
craig-c@campbellsci.com
Campbell Scientific Inc.
Subinventory Vs Locator
Date: Tue, 07 Sep 1999 17:03:33 -0400
From: Sher-Wood / InGlasCo sherwood@qc.aira.com
To: oraapps-l@cpa.qc.ca
Subject: RUSH: Subinventory vs locator
Hi,
We're working on Oracle Inventory 11.0.2 on NT 4.0 and have a problem
regarding that subinventory is attached to a locator and we are not
allowed to change it (Menu Path : INV : Set up Organization Stock
Locators).
We define a locator and we must attached a subinventory to it. If in
the futur we need to change the subinventory attached to that locator :
we can not, the field « subinventory » is protected against update.
It means that once a bin is allocated for a subinventory (Ex Finished
good) we are not allowed to place something else instead (ex Raw
material).
The logic would be that we empty that locator of it’s content, then
change the subinventory attached to that locator.Instead : how it works
we must inactivate the locator, but can’t recreate the locator with the
new subinventory; it say that it is already existing!!!
Is anyone have that problem, and is there any solution to it!
Christain Labrecque
Groupe Drolet
Date: Tue, 7 Sep 1999 14:48:14 -0700 (PDT)
From: Jay Patel-ERP Consultant jpmrp@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: RUSH: Subinventory vs locator
Christain,
The only way we have managed to do what you are proposing, is to go
into the MTL_ITEM_LOCATIONS table, find the inventory_location_id,
and change the segment data (depending on how many segments are in
your locator, you may get away with puting an OLD or ERROR in one of
the segments) to something else for the existing bin, this will then
let you recreate that bin in any other subinventory.
Hope this helps...
Jay
Date: Tue, 07 Sep 1999 22:49:52 GMT
From: "Ananth Swaminath" ananth999@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Reply: RUSH: Subinventory vs locator
Hi Christain
First - a few basics. You assign Locators to Subinventories. Not the other
way around. Simply because, a locator is nothing but a particular location
in the warehouse. And since any warehouse is segregated into logical areas,
you need to define subinventories to map this physical environment.
Before I address your question: I have made one assumption - that the "bin"
you have referred to in not one segment of your locator flexfield, but the
locator itself. If this is true, then the following reply is in order. Else,
you have a problem on hand. And it needs to be looked at in greater detail -
more on the lines of what Jay has suggested.
Now your question. From what you have mentioned, it seems that you need to
have the flexibility of storing items belonging to different subinventories
into one locator. In other words, you need to say store a Raw Material item
and a Finished Good item in the same locator (maybe not at the same time).
There are not too many business cases that warannt this need. But this does
not prclude the fact that it is possible that a few business processes may
actually need to have this flexibility in the system.
Locators as a measure of Inventory control function as a rule unto
themselves - in that they follow a logic that is the entire reverse of all
general inventory rules. What does this mean? Locator Control is first
governed at the Organisation level. So if one were to decide that, at this
level (when you define Inv. Orgs), there will be no locator control, then
there will be none throughout the organisation. Logically, it does seem more
rational to delegate this control to the next level - that is the
subinventory level. You can decide here, for each subinventory, whether you
need to exercise locator control or not. You also have the option to let the
level of control flow further down - to the item level.
Let's say you have set the level of locator control to the item level. (You
seem to have done this). At this level, you can now decide whether you want
to have this item stored in a particualar subinventory only and further to a
particualar locator within that. In case you have done this, then you cannot
store that item anywhere else. If you need the flexibility of storing the
item in different subinventories, then DO NOT restrict the item to a locator
in a particualar subinventory or to a particular locator in a particular
subinventory. Allow yourself that flexibility.
I would suggest you check the Inventory Attributes for the item in question
and verify if the locator control option is set to "Restrict Subinventory"
and/or "Prespecified Locator". If so, you may want to change this to achieve
the result you desire. Also ensure that you have assigned the item to the
various subinventories where you need this flexibility.
Hope this helped. In case you need any further clarifications, do get in
touch.
Ananth
Senior Applications Consultant
Date: Tue, 07 Sep 1999 20:32:15 -0400
From: "Steven C. Kondolf" skondolf@frontiernet.net
To: oraapps-l@cpa.qc.ca
Subject: Re: RUSH: Subinventory vs locator
Hi Christian -
In our 10.7 char environment we came across this same limitation. The way
we worked around it is to define a multi-segmented flexfield for the stock
locator. Our's is 5 segments and the first segment is subinventory. Here
we set up a 2-character independent value set that has an abbreviation of
each subinventory. This allows us to create a "unique" locator regardless
of the subinventory.
For example 2 of our subinventories are CHEM_FIN and CHEM_RAW. We have our
1st segment set as CF and CR. We can now define 2 locators i.e.
CR.123.45.678.90 as well as CF.123.45.678.90
Agreed that it requires a locator be defined for EACH subinventory but it
also allows you the flexibility. You could probably come up with a
creative way to "automagically"populate this segment based on the item
number using a descriptive flexfield or something.
Hope this helps you.
Date: Wed, 8 Sep 1999 9:26:21 +0100
From: alexandre.gravelin@degremont.com
To: sherwood@qc.aira.com
Cc: oraapps-l@cpa.qc.ca
Subject: =?ISO-8859-1?Q?R=E9f._:_RUSH:_Subinventory_vs_locator?=
A big problem in INV is that you have to attached a subinventory to a locator
when you define it
This has several consequences :
you can not change the locator of subinventory
you can not re-use this locator for an other subinventory (for exemple if you
define a locator code like row/rack/bin, you may want to use the locator 1/5/3
in several subinventories)
A solution to solve this problem that I generaly use, is to define a locator
flex-field including the subinventory=2E In this case my locator flex-field will
be for exemple with 4 segments like subinventory/row/rack/bin, with a value set
table based for the first segment)
Hope this help
Alexandre GRAVELIN
Manufacturing consultant
France
Reconcile inventory for multiple Cost Centers
Date: Tue, 14 Sep 1999 12:19:37 -0700
From: "Catherine Gauchat" catherine_gauchat@tcibr.com
To: apps oraapps-l@cpa.qc.ca
Subject: Reconciling Inventory
Hi,
We are running 11.0.2 version of the applications and are having problem
reconciling inventory. We can't find a report that will work if we have
more than one cost center. Is anyone else using more than one cost
center? What do you use to reconcile inventory?
Thanks,
Catherine
UOM with International implications
Date: Tue, 5 Oct 1999 09:11:40 -0400
From: "Steven C. Kondolf" skondolf@frontiernet.net
To: "Oracle Listserver" oraapps-l@cpa.qc.ca
Subject: INV: UOM with Int'l Implications
Soon we will be looking at bringing up a Canadian subsidiary on
Inventory 10.7char. Currently our uom's are
set at the item level so each org has the same default uom. However many
of our items are uom
gallons and lbs. When we go to our Canadian subsidiary, they will need
to be liter and kg. They order
these items from us. How do other companies handle this?
Separate sku numbers?
Multi-segment flexfield on system items to make the number "unique"?
Set the default uom attribute to item/org so each org can have a
different uom?
Use of uom conversions?
Any suggestions and information given appreciated.
Peace...
Steve
Inventory Table links to SO and PO
Date: Thu, 07 Oct 1999 23:53:59 +0800
From: Eric lee cellolee@ctimail.com
To: oraapps-l@cpa.qc.ca
Subject: Inventory table relationship to SO AND PO
Dear all ,
Could I get help on the following question ?
How could I link MTL_MATERIAL_TRANSACTIONS and
MTL_TRANSACTION_ACCOUNTS
to sales order and purchase order ? Cause I'm creating a report
which requires
relationship between Sales Quantities, Purchased Quantities to
Inventory's Quantities.
Thanks in advance.
Eric Lee.
Part Number - change
From: Russell, Pat (IS) [SMTP:PRussell@sigeco.com]
Sent: Tuesday, October 26, 1999 10:19 AM
To: Multiple recipients of list
Subject: Changing part numbers in inventory
Hi -
We went live with Oracle Financials in September of 1998 with these
modules(PA,GL,PO,AP,INV,OE). During conversion we set our part numbers
(MTL_SYSTEM_ITEMS.SEGMENT1) as random numbers from 100001 to 599999. We
are
in the process of changing those numbers to an intelligent number. My
question is what kind of ramifications are we looking at? What happens to
Requisitions, open Purchase Orders, booked Orders and so on by us making
this change? Has anybody been through this process? If so, what kind of
effort and problems arose during this process? Any feedback would greatly
be appreciated. Thanks in advance.
Pat Russell
System Analysis
Date: Tue, 26 Oct 1999 16:25:07 -0400
From: "Maran, Ramanathan (Ramanathan)** CTR **" rammayan@lucent.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Changing part numbers in inventory
Hi Russell,
Since part number stored only in mtl_system_items table and all others
reference them by inventory _ item_id. Just updating segment1 in
mtl_system_items table would do. This will not mess up anything unless any
triggers associated with mtl_system_items table. But this segment1 needs to
be updated across all the orgs where this item is enabled including Master
org.
Best of Luck
Maran
Date: Wed, 27 Oct 1999 20:31:04 MYT-8
From: philip@aleytys.pc.my
To: oraapps-l@cpa.qc.ca
Subject: RE: Changing part numbers in inventory
Remember to make sure that the flexfield-segment-values are also
updated.
Philip
Date: Wed, 27 Oct 1999 22:52:52 -0700
From: "TomHery" TomHery@home.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Changing part numbers in inventory
Have you given consideration to NOT using an intelligent part number system?
It is difficult to design one that run into problems the day after you
design it.
Such things as:
* Added new product families and the intelligence can no longer be
maintained.
* Buying another company that has part numbers that conflict with yours.
* Having to change the intelligent "format", impacting all of your marketing
literature
* Having to pre-assign significant part number ranges for later use.
Just a few thoughts from someone that's been there.
Date: Thu, 28 Oct 1999 09:16:39 -0400
From: Steve Harper steve.harper@pragmatek.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Changing part numbers in inventory
I would echo Tom's thoughts. I have yet to see an intelligent numbering
scheme that doesn't break down pretty rapidly and create even more
confusion. It is also rather difficult to enforce since it requires
ongoing training and monitoring of whoever is responsible for maintaining
it.
Steve Harper
PRAGMATEK Consulting Group, Ltd.
Steve.Harper@pragmatek.com