Pending Transactions - how to process
From: AHMETH@turktraktor.com.tr [mailto:AHMETH@turktraktor.com.tr]
Sent: Tuesday, October 26, 1999 6:51 AM
To: Multiple recipients of list
Subject: Pending transactions
Hi
I have 182 pending item at Inventory /transactions/pending
transactions.Transaction type of all these transactions are WIP
Component issue and all of them were catched at background processing.
There is no error explanations at the pending transc.screen.I tried
twice to submit all from the special button but noting changed.Material trans.
manager and Planning manager are running 30 sec. intervals.We use
ORACLE
Manufacturing 10.7.0 SC161.Has any one a solution how to be processed
the
pending transactions higly appreciated.
Ahmet Hasirci
Ahmeth@turktraktor.com.tr
Date: Tue, 26 Oct 1999 09:34:35 -0400
From: "Finney, Jack" jack.finney@glenayre.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Pending transactions
I have found that a transaction that drives inventory negative will stop the
transaction process for all transactions, and may not return with an error.
I suggest re-submitting small blocks of transactions instead of all 182. It
may take more time, but you will find the one or more transactions that is
(are) causing the pending issue.
Beware that during this lag time some well meaning users will commit a new
transaction that duplicates one of the pending transactions, because they
think it hasn't been done or the system is 'broke'. This will require an
inventory correction by doing a WIP component receipt to back out the
duplicate issue.
hope this helps,
Jack Finney
Date: Tue, 26 Oct 1999 06:55:01 -0700
From: Karen Blackwell KBlackwell@rockshox.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Pending transactions
Check to be sure these items are not defined as reference items. We had
this problem in the early days where the item was defined, put onto the BOM,
Work Orders were created then the item was changed to Reference Only. But
with all the Work Orders open, the system wanted to consume the items. If
this is the case, you can probably delete them from the Interface table.
If the above scenario is not the case, contact Oracle Support. There are
other fields which can be changed and the transaction can possibly be
"pushed" through.
HTH
Karen
From: cwright@guthy-renker.com
To: oraapps-l@cpa.qc.ca
Subject: =?ISO-8859-1?Q?Re:Pending_transact=FDons ?=
The entire batch will error out even if only one transaction is in error. Check
each transaction for detail in the Error Explanation field. That one will be
the problem transaction. Submit all others.
One caveat: If you are multi-org you can only resubmit records within
the same organization. Make sure the concurrent manager picks them up before you try to
submit from other organizations.
Date: Tue, 26 Oct 1999 18:08:03 +0200
From: Clive Calder CliveC@langeberg.co.za
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Pending transactions
Only resubmit those without an error message and don't submit all at once.
Be aware that when one submits a transaction with an error in it, it pulls
all other transactions in that batch into the Pending table.
Regards
Clive Calder
Consignment Stock
Date: Sun, 31 Oct 1999 05:06:31 -0800 (PST)
From: Harish Bhatia hib_us@yahoo.com
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Inventory Related
Hi all,
We have an issue related to Consignment stock, a
feature we want to implement.
We want to receive stock on consignemt basis and would
be stored at our end. The stock will be the
responsibilty of the supplier.
Once the stock is consumed then only should the
supplier invoice us for the quantity consumed, not
for the quantity stored. The consignment stock held by
us at our end should also not appear in our books as
inventory.
How can we achieve this and has anyone come across
such a situation ?
Any help will be appreciated.
TIA
Harish
Date: Sun, 31 Oct 1999 21:04:40 -0800 (PST)
From: Krishnakumar Narasihman chnkrishna@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: ReplyInventory Related
harish,
you can receive the consignment in a subinventory that
is not nettable (planning), non-ATP, non-asset
inventory (the value doesn't appear in the balance
sheet. but you have to chek the quantity tracked bec u
cannot update the above boxes if qty box is not chekd.
u can use the setupOrganizationSubinventories
navigation.
whenever you want to consume, you move it to another
subinventory that is nettable, atp-able,reservable and
asset value so that they appear in the books. since no
accounting entries generated for subinventory
transfer, you better discuss with your GL/AP
consultant for the work around
hope this helps,
nkrishnkaumar
Date: Mon, 1 Nov 1999 13:07:53 +0700
From: "Nagamohan U." umohan@irs.co.id
To: oraapps-l@cpa.qc.ca
Subject: RE: ReplyInventory Related
Hi Krishna
Your solution works just fine.
In this we do not have to worry about the accounting entries in subinventory
transfers. Whenever we transfer material between expense subinventory and
asset subinventory accounting entry gets generated automatically. The entry
will be between expense account of the expense subinv and the material
account of the asset subinv.
From there you can deliver to the consumption. If you think for this you
have to discuss with GL/AP consultant, you do not have to.
Regards/Nagamohan
Patches 873656, 873657
From: Nagamohan U. [SMTP:umohan@irs.co.id]
Sent: Tuesday, November 30, 1999 10:42 AM
To: OAUGnet
Subject: Inv: Patches 873656, 873657
Hi
We are on 10.7 16.1 7.3.4 Sun Solaris 2.5.1.
As part of the Y2K patches we were told by Oracle to apply the Inventory
patches 873657 (server), and 873656(Client) (I think this patch set D).
This
patch is released on Nov.4th (From Metalink). After applying these patches
we are facing problems in many forms in PO like all Receiving forms
including inquiry form and requisitions entry form. And there is one view
RCV_CONFIRM_RECEIPT_V that is in the invalid status.
The error says that there is an Invalid column in this view definition. We
are yet to test Inventory module.
Has anybody faced problems from these patches? Is this patch actually
required for Y2K compliance?
Regards/Nagamohan
Subject: RE: Patches 873656, 873657
From: Patty Phelan patty.phelan@jmedpharma.com
Date: Tue, 30 Nov 1999 11:51:35 -0600
We also had this invalid view after installing this patchset, and per
Metalink it is only
used for the NCA platform and should not have been included in the GUI
patchsets,
therefore it is safe to drop it (if you are not NCA). You can find this info
on Metalink
by searching on the view name if you'd like to see the exact article.
-patty
Subject: Re: Inv: Patches 873656, 873657
From: swoods5@csc.com
Date: Tue, 30 Nov 1999 14:31:32 -0500
yes I have faced that problem in the past. The short term fix is to add the
column to the underlying table. The long term fix to log a tar with Oracle
and
specifically state the issue is the missing field on the underlyin table. I
believe there is a script Oracle can point you to that needs to run in a
certain
prescribe order, that the patch runs out of sequence.
Subject: FW: Inv: Patches 873656, 873657
From: "Bryant, Sylvia" sylviabryant@monetteis.com
Date: Tue, 30 Nov 1999 15:08:50 -0500
Additional problems we encountered when running those patches is that the
newest applet has to be installed as well. Otherwise, more problems.
Cycle Count duplicating sequence numbers
bbain@ec.rockwell.com wrote:
Environment: 10.7SC 16.1
I am using Oracle Cycle Counting and have the job scheduled so that a
count
list is generated with a list of items to count everyday. It appears that
I got some duplicate sequence numbers this week. Monday's count list was
fine. Today's count list has duplicated the sequence number with a
different item number to count. Any ideas?
Beth Bain
IT/Business Process Re-Engineering
Rockwell Electronic Commerce
300 Bauman Court
Wood Dale, IL 60191-8007
630-227-8174
Subject: Re: INV: Cycle Count
From: John Hallsworth jhallsworth@top-team.com
Date: Tue, 30 Nov 1999 17:44:23 -0800
Duplications of sequence numbers are allowed by the system. This can be
across
different cycle counts or within the same cycle count. The sequence number
is
controlled in the Cycle Count form under the Control, Scope group. The
Starting
Sequence identifies the next sequence number that will be used when counts
are
again generated. If this field is reset, it will likely cause duplication of
the
sequence numbers within the same cycle count. Duplications are expected and
are
normal between the different cycle counts.
Intransit inventory - accounting of
Subject: RE: INV Organisation parameters problem....
From: Sumita_Lal Sumita_Lal@hts.satyam.com
Date: Wed, 1 Dec 1999 14:58:00 +0530
Hi All !
I am facing a problem while defining the inventory organisation
parameters.
We are on Release 11.0.3
For an average costing organisation, the Intransit Inventory Account (in
the
Inter-org Information region) is defaulting from the Material Account
defined in the Costing Region. In fact even if I don't enter any
Intransit
Inventory Account and try saving the Organisation parameters, it saves
the
Intransit account with the same value as I had defined in the material
account. Also it is allowing me to skip defining the expense account -
whereas it is a mandatory account for an average costing org.
The same problem is not there if I define a Standard Costing
Organisation.
Please reply if you have any clue to what the problem could be.
Thanks in advance,
Sumita
From: Dina Rotem (h)
Reply To: oaugnet@lists.ksinet.com
Sent: Wednesday, December 01, 1999 2:17 AM
To: OAUGnet
Cc: Sumita_Lal
Subject: Re: INV Organisation parameters problem....
Sumita
The intransit account is getting the same account you entered to inventory
valuation account, cost element material, and you should not be able to
modify
it. That is the way the system was designed, and it is not a bug.
If you don't populate the expense account, on the inventory org. level,
you won't
have a default for the sub inventory account. You must have an expense
account
for expense sub inventory.
Dina
Subject: RE: INV Organisation parameters problem....
From: Sumita_Lal Sumita_Lal@hts.satyam.com
Date: Wed, 1 Dec 1999 14:58:00 +0530
Thanks for your response Dina.
But in case the company wishes to value intransit inventory in a separate
account (which is a probable case) then this cannot be done. In fact, the
earlier releases supported a separate account for the intransit inventory.
How do you capture your stoc-in-transit otherwise ?
Regards,
SUmita
Subject: Re: INV Organisation parameters problem....
From: Dina Rotem dinar@rafael.co.il
Date: Wed, 01 Dec 1999 12:06:48 +0200
Sumita
There is a problem with the way Oracle calculates the transaction value of
sending and receiving via intransit.
They are aware of that and planning to correct that by release 12.
The way I understand it is as follows - when you use interorg transfer FOB
shipment, the sending organization inventory valuation is credited for the
average cost of the sending organization.
The Receiving organization intransit account is debited for the same amount.
When you receive the item in second org, the transaction value is based on
the
current average cost of the receiving org (which may be different from the
sending). In this scenario, the intransit account is not cleared for ever.
By forcing the same account Oracle worked around that problem.
I think you may be able to get an estimate of the intransit value, only by
developing your own report.
Dina