Cost Manager failing
Date: Mon, 19 Jul 1999 15:10:45 -0400
From: alin2@csc.com
Subject: INV: Material Cost Transaction Worker Failing to cost
Hi,
We're on 10.7sc/16.1 unix 10.20 7.3.4.4. and have the Cost Manager
scheduled to run on a daily basis. Every so often (maybe one out of 10) the
process completes with a Warning. When you look at the logfile for the cost
worker, you can see where it costs transactions, then fails intermittenly
with the message:
Failed costing id = 123456
APP-00988 Oracle error 1476 in insert_acct
APP--00406 No message explanation found for message '&MESSAGE'
Within one scheduled run that completes with a warning, it fails
intermittenly throughout the log. I've been working on this issue with
Oracle support for over two months now and they do not have a clue why this
is occurring.
If anyone out there has seen this or might have a clue, your assistance
would be greatly appreciated.
Thanks
Alice
Date: Tue, 20 Jul 1999 10:49:35 -0500
From: "Danette Fedock"danette_fedock@ccmail.c-tec.com
Subject: RE:INV: Material Cost Tranaction Worker Failing to Cost
We've run processes that complete with warnings. Oracle support and
our experience has lead us to believe the warning is telling you there
are no items to cost since that manager last ran.
You may try deactivtating the manager and reactivating it or looking
at the setup of the problem item that may differ from an item that is
being costed properly??
Date: Sun, 25 Jul 1999 05:14:25 PDT
From: "shawish sababa" shawish_sababa@hotmail.com
Subject: RE:INV: Material Cost Tranaction Worker Failing to Cost
Hi Alice
first i must tell you that i have no experience with 10.7sc/16.1, but based
on my expatriate in R11 try to see if you can find a record in
MTL_MATERIAL_TRANSACTIONS that the transaction_id is 123456 if so, contact
my
Shawish
In isolated Pick Slips getting 'No Loacator Specified' error
Date: Mon, 26 Jul 99 18:16:19 -0600
From: "John SCHMITZ"john.schmitz@ccmail.adp.wisc.edu
Cc: john.schmitz@ccmail.adp.wisc.edu
Subject: INV Stock Locator "No Locator Specified" error
Hi,
Can anyone give me a lead on a this problem - we are getting (10.7.4
NCA) a message "No Locator Specified" on isolated pick slips. I
traced it back to the demand process which could not identify an item
stock locator. The related items have on-hand quantity, had previously
been successfully picked, and have identical attribute settings as
"good" items. Other items from the same subinventory and locator are
being found. Any clues or advice?
Thank you,
Unable to enter Inventory Organization parameters
Date: Mon, 26 Jul 1999 09:12:02 -0400 (EDT)
From: Krishnakumar Narasihman chnkrishna@yahoo.com
Subject: Re: Multiple Organization Support Feature
Hi all,
We are implementing Oracle Financials ver 11.03. This is a Multi org
with single SOB having 4 operating units with one legal entity. when i
tried to create inventory organisations, it allowed me to create
Organizations but not allowed me to enter organization parameters and
save the data. i give below the details . i will be very thankful if i
could get an immediate response.Pl.send to my email id. thanks in
advance
N. Krishnakumar
email: nk_kumar@yahoo.com
Details are as follows:
Oracle Applications 11.0.300
Application Object Library 11.0.28
Oracle Forms 4.5.10.10.2
RDBMS 8.0.5.0.0
Form Application Oracle Inventory
Form Name INVSDOIO
Form Version 11.0.12
Form last modified 16-SEP-1998
FRM-40735: PRE-INNSERT trigger raised unhandled 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
===
Krishnakumar
Gokulam
35/12 East Park Road
Shenoy Nagar, Chennai 600 030
INDIA
Ph: (91)(44)6446131
http://members.tripod.com/~sramji/kk
Date: Tue, 27 Jul 1999 13:35:34 -0400
From: Steve_Deackoff@air-water.com (Steve Deackoff)
Subject: Re: Inv: Organization creation problem
Do you have any invalid objects?
Also try flushing shared pool and have user logout an login again.
If memory serves me right, I've seen this issue as a memory leak in
8.0.5,
It went away by increasing the shared_pool_size and periodically
flushing
the shared pool (hourly). But that was in a 7.3.2 database.
Also check all your other init.ora parameters.
If it persists you may want to upgrade to 8.0.6 or latest patch
8.0.5.1.0
if Oracle allows it in their compatibility matrix.
Curious, if you are on NT or another Intel platform?
Regards,
Steve Deackoff
Date: Tue, 27 Jul 1999 17:50:59 PDT
From: "ravi chandran" johnny_ravi@hotmail.com
Subject: Re: Inv: Organization creation problem
you have not run the addadmin for multiorg setup properly. check the
addadmin run report.
Ravi
Date: Tue, 27 Jul 1999 22:15:33 -0700 (PDT)
From: Krishnakumar Narasihman chnkrishna@yahoo.com
Subject: Re: Inv: Organization creation problem
hi all,
i could solve this issue. this is actually related with Stock locator
flexfield which comes with default 19,20 segments for project and task.
even not enabling this did not allow me to create organizations. in
fact there is a patch c/d851461 which fixed this problem.
Ravi: creating organization is an independant and one step before
running adadmin.
n.krishnakumar
email id nk_kumar@yahoo.com
How to automate Inventory Closing
Date: Tue, 27 Jul 1999 20:55:56 -0400
From: cshay@csc.com
Subject: Automate Inventory Closing
Does anyone know how to automate the month end close process for inventory.
We would like to schedule the inventory close to run at a certain time each
month. We are on Rel 11.
Inventory Out of Balance
Date: Wed, 28 Jul 1999 08:06:08 -0400
From: alin2@csc.com
Subject: Inventory: Out of Balance
Hi all,
Has anyone ever encountered an out of balance situation in their Inventory?
We ran the GL transfer & import and there is one batch that is out of
balance. Then we ran the Material Account Distribution detail report for a
specific date range and the difference in the unbalanced JE is the balance
on the Material report. We've called Oracle Support and no answer yet.
Thanks for your assistance in advance,
Alice
Date: Wed, 28 Jul 1999 20:02:39 +0700
From: "Nagamohan U." umohan@irs.co.id
Subject: RE: Inventory: Out of Balance
Hi Alice
Please check whether accounting code combination id generated for these
transactions. You can run the following script to check that.
Select reference_account from mtl_transaction_accounts
Where gl_batch_id=&your_gl_batch_id_which is out_of_balance
You can find the gl_batch_id in GL_Interface table Reference21 column.
You can find the organization code in the reference22 column.
This may result in -1 for some transactions. Because of this the debit
or credit entry of this transaction will go to GL and the associated
debit/credit entry will remain in Inventory because of the problem in
the code combination id generation.
If you find -1 in the table you have to update the reference_account
column in the MTL_TRANSACTION_ACCOUNTS table.
After that you have updated this table, check any transaction is there
in the GL_INTERFACE table from inventory with this account with which
you have updated the table. If it is there just add the amount in the
import corrections form against this account. Otherwise you have to
insert a record in the GL_INTERFACE table with all the relevant
information so that the accounts get balanced.
Regards/Nagamohan
Item import not working - Query 1
Date: Mon, 19 Jul 1999 13:21:38 -0700
From: deepa sood dsood@us.oracle.com mailto:dsood@us.oracle.com
Subject: RE:Item Import
Hi,
We are running item import and the concurrent manager is not
processing any rows. The process flag remains set at 1. Does anyone have
a clue as to what is causing this?
Thanks
Deepa
Date: Mon, 19 Jul 1999 13:48:31 -0700
From: "Gopalakrishnan, Suresh (sureshgk)" sureshgk@sequent.com
Subject: RE: Item Import
Hi,
We faced a similar situation recently. Please try again after filling the
following columns in interface table -
LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY,
LAST_UPDATE_LOGIN and TRANSACTION_TYPE (value - 'CREATE').
Good luck -
Suresh G
Sequent Computer Systems Inc.
sureshgk@sequent.com
Date: Mon, 19 Jul 1999 16:05:20 -0500
From: "MCAVOY, Brian J." bmcavoy@shl.com
Subject: RE: Item Import
Make sure your inventory managers are running to process the rows in the
interface table, otherwise they'll just sit there. I don't have anything in
front of me but if you look at the interface manual it should say which
managers need to be running.
Good Luck.
Brian McAvoy
Consultant
EDS
pager 888-319-3433
bmcavoy@shl.com
Item import not working - Query 2
Date: Wed, 28 Jul 1999 07:54:55 -0500
From: Carole Mills cmills@usdata.com
Subject: inventory item import
16.1 GUI 10.7
I am trying to run item import. I have records in the
MTL_SYSTEM_ITEMS_INTERFACE and I run the item import under inventory and
it does nothing. I does not import the records nor does it put any
records in the MTL_INTERFACE_ERRORS. Is there something else I need to
setup or run?
thanks
Carole Mills
cmills@usdata.com
972-497-0224
Date: Wed, 28 Jul 1999 06:23:14 PDT
From: "shawish sababa" shawish_sababa@hotmail.com
Subject: Re: inventory item import
Hi Carole
Check if your concurrent managers are active by going to
SYSTEM ADMINISTRATORconcurrentsAdminister concurrent managers
and look at the Actual column. if all the numbers there are 0 ask your
system guys to run the concurrent managers.
Shawish
Date: Wed, 28 Jul 1999 09:06:15 -0500
From: Carole Mills cmills@usdata.com
Subject: RE: inventory item import
thanks for the idea, but all of them are active. Any other suggestions
are welcome
Carole Mills
cmills@usdata.com
972-497-0224
Date: Wed, 28 Jul 1999 08:40:30 -0700
From: deepa sood dsood@us.oracle.com
Subject: Re: inventory item import
Hi,
We were on ver 11 and were having the same problem.
We had to apply an I/O patch and that fixed the problem for us. Also make
sure that you are not populating the inventory_item_id column in the
interface table.
Thanks
Deepa
Date: Wed, 28 Jul 1999 08:08:18 -0700 (PDT)
From: Ravi Krishnamurthy ravi_krishna@rocketmail.com
Subject: RE: inventory item import
Carole,
Maybe your items failed a validation check. Check the PROCESS_FLAG
value in the mtl_system_items_interface table. For the meaning of the
values, look in the Oracle Manufacturing, Distribution, Sales and
Service Open Interfaces Manual.
Hope this helps.
Ravi Krishnamurthy
Senior Consultant
Oracle Applications
Date: Wed, 28 Jul 1999 10:31:28 -0500
From: Carole Mills cmills@usdata.com
Subject: RE: inventory item import
I have checked that and it is null, it ask just like its not running
anything. In worked in 16.0 and has not worked since upgrading to 16.1
so I am sure there is probably a patch but oracle is taking there good
old time telling me.
Carole Mills
cmills@usdata.com
972-497-0224
Date: Wed, 28 Jul 1999 11:38:10 -0700
From: deepa sood dsood@us.oracle.com
Subject: Re: inventory item import
The process_flag cannot be null, it has to be set to one for rows to be
processed
Date: Thu, 29 Jul 1999 00:13:42 +0800
From: "Lee Chee Meng" leecmg@cyberway.com.sg
Subject: Re: Inventory item import
Carole, try setting the process flag to 1 (Pending) and also the transaction
type (or something to that effect) to CREATE.
Regards,
Chee Meng
Date: Thu, 29 Jul 1999 01:09:11 MYT-8
From: philip@aleytys.pc.my
To: Carole Mills cmills@usdata.com, oraapps-l@cpa.qc.ca
Subject: RE: inventory item import
Dear Carole,
I've just got item import working and I ran a 8K item import overnight
successfully (on the test database).
The process_flag SHOULD NOT BE NULL. You should set it to 1 . The
import programme then sets it to a number 1 if there is an error.
Date: Wed, 28 Jul 1999 23:48:30 MYT-8
From: philip@aleytys.pc.my
Subject: RE: inventory item import
I am on 10.7 GUI 16.1 and while it's working here (so far) I once got a
PROCESS_FLAG value of 47. The Open Interface manual lists values only up
to 7. The MTL_INTERFACE_ERRORS table indicated that there was a snapshot
too old error in the rollback segements. I was trying to run 10 workers
at the same time using the PROCESS_SET_ID.
Date: Wed, 28 Jul 1999 11:36:46 -0700
From: deepa sood dsood@us.oracle.com
Subject: Re: Inventory item import
Carol,
There is an I/O patch that helped us. You might want to ask Oracle
support
about that patch.
deepa
Date: Wed, 28 Jul 1999 14:34:37 -0500
From: Carole Mills cmills@usdata.com
Subject: RE: inventory item import
Thanks to all the suggestions, I got it to work. It seems that the
parameters associated with the function were hose. After I went in and
re-entered them it started working just fine.
thanks again.
Carole Mills
cmills@usdata.com
972-497-0224