Miscellaneous Transactions
Date: Fri, 11 Jun 1999 22:10:54 PDT
From: Basanta Kumar Dash dashbk@hotmail.com
Subject: INV: Miscellaneous Transactions
Hi All,
I found a strange thing in Oracle Apps Rel 10.7SC while performing
miscellaneous transaction for adjustment. I am not sure whether anybody in
this forum had the same problem. If so, please share with me the solutio.
The problem;
I did a miscellaneous transaction to adjust the qty and price of an item. We
are using average costing. The distribution was created as follows:
CR Inventory - Material A/C $1234.84
CR A/P Clearing A/c $0.01
DR A/P Trade Debtor $1234.85
I don't know why 0.01 has gone to clearing A/C. Any clue?
Thank you in advance.
Regards,
BAsanta.
Changing Subinventory accounts
DASARI SUBRAHMANYAM srdasari@hotmail.com Wednesday, June 09, 1999
2:40:41 PM
I am posting my problem again to capture the participants'attention.
I would appreciate some one's classification on the matter.
Hi
My client has requirement to change the different accounts' codes
(material, material overhead, overhead, resource, and outside
processing) for all their subinventories. Right now system does not allow them
to change because they carry inventory quantities. They do not want to
manually transfer all the quantities and empty out the subinventories
because they have thousands of items.
I have two suggestions as follows:
1st:
Write a sql procedure which would transfer all the items in the
subinventories to a new subinventory defined for this purpose and transfer
different subinventory accounts and run it again to bring back all the items into the20
subinventories.
In this case I have to take care of all item controls like serial number,
books.
2nd:
Define the new code combinations that are required to be linked to
subinventories in GL. Update mtl_secondary_inventories table with the
new a items
Has any one come across this kind of situation. If some one has any
other short
bye
dasari
Dasari,
TRY THIS AT YOUR OWN RISK. I WOULD MAKE SURE THIS WORKS IN TEST BEFORE
ATTEMPTING IT IN PROD.
1. Before you start, freeze transactions and run an All Inventories Value
Report for a Subinventory.
2. Using Access97 get the pertinent records that would typically
populate
a Physical Inventory for that Subinventory. They must be in the exact
same order as you would enter them into a Physical Count.
3. Select those records and paste them into an Excel spreadsheet.
Arrange them in a cut&paste format so that the rows will populate
correctly in a Physical count. You may need to get some help with that.
I would name a 'dummy' Physical and try to enter some rows until it
works.
4. Define a new Physical in TEST with the Subinventory that needs to be
zeroed out. Set the Approval Option to "Not Required for Adjustments"and
make sure you set the Allow Dynamic Tag Entry to "Yes".
5. Then Perform Physical Adjustments to zero out the balances.
6. The Subinventory should be zeroed out. If it is, correct the
accounts.
7. Define another Physical name for that same Subinventory. Set the
Approval Option to "Not Required for Adjustments" and make sure you set
the Allow Dynamic Tag Entry to "Yes".
8. Enter the Inventory counts using the cut&paste spreadsheet you
developed earlier.
9. Run another All Inventories Value Report and compare to the beginning
report you ran in step 1 above. They should match.
10. If steps 1 through 9 above worked in TEST, do the same in PROD. You
can do multiple Subinventories providing they will have the same
adjustment
account.
//David
From: Anand.Tondapu@gemplus.com
Subject: Re[2]: Changing Subinventory accounts
Date: Friday, June 11, 1999 2:46 PM
This may be a dumb question..What happens if you update all
subinventory accounts directly through sql program. We have a
requirement to update subinventory accounts.
Do I end up with any serious problem or mess if I update directly
through sql? Can some one please explain me about this
Anand
Date: Thu, 17 Jun 1999 13:40:44 -0500
From: "Louise Kewish" kewishls@mindspring.com
Subject: Re: Re[2]: Changing Subinventory accounts
We've had to do this a few times using sql. there wasn't any problem but we
had to ensure taht we had cleared all the material interfaces before we did
this.
Lousie Kewish
Senior Principal - Manufacturing/Distribution Apps
TSC
Dallas, TX
Date: Thu, 17 Jun 1999 13:46:05 -0500
From: "Schaefer, Mike" MSchaefer@sandc.com
Subject: RE: Re[2]: Changing Subinventory accounts
Louise...what do you mean by "cleared all the material interfaces"?
Date: Thu, 17 Jun 1999 13:59:49 -0500
From: "Louise Kewish" kewishls@mindspring.com
Subject: Re: Re[2]: Changing Subinventory accounts
Make sure that there are no pending transactions in
mtl_transactions_interface, mtl_material_transactions_temp,
rcv_transactions_interface and I think the wip interfaces, if you are using
wip. The reason I say to clear these out is that they all have
distributions on them (i.e. gl account codes) based on the subinventory
accounts from which they have come from /going to and if you change the
accounts the tansactions will be wrong.
Louise
Date: Fri, 18 Jun 1999 05:45:34 -0700 (PDT)
From: Ravi Krishnamurthy ravi_krishna@rocketmail.com
Subject: RE: Re[2]: Changing Subinventory accounts
Wouldn't using account generator or flex-builder (if you are on rel
10.7) help? Define it in such a way, that it picks up the new account
for the items in inventory. This would be least messy. I really
wouldn't recommend sql updates unless all other options have been
exhausted.
Ravi K.
APP-14531 error in Receipt transactions
Date: Sun, 14 Jun 1998 15:01:59 -0400
From: "Dave MacQueen" dmacqueen@msn.com
Subject: APP-14531
Hi, I have receipt transactions erroring out in Inventory with the message
"APP-14531 &FILE-&ERR_NUMBER: Subroutine &SUBROUTINE returned error"
Does anyone have any information on this error?
Thank you,
Dave
Date: Mon, 14 Jun 1999 18:01:57 -0400
From: "Terri Williamson" TerriWilliamson@kemet.com
Subject: Re: APP-14531 Error in receiving transactions
Dave,
We have had this error come up a couple of times. This can happen if you are
trying to receive an item that does not have a cost defined. If you try to
receive the item in character mode it will give you a more descriptive error
message that should point you in the right direction.
-Terri Williamson
KEMET Electronics
(864) 963-6428
Date: Mon, 15 Jun 1998 08:38:15 -0400
From: "Dave MacQueen" dmacqueen@msn.com
Subject: RE: APP-14531 Error in receiving transactions
Thank Terri,
what is happening is that only the inventory items are being held up. They
do have costs associated and the managers are all running fine. What is
confusing is that the production db was copied to our development db 2 weeks
prior and there are no problems with the development db.
Thanks for your reply.
Dave
617-988-5882
How to keep track of distributors
Date: Thu, 17 Jun 1999 10:16:43 -0700 (PDT)
From: Cheryl Chomniak cheryl_chomniak@yahoo.com
Subject: INV: How can I track a distributor
I am a new analyst working for a large restaurant corporation. We use
Oracle Financials Order Entry, Inventory, and Purchasing applications.
I need some advice on how to set up inventory items, with pricing, that
can be tracked for our produce distributor.
Currently purchasing negotiates prices for commodity items with our
suppliers. Those prices
and quantities are communicated to our distributor. The distributor
then uses that pricing information to invoice our operators when
produce is delivered. We get weekly invoice (item level) feeds that
are used to generate journal entries.
We want to capture all of this and report on it in Oracle. Can someone
give me some advice on how to set up a separate inventory organization
to track "virtual" items. Please Help!!!!!
Data Conversion/Subinv/Stocking Locators
Date: Thu, 17 Jun 1999 15:47:09 -07:0
From: "Craig Christensen" craig-c@campbellsci.com
Subject: Data Conversion/Subinv/Stocking Locators
Hello,
Oracle 11.02 Implementation
We are having a difficult time in our data conversion with
subinventories and stocking locations for our items. We attempted
to do it using the MTL_Transaction Interface when we put the on-
hand quantities into the database. No errors were given at the
conclusion of the process but the subinventory/stocking location
data is not linked to any items.
Any help is appreciated.
Thanks,
Craig Christensen
Campbell Scientific Inc.
craig-c@campbellsci.com
(435)750-9618
Date: Thu, 17 Jun 1999 19:30:56 -0400
From: "Dave MacQueen" dmacqueen@msn.com
Subject: RE: Data Conversion/Subinv/Stocking Locators
Did the on hand balance come through with no locations? Or did the entire
transaction hold up.
Dave
Inventory Valuation without costing
Date: Sat, 19 Jun 1999 09:06:29 -0700
From: "Saranath P" saran_p@mailcity.com
Subject: Inventory Valuation without costing
Hi all,
We are on Rel 10.7 V16.1 on HPUX. We have a peculier problem in accounting
and valuation of Inventory transactions
1. Inter-Org transfers.
We are not using the costing function and all our inventory items have been
defined with costing enabled set to 'NO'. However the Inter-Org transfers
are being valued at a fixed rate of 2.0817 per unit and creates Interorg
payable and receivable entries. This is happening if we have the FOB point
as Receipt. If set to Shipment these transactions are not valued. No
transfer charges are loaded and no where we have defined any kind of cost.
We have lodged a TAR with Oracle but no response as yet.
2. Cost Managers erroring out.
For all my transactions with destination type as Inventory, the costing
manager concurrent request is returning error. It provides a message of
'Unable to insert acct combinations fetching too many rows'.
Can some one help me ASAP. We are on the Production instance.
TIA
---
Prabu B
INV: Item Open Interface
Date: Mon, 21 Jun 1999 11:34:07 +0530
From: manoj_bhatnagar/Polaris@polaris.co.in
Subject: INV: Inventory Item Open Interface Problem
Hi Everybody,
We are working on Oracle Applications 10.7 SC.
We are working on Inventory Open Interface.
1. We inserted the data in Interface table "MTL_SYSTEM_ITEMS_INTERFACE"
from the Legacy system.
2. While running the Import Items from the Inventory we are getting the
error and the following values in the columns of "MTL_INTERFACE_ERRORS" :-
COLUMN ----------- VALUE
MESSAGE_NAME------ BOM_PARSE_ITEM_ERROR
ERROR_MESSAGE-----INVPAGI2: Invalid Item ID
COLUMN_NAME-------inventory_item_id
ORGANIZATION_ID--- -1
If anybody has encountered this error. Please revert back to us.
Thanks in Advance.
Manoj Bhatnagar
Associate Consultant-Oracle Applications.
Date: Mon, 21 Jun 1999 08:10:07 -0600
From: debra_turri@atg.pacsci.com
Subject: Re: INV: Inventory Item Open Interface Problem
I recently converted legacy data on 10.7 also, and although I do not remember
seeing your particular error message, I did have a couple of errors that were
corrected with a patch. We needed to upgrade the INCOIN module to 50.14, I
believe the original version is 50.10.
From your error message, I would guess that the items you are inserting may not
be in the master org. The master org must contain ALL your items prior to
inserted into the child org.
Deb Turri
Pacific Scientific
e-mail: debra_turri@atg.pacsci.com
Date: Mon, 21 Jun 1999 16:59:28 +300500
From: BPL-UPTRON_Team@india.notes.pwa.co.in
Subject: Re: INV: Inventory Item Open Interface Problem
Hi Manoj,
While there can be various reasons for this problem. First I need to know
the format of your flat file of items used for uploading. If u are using
column number based fields then probably one of the segments of your item
segments is not in the proper column or there might be some embedded
control characters in your flat file.
Another reason could be that the values for segments of item are not
defined in the value sets.
Hope the above information helps you. Feel free to contact me if u have any
other queries.
Harpreet
Migrating Item Costs from 9.4 to 10.7
Date: Wed, 23 Jun 1999 21:35:14 MYT-8
From: philip@aleytys.pc.my
Subject: INV: Migrating Item Costs from 9.4 to 10.7
Dear List readers,
Moving the item master from 9.4 to 10.7 SC via the open item interface.
However the CURRENT_WEIGHTED_AVERAGE_COST column in the 9.4
MTL_SYSTEM_ITEMS seems to have dissappeared (We are using Average
Costing). The database changes manual just says that this column has
been dropped.
I think I have tracked the information down to several CST tables -
probably CST_ITEM_COSTS and CST_ITEM_COST_DETAILS. However I'm not sure
how the columns in theses tables are populated. The TRM isn't terribly
helpful. Anybody willing to lend me a clue or two? Ta!
Philip
Restricted user responsibility
Date: Wed, 23 Jun 1999 15:48:35 -0400
From: "Schmidt, Bob" bschmidt@AAFINTL.com
Subject: INV: user responsibility
Hello all -
Do I remember correctly that there is a way to limit user access to
specific sub-inventories? Like for inquiry, update, transactional, etc?
Thanks
Bob Schmidt
bschmidt@aafintl.com
EDS
502.637.0446
502.637.0520 (F)
Date: Wed, 23 Jun 1999 15:49:39 -0400
From: "Downey, Dawn E" dedowney@kpmg.com
Subject: RE: user responsibility
Not to a specific subinventory that I'm aware of...only organizations....
Dawn Elise Downey
Consultant - Oracle
KPMG LLP
Boston, MA
Office: 617-988-5629
Client Site: 516-803-9581
Date: Thu, 24 Jun 1999 08:56:44 -0400
From: "Devulapally, Sridhar, CFCTR" sdevul0458@att.com
Cc: bschmidt@AAFINTL.com
Subject: RE: user responsibility
Hi Bob
There are ways to limit user access to specific sub-inventories. If you want
to exclude any functions or menus from a particular responsibility you can
always exclude those under the exclude section under SYTEM ADMINISTRATOR.
If you want to create specific responsibilities which are Inquiry only or
UPDATE/TRANSACTIONAL then you need to make a similar replication of the
existing forms and functions in question and make them QUERY ONLY under
Parameters section when you define your functions, subfunctions.
Then you can assign the user the specific responsibility (Inquiry or Update)
Thanks
Regards
Sridhar Reddy
(407) 858-7610
sdevul0458@att.com mailto:sdevul0458@att.com
Deleting Subinventories
Date: Wed, 23 Jun 1999 17:49:36 -0400
From: cshay@csc.com
Subject: Deleting Subinventories
Has anyone ever deleted inactive subinventories ? If so,were there any
affects on any transactions, reports, or functions ?
We changed from a 3 to 4 digit subinventory code. We inactivated the 3
digit codes (they were used for 1 year), but they still show up on list of
values. It has been confusing for the users, because they try to choose
the 3 digit field.
The only remaining references to the 3 digit subinventories are in the
mtl_demand and mtl_supply tables.
Available vs. On-hand
Date: Fri, 25 Jun 1999 9:01:19 -0500
From: Srikrishna Rupanagunta srikrishna.rupanagunta@ey.com
Subject: Inventory Balances : Available vs. On-hand
How does Oracle Inventory compute Available and on-hand ?
We have a situation where we do not use reservations. None of the items are set to 'Reservable'.
However, we find that the on-hand and available quantities are different on the Miscellaneous transaction screen. What could be the possible reasons ? Some of the sub-inventories have 'Reservations' flag set to Yes. Does that automatically reserve all inventory in that specific sub-inventory ?
Thanks in advance.
Krishna
Date: Fri, 25 Jun 1999 10:09:31 -0400
From: "John Normandeau." JNormandeau@hartco.com
Subject: RE: Inventory Balances : Available vs. On-hand
Greetings Krishna,
Are any of your sub-inventories set to "Non-nettable"? This would
affect the "Available" calculations, thereby skewing your balance. Inventory
in a Non-nettable sub-inventory is not counted for availability
calculations. Hope this helps.
Regards...
John Normandeau
Project Lead
H2O - Manufacturing
354-0580 X: 607
jnormandeau@hartco.com
Date: Fri, 25 Jun 1999 16:10:22 +0200
From: "Andre Kuerten" akuerten@imation.com
Subject: Re: Inventory Balances : Available vs. On-hand
Krishna,
at first when you disable reservations, you get Pick slips also when there is
nothing on stock.
What Oracle wants to tell you, when it shows avaliable, is the quantity that is
ready to sell.
In your on-hand qty is also everything included what may reserved through
orders, but not yet ship confirmed.
Also important to check, how often your transaction manager runs, that updates
the qty.
We are facing the same problem here, it's a bit confusing if you don't know
what's the reason therefore.
Also in my eyes it's a mess that in the On-hand screen the ATP qty is not
shown.
For that the supply-demand screen is much better, but there is no locator.
Hope that helps
Andree
Date: Fri, 25 Jun 1999 10:08:46 -0400
From: Sistla.Viswanath@am.sony.com
Subject: RE: Inventory Balances : Available vs. On-hand
Hi krishna
On-hand quantity refers to physical availability at that point in time,
where as Available is after taking into consideration the reservations, PO
qty available and if you have reservations net of reservations.
Just my flagging a sub inventory as reservable does not automatically
ensure reservation. U need to reserve them. The flag only ensures that you
can reserve items in that sub inventory.
Hope this helps
vishy
Date: Fri, 25 Jun 1999 09:03:18 -0700 (PDT)
From: Rajesh TL priyarajesh@yahoo.com
Subject: RE: Inventory Balances : Available vs. On-hand
Hi
If you need to know the mechanism used by Oracle
to calculate Oh-Hand (as of today, or a target date)
please have a look at INVTRHAN.rdf report under
Oracle Inventory.
The report uses a dynamic view to calculate
On-Hand.
Regards
Rajesh
FIFO / LIFO method of Costing
--- Shanker_V Shanker_V@hts.satyam.com wrote:
Hello all,
One of our clients follows FIFO method of costing.
What workaround can be
suggested in Oracle Inventory to support the same.
Kindly reply at the
earliest.
Thanks & Regards,
Sumita Lal
Date: Fri, 25 Jun 1999 07:49:59 -0700 (PDT)
From: Belkis Karakas belkisk@yahoo.com
Subject: Re: FW: FIFO method of costing
Hi Sumita,
As far as i know there is no method of doing FIFO costing in Oracle
Inventory. In one of the projects i worked before, the requirement was
LIFO costing to be valued once a year. The way we solved that was out
of Oracle.
We assumed that at year end, the value of on-hand qty should correspond
to the prices of those items going forward in time (starting from
beginning of the yr because of LIFO) until the qty on-hand is reached.
In your case you would have to go backward in time starting from
'today' to find the corresponding PO prices for the items on-hand. This
can be done fairly easily with simple queries and some coding out of
oracle according to your FIFO requirment to make the calculations and
you can generate a report out of oracle in this manner. This method may
however become very complex if you need to do this every month and if
you have too many items.
To clarify the situation i tried to explain above, here is an example
for a FIFO case:
Beginning Inventory for item x = 10
Ending inventory for x = 15
we should already know the value of our BI so we only need to find out
the value of the qty defined by the difference b/w BI and EI.
BI - EI = 5
According to the FIFO method, we assume that the qty on hand which is 5
is the 5 purchased most recently. Therefore, go back in time for your
Purchase orders:
PO price for item x ( PO qty 1) on Dec. 30 = 20
PO price for item x ( PO qty 2) on Dec. 28 = 20
PO price for item x ( PO qty 1) on Nov. 25 = 19
PO price for item x ( PO qty 1) on Nov. 10 = 18
the qtys now add up to 5 and we have the Po prices so add them up for
total inv value for item x = 97
When you add to this number the value of your BI, you end up with what
you desire.
I hope this very simplified example helps.
If you find a less complex way of doing this pls let me know.
Belkis Karakas
Material transaction disappears after transfer to GL
Date: Sun, 27 Jun 1999 15:22:57 +0300
From: mohammed alshaarawi m_sharawy@tccbce.com
Subject: Can not find any inventory transaction after GL/Transfer
hi
I have the following problems.
Problem Description:
On 23/Jun/1999 Inventory user reported that after he run transaction
register report and Material Account Distribution summary for the FUL
subinventory for period 5 (start 1 May to 28 MAY) he got no data found.
Problem preliminary Investigation:
1- Period 5 is closed and transferred to G/L
2- No problem in other subinventory.
3- We did not find any transaction before 29/MAY/99 for this
subinventory (FUL).
4- We did not find any Accounts Distributions from view general ledger
transfers.
5- We did not find any Material Distribution account from Inventory
Accounting period.
6- We did not find any transaction before 29/May/99 in the Database view
MTL_MATRIAL_TXNS_VAL_V and the related database tables for that
subinventory.
Problem Conclusion:
Some time all Material transaction disappears after close the inventory
period and transfer it to G/L.
thanx for all help
shaarawi
Inventory Transaction Types
Date: Wed, 30 Jun 1999 11:33:47 -0400
From: "Piazza, Samuel" Samuel.Piazza@viasystems.com
Subject: Inventory Transaction Types
Hi all...
We are running Oracle Inventory Release 10.7.0 SC161 and we have multiple
departments under one organization. We would like to limit the Transaction
Type choices in the Miscellaneous Transaction screen when a particular
department enters transactions. Keep in mind that the transaction types may
not be the same for each department.
Is there a way we can handle this without altering forms or tables?
Thanks for your help in advance.
Date: Wed, 30 Jun 1999 21:06:13 +0300
From: "Dina Rotem (h)" dinar@rafael.co.il
Subject: RE: INV - Inventory Transaction Types
Samuel-
You may define misc. transactions, where in the transaction name you
include the department name, and continue with description of the
transaction itself. For each real transaction type you would have
several user defined transactions, one for each department that should
use it.
In this way, without customization, you ask your users to peek from the
LOV only transactions names starting with their department name.
Dina
Inventory Interface flag
Date: Wed, 30 Jun 1999 18:53:46 +0300
From: mohammed alshaarawi m_sharawy@tccbce.com
Subject: Inventory Interface flag
Hi
I know that when a sales order is procceced with inventory interface a
flag is marked to this sales order to yes how I can change this flag to no
thanx
Date: Wed, 30 Jun 1999 11:10:56 -0500
From: "Michael" BMRBUK@msn.com
Subject: Re: Inventory Interface flag
In SO_LINES you need to change the s8 column to the value 18 instead of 14.
Mike Buchanan
Date: Wed, 30 Jun 1999 20:08:17 +0300
From: mohammed alshaarawi m_sharawy@tccbce.com
Subject: RE: Inventory Interface flag
thanx
We did that. but after applying inventory interface we can not find any
inventory matrerial transactions!!
Date: Wed, 30 Jun 1999 13:13:15 -0500
From: "Michael" BMRBUK@msn.com
Subject: Re: Inventory Interface flag
Check the MTL_TRANSACTION_INTERFACE table to see if it is sitting in the
table waiting to be cleaned up.
Good Luck,
Mike Buchanan
Date: Wed, 30 Jun 1999 21:20:14 +0300
From: mohammed alshaarawi m_sharawy@tccbce.com
Subject: RE: Inventory Interface flag
Thanx alot. We did it.
Date: Wed, 30 Jun 1999 21:33:52 +0300
From: mohammed alshaarawi m_sharawy@tccbce.com
Subject: RE: Inventory Interface flag
please does this update in so_lines.s8 effect the database consistency.
we mean do we must update another tables.