Item Import
Date: Thu, 25 Mar 1999 05:02:38 -0800
From: "MCAVOY, Brian J." bmcavoy@shl.com
Subject: RE: Item import problem
Bob, some of the attributes may not be set because they are in conflict with
another (one dependent on another being set first), I believe the system
does not generate an error but just does not set the conflicting attributes.
If your on 10.7 the beginning of chapter 3 of the Inventory user guide
should help with this information.
Brian
Brian McAvoy
Consultant
MCI Systemhouse
pager 888-319-3433
bmcavoy@shl.com
-----Original Message-----
From: Schmidt, Bob [SMTP:bschmidt@AAFINTL.com]
Sent: Wednesday, March 24, 1999 9:07 PM
Subject: INV: Item import problem
We are trying to import items from our legacy system. We are filling
the following in the interface table via SQL*Loader.
TRANSACTION_TYPE ,
PROCESS_FLAG ,
ORGANIZATION_CODE ,
SEGMENT1 ,
DESCRIPTION ,
PRIMARY_UNIT_OF_MEASURE ,
TEMPLATE_ID ,
MATERIAL_COST
It seems to import OK (doesn't generate an error) but all the defaults
from the template are not populated. We have especially noticed this in
some of the OE attributes. Any ideas?
Thanks,
Bob Schmidt
EDS
502.637.0446
502.637.0520 (Fax)
bschmidt@aafintl.com
Date: Thu, 25 Mar 1999 08:07:16 -0600
From: "Bearden, Bill" Bill.Bearden@glenayre.com
Cc: "'bschmidt@aafintl.com'" bschmidt@aafintl.com
Subject: Re: INV: Item import problem
Bob,
You didn't mention the version. I used templates last year on 10.7SC. It
worked as advertised.
Just a thought... Try filling in the template_name instead of the
template_id. I know this shouldn't make any difference, but I have seen
similar things. That is the only thing I can see that I did differently in
my test loads.
Bill Bearden
Bill Bearden Consulting
Date: Thu, 25 Mar 1999 09:22:29 -0500
From: "Schmidt, Bob" bschmidt@AAFINTL.com
Subject: RE: INV: Item import problem
Turns out we had attribute conflicts in our default template
Thanks,
Bob Schmidt
EDS
502.637.0446
502.637.0520 (Fax)
bschmidt@aafintl.com
Lot/Locator Control
Date: Thu, 25 Mar 1999 12:46:50 -800
From: "qq"qq@flashmail.com
Subject: INV: Lot/Locator Control 3 months after going live!!!
My client currently does not use any lot/locator control in their legacy inventory
system.
They have a requirement of imposing locator and lot control on items 4 to 5
months after going live with Oracle Apps Rel 11.
This is because the client is not sure of as to when all machanical requirements
at warehouses would be suited to support such item controls.
I would welcome any comments on whether such a delayed transition from no inventory
control to lot/locator controls is possible.
Thanks in advance
Sushi
Date: Thu, 25 Mar 1999 15:05:09 -0800 (PST)
From: tapasi nandi tnandi@yahoo.com
Subject: Re: INV: Lot/Locator Control 3 months after going live!!!
Hi Sushi,
for locator control problem,
keep the locator control at the sub-inventory level.
So at production cutover you can have sub-inventories that are not
under locator control. When your client is ready to move to a locator
control situation, create sub-inventory with locator control. Then do a
sub-inventory transfer.
For lot control there is no easy solution. To change the lot control you
must have zero stock. So you have to make a misc. issue or a/c alias
isuue to make stock zero and then change lot control parameter and then
a misc. receipt or a/c alias receipt.
If you have further clarification, pl. let me know.
Good Luck!!!
Sid Nandi
Date: Thu, 25 Mar 1999 15:26:05 -0800
From: "Woods, Jim" Jim.Woods@fluke.com
Subject: RE: INV: Lot/Locator Control 3 months after going live!!!
Hi Sushi,
Adding to Sid's comment on lot control, keep in mind reserved inventory
balances. Open wip, sales orders, and inventory reservations don't allow you
to get to a zero balance without some window of time especially with very
active items.
Jim Woods
Fluke Corp.
Date: Thu, 25 Mar 1999 19:14:44 -0600
From: "David Keeney" keeneyd@wilsonart.com
Subject: Re: INV: Lot/Locator Control 3 months after going live!!!
** High Priority **
Sushi,
What Sid said is correct.
If you do use locators at the Subinventory level, you could zero out your
Subinventory quantities, then set locator control at the Subinventory
definition, then define your locators, and populate them with a Physical
Inventory. This way you could keep your current Subinventory definition
if desired. If you select Dynamic entry locator control, you can define
the locators as you enter the transactions.
Lot control is defined at the item level. If these are ordered parts, you
would have to clear out any existing orders, backorders, WIP Jobs, etc.
AND your Subinventory quantities for these items, then reset the item to
Full Lot control, then repopulate your Subinventory and then re-order the
closed out orders.20
//David
tapasi nandi tnandi@yahoo.com Thursday, March 25, 1999 3:59:28 PM
Pick Slip
Date: Fri, 26 Mar 1999 11:06:19 -0500
From: "Mohan, Lalit" mohanl@nzlatam.com
Subject: Customized Pick Slip report
Hi everyone
We have customized our Pick Slip report in Order Entry (Oracle 10.7 SC). OE
Setup (Shipping/Document Sets) allows us to choose which reports are
submitted when Pick Release process is run.
We have our own Modifications Unix directory structure and an application
registered as Modifications. We have defined the customized report in
Concurrent executable, program definition, etc and also put it in various
responsibility report request groups.
The problem we are having is that the Customized report is not showing in OE
Setup for Shipping / Document Sets. So it can't be chosen instead of Oracle
standard Pick Slip report.
Can anyone through some steps we are missing which makes them visible on the
List of Values within OE Setup/ Shipping/ Document Set form.
Any help is greatly appreciated.
Thanks a million in advance
Lalit
_________________________________________________________
Lalit Mohan
Solutions Management Consultant, Project BIELA
NZ Dairy Services (Latin America) Inc.
(Regional Headquarters for Latin America & Caribbean region of
New Zealand Dairy Board, Wellington, New Zealand)
1 Financial Plaza, Suite 2700
Fort Lauderdale, FL33394, USA
email: mohanl@nzlatam.com
telephone: (954) 281-5346, 760-9880
fax: (954) 760-9885
Date: Fri, 26 Mar 1999 09:49:27 -0700
From: Mary Anderson MaryA@sodak-gaming.com
Cc: Sue Bidwell SueB@sodak-gaming.com
Subject: RE: Customized Pick Slip report
We just implemented the same process. You need to go through the process
outlined in the Oracle Order Entry Technical Reference Manual Volume 2, Page
B-2 in the Appendix, "Adding Custom Reports to Document Sets". You will need
to run SQL scripts to add your report to custom reports table, then add
that custom report to the Pick Release document set table, then add a list
of parameters.
Following are the scripts we used:
Insert into reports table using SQL Plus
INSERT INTO APPS.SO_REPORTS (report_id, creation_date, created_by,
last_update_date, last_updated_by, last_update_login,
report_application_id, name, description)
VALUES (1000, SYSDATE, -1, SYSDATE, -1, -1, 20003, 'SGOEPTKT',
'sodak custom consolidation pick slips');
COMMIT;
/
Then insert into document sets table using SQL Plus
INSERT INTO APPS.SO_REPORT_USAGES (report_usage_id, creation_date,
created_by,
last_update_date, last_updated_by, last_update_login,
report_id, usage_code)
VALUES (1000, SYSDATE, -1, SYSDATE, -1, -1, 1000,
'PICK_RELEASE');
COMMIT;
/
Then copied the parameters for the original pick slip (report_id 2) for
the new pick slip
DECLARE
CURSOR param_cursor IS
SELECT parameter_num, name, rowid
FROM apps.so_report_parameters
WHERE report_id 2;
up_param NUMBER;
up_name VARCHAR2(35);
up_row VARCHAR2(18);
BEGIN
/* add new parameters for custom consolidated pick slip report */
OPEN param_cursor;
LOOP
FETCH param_cursor INTO up_param, up_name, up_row;
EXIT WHEN param_cursor%notfound;
INSERT INTO APPS.SO_REPORT_PARAMETERS (report_id,
parameter_num,
creation_date, created_by,
last_update_date, last_updated_by,
last_update_login, name)
VALUES (1000, up_param, SYSDATE, -1, SYSDATE, -1, -1,
up_name);
END LOOP;
CLOSE param_cursor;
COMMIT;
END;
Date: Fri, 26 Mar 1999 08:52:50 -0800
From: Rupert Gonzales t_rupert_g1@Verifone.com
Subject: RE: Customized Pick Slip report
You need to populate SO_REPORTS, SO_REPORT_USAGES, and SO_REPORT_PARAMETERS for
your custom report.
Date: Fri, 26 Mar 1999 11:54:15 -0500
From: "Paul van den Brink" pbrink1@ibm.net
Subject: Re: Customized Pick Slip report
In the appendix of the OE TRM it is described how to do this. You have to
make some entries in OE tables before you can run this report.
Paul
==================
Paul van den Brink
Colibri
Phone: 407 248 0995
==================
Date: Fri, 26 Mar 1999 12:12:00 -0500
From: "Mohan, Lalit" mohanl@nzlatam.com
Subject: RE: Customized Pick Slip report
Thanks Mary for the prompt response and the details. Actually I was working
off-site without technical manuals. Doesn't it remind us all of the
usefulness of TRM and other M's.
Thanks also to Paul van den Brink, Rupert Gonzales for putting me in right
direction. Also thanks to other people who may reply subsequently.
Greatly appreciate this lists quick responses.
Cheers
Lalit
Items on Hold
Date: Mon, 29 Mar 1999 10:17:11 -0800 (PST)
From: "Dale Peterson - Ind. Consultant" dalepeterson@rocketmail.com
Subject: Re: Items on Hold
Unfortunately the subinventory transfer to a non-shippable
subinventory solution is the only one. A specific lot or
serial number or locator cannot be put on hold, only the
entire item itself can be non-stockable. A modification
could be written but it would be considered a Major
enhancement. Submit an enhancement request.
===
Dale Peterson
Manufacturing Consultant
---MAnderso@darc.com wrote:
Date: 03/26/99 16:31
From: MAndersoŚrc.com@INTERNET
Subject: Items Hold
NRRQ
Anyone,
Does anyone have any suggestions for how to put items on
hold ?
Currently, after an item has been manufactured and
placed into a
finished goods subinventory, QA may decide a specific
serial number
range needs to go on hold ( we don't currently use any
ind of lot control) We are planning to move the
items/serial numbers
into a hold subinventory which is non-pickable,
non-shippable, but we
were hoping there was a better function/transaction in
Oracle with
which to do this than subinventory transfers.
thought that there was a specific transaction which
could disposition
finished goods to an MRB and place them on hold, but I
may have been
dreaming. Does anyone have any suggestions other than
using
subinventory transfers and locked down subinventorie
? Ideally, it would be nice to change a serial
number/items' status to
on hold in order to accomplish this.
Thanks !
Maggie
Date: Mon, 29 Mar 1999 13:56:00 -0500
From: "Talwar, Aman x1109" ATALWAR@genicom.com
Subject: RE: Items on Hold
just a suggestion. You could reserve the item for user defined source
type
and
source . then later remove the reservation
Best of luck
Aman
Date: Mon, 29 Mar 1999 15:56:37 -0800 Registering a custom report
From: Bharat Patel[SMTP:bpatel@DOMINOAMJET.com]
From: Carver, Elizabeth [mailto:ecarver@MarkAndy.com]
From: Bharat Patel[SMTP:bpatel@DOMINOAMJET.com]
From: Carver, Elizabeth [mailto:ecarver@MarkAndy.com]
From: Bharat Patel[SMTP:bpatel@DOMINOAMJET.com]
From: Carver, Elizabeth
Date: Fri, 16 Apr 1999 08:33:45 -0500 R11 Open Item Interface
Cavazos Fausto-FFC007 Fausto_Cavazos-FFC007@email.mot.com wrote:
From: oraapps-l@cpa.qc.ca [mailto:oraapps-l@cpa.qc.ca]On Behalf Of
siddhartha nandi
Date: Thu, 22 Apr 1999 15:38:08 +1000
Date: Thu, 22 Apr 1999 08:17:45 -0500 Pending transactions/negative balance
From: 221 Liu, Richard [mailto:richliu@ctxopto.com.tw]
From: 221 Liu, Richard [SMTP:richliu@ctxopto.com.tw]
From: Nagamohan U. [mailto:umohan@irs.co.id]
Date: Wed, 5 May 1999 16:36:26 +0800
From: "=?iso-8859-1?Q?Ignacio_D=EDez_Mart=EDnez_O'C'adiz?="
Subject: RE: ORAAPPS-L digest 2973
You can put a hold to an item if you have the Order Entry module, you
can put holds at customer, order, line or item levels. So the items
won't be picked by the pick release process, you won't be able to book an
order
if the order has an item which is on hold.
Hope this helps.
Sent: Thursday, April 15, 1999 9:59 AM
Subject: Registering a custom reports in inventory
hi, Folks, I am trying to register a custom reports which I want
to
access
from inventory module.I already registered it and also added in
request
group Planning and Forecasting Rept but it didn't come up when I
tried
to
see it by log in inventory user -Planning, it wasn't there. I
would
like
to
see it within Planning. This report separates output of the
minmax
planning
report by internal and external suppler.
any ideas about it?
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Sent: Thursday, April 15, 1999 11:41 AM
Subject: RE: Registering a custom reports in inventory
Did you register it in the correct request group? Are you using a
custom
responsibility? If so make sure your responsibility recognizes
that
request
group. Is inventory user -Planning the path you are using? If so
that is
not correct. You need Inv- Reports - Planning. It should be
there.
Beth Carver
Sent: Thursday, April 15, 1999 12:07 PM
Subject: RE: Registering a custom reports in inventory
Beth, I am using the same responsibilities that inventory user
has. It
only
customized report, not whole application. Also it is still using
the
predefined request group for Inventory that I already mentioned.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Sent: Thursday, April 15, 1999 12:33 PM
Subject: RE: Registering a custom reports in inventory
You can register any report in any request group. Try adding an
Oracle
standard report into that request group and see if that works. If it
does
then there might just be something wrong with your custom report.
Beth Carver
Sent: Thursday, April 15, 1999 1:56 PM
Subject: RE: Registering a custom reports in inventory
Beth, I am able to access that reports now but not from the
inventory-planning. when you expand there is another planning and I
can see
that report there as well as able to run it. Still I would like to
see my
report near by minmax report but somehow it didn't come up there.
Thanks for ur suggestions.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Sent: Thursday, April 15, 1999 3:54 PM
Subject: RE: Registering a custom reports in inventory
I am sorry I am not familiar with Inv but I did some quick checking and
now I understand what you want. The reports located in Inv -Planning are
driven by menus and functions. This is what you want to do Go to the form
functions form and query by the Min-max report you keep referring use the
description column to query. Create a new function ( this is so we can
call your report in the menu) call it whatever you want. In the form
column for this function we want Run Reports(this is the submit request
screen). For the app if you have a custom I would use that otherwise AOL
will do. In the parameters field (This has to be exactly correct in order
to work) We are going to use parameters like the min-max function TITLE I
am sorry I looked for this and I can not find what this is referring to.
The CONCURRENT_PROGRAM_NAME"THIS IS YOUR SHORT NAME FOR YOUR REPORT"
PROGRAM_APPL_SHORT_NAME"WHATEVER YOUR CUSTOM REPORT IS IN" USE_ORG'Y'.
For the User function name this is your choice. TYPE will be FORM. Now
Navigate to the Menu form we have to add the function to the menu (so it
will now be in the list) query for the menu name INV_PLANNING you should
see your other reports in the list. We are going to add the function you
just created to the list Give it a sequence number the Navigator prompt is
what your users see. Leave submenu blank. In the function field find the
function you just created and add a description if you want. Commit and
sign on into INV you should now see your custom report and should be able
to run it. Let me know if you have problems.
Beth Carver
From: "Carver, Elizabeth" ecarver@MarkAndy.com
Subject: RE: Registering a custom reports in inventory
I did not give you a reason yesterday on why you need to do this. The
function you created will set up the submit request form and the parameters
for this function will call your custom report. You must add this to the
INV_PLANNING menu so the form will be added to the responsibility. This is
the only way that I know how do this.
Beth Carver
Hello List,
We need your help on this one!. Does anyone have
some tips on
how to improve the performance for the IOI on R11?
Any new Tricks, patches? Indexing???
Thanks!
FC
Sent: Thursday, April 22, 1999 2:15 PM
Subject: Re: INV: R11 Open Item Interface ***
FC,
try putting different set_process_id every 200 records or so.
Hope this helps. If it works pl. let us know.
Sid
Sid Nandi
Sr. Principal Consultant
Millennia Vision Corporation
Snandi@mvsn.com
650-934-3295 (230)
From: "bhoulaha" bhoulaha@nsw.bigpond.net.au
Subject: RE: INV: R11 Open Item Interface ***
I got the details below from a guy at Oracle late last year. While it is
directed at R10.7, there is a lot of good stuff here - and it actually
works. The authors name is at the bottom.
Brian Houlahan
Brison Technologies Pty Ltd
mailto:bhoulaha@nsw.bigpond.net.au
Item Open Interface - Getting Most from IOI process
The intention of this document is not to claim that IOI code is the most
optimized one. There may be a definite scope of improvement but the
performance improvements achieved in recent fixes (Since Oct.'97) have
been
VERY significant and FIRST, we should make sure that we understand
those,
implement them and then gather some performance statistics before
discussing
the IOI performance.
The First Step
Get the latest patch. ARU is available against bug 701041. It contains
several prerequisites. Before applying the patch, read the instructions
in
all the pre-req bugs carefully. Almost ALL the information you may need
to
setup your IOI is available in file readme.txt shipped with the patch.
Several indexes have been changed from time to time in an attempt to
improve
performance. There may be changes to some of the index names. Make sure
all
old indexes are dropped from the interface tables before the patch is
applied.
Verify the patch
After you apply the patch, make sure that you have following set of
indexes
in place :
mtl_system_items
. Non Unique Index on organization_id,segment(n)
mtl_system_items_interface
. Non Unique Index on inventory_item_id, organization_id
. Non Unique Index on Item_number
. Unique Index on Transaction_id
. Unique Index on organization_id, segment(n)
. Non Unique Index on set_process_id
mtl_item_revisions_interface
. Non Unique Index on set_process_id
. Non Unique Index on Transaction_id
. Non Unique Index on Organization_id, Inventory_item_id, Revision
mtl_item_categories_interface
. Non Unique Index on inventory_item_id, category_id
. Non Unique index on set_process_id
. Unique Index on transaction_id
Once you are sure that the patch has been applied correctly, test the
patch
with a few rows. Make sure these are processed correctly.
Running IOI
Now comes the preparation phase for running the IOI. A lot depends on
how
you actually run IOI too.
While processing large number of rows (Say 5000+ Items), you may want to
break the task into smaller ones (Say 500 items - See - 'Deciding Batch
Size'). The best practice would be to load the interface records,
process
them and then delete the interface rows which have been processed
satisfactorily. If you want to maintain history, you may create history
tables and move processed rows there instead of deleting them.
A practice which is being followed is to split the job into multiple
(4-5)
processes using set_process_id. You may give different set_process_id to
different batches and then run multiple number of processes at the same
time, one for each set_process_id.
Deciding Batch Size
Ideal size of a batch would differ based on the size of Data and Power
of
your system. If you are processing around 10000 items or less, batch
size of
500 - 1000 can be assumed safely to process the rows and you may run 2-3
batches simultaneously.
For larger data, you may go for a batch size of 1000 but you may want to
try
larger batch sizes, say upto 2000 items. Best way to determine your
batch
size is to do some benchmarking.
A good start would be to load 1000 items in interface tables. Note down
the
time IOI takes to process these rows. If this time is more than 10
minutes,
try and stick with the batch size of 1000 or less. Otherwise, you may
want
to try larger batch size.
Once you have determined your batch size, you may want to determine how
many
batches you may want to run in parallel. Run 2 batches in a sequence and
note
down the time. Then run these two simultaneously and see how the system
performs. Based on the comparison of these two runs, decide how many
batches
would you like to run simultaneously.
What to expect
Performance of IOI is directly linked to the size of your data and the
power
of your system. On a system which has been scaled appropriately, we
expect
to
process upto 5,000 rows in 5 batches of 1000 items every 15 minutes
(20,000
items per hour). This is just a guideline. No claims are being made
here.
Some of the Customers have achieved upto 71,000 items per hour.
Aseem Gupta
Applications PQE
ORACLE Corporation
-------------------------------------------------------
Ph : (650) 506-1988
Fax : (650) 506-7814
Email : asgupta@us.oracle.com
Web : http://www.oracle.com
From: "Veach, L. Vincent" VeachLV@bvsg.com
Subject: RE: R11 Open Item Interface ***
I don't know if this is new or not but this attached file might prove
helpful?
Also, the interface will actually run faster if you group your data into
1000 row sets and
run the interface multiple times concurrently. This is done by giving each
set of 1000 it own
set_process_id and then run the concurrent process for that set process id.
Also, there was a query within the interface (10.7) that was real slow. The
related table names were
CST_ITEM_COSTS and CST_ITEM_COST_DETAILS. If you have a test environment
turn off costing
and watch how much faster it runs.
filename"IOI steps.txt"
STEPS for Successfully Loading Items Using IOI
1.Check all Set-Up Parameters
2.Apply IOI Patches (make sure you don't have any INVALID packages &
objects)
3.Ensure that INCOIN is re-linked after applying the baseline IOI
patches
4.Check indexes on mtl_system_items_interface and mtl_system_items
5.Check whether the concurrent manager is up and running before
loading items
6.Define an item thru the Define Item form. If successful, proceed
to
the next step.
7.Truncate ALL IOI interface tables before loading
mtl_system_items_interface.
8.Load items first into the master organization. An item must exist
in the master organization before you can
load items into the child organization. Also, all items need to be
validated, before they can be processed into
Oracle Inventory. Refer Interfaces Manual for Details.
9.Populate the following bare minimum required columns to check that
items get processed.
organization_id
description
segment1
process_flag
transaction_type 'CREATE'
set_process_id
Note: DON'T POPULATE inventory_item_id or any Derived Columns.
IOI TABLES
1) mtl_system_items_interface
2) mtl_interface_errors
3) mtl_item_revisions_interface
4) mtl_item_categories_interface
......Used internally by IOI and should not
be populated (see list below)
Before loading items, check and truncate tables (1) (2) (3) & (4)
Before loading items into child, check and truncate tables (2) (3)
& (4)
SCRIPTS
invioia1.sql---------------script to add new
set_process_id
columns
inviois1.sql-------------script to add new SRS parameter
invioier.sql---- $INV_TOP/admin/sql---- shows compilation errors for
IOI
packages
invioiru.sql----$INV_TOP/sql---------runs IOI from sql+ commandline
processes all records for
all orgs in
mtl_system_items_interface
Frequently Asked Question.
FAQ#1: What is INCOIN ?
INCOIN is a concurrent program, written in C and Pro C, which processes
rows from the MTL_SYSTEM_ITEMS_INTERFACE
table into the primary tables within Oracle Inventory.
FAQ#2: How do I run IOI thru SQL+
Script invioiru.sql could be run from the SQL prompt.
It kicks off IOI by running the main IOI procedure
INVPOPIF.inopinp_open_interface_process.
FAQ#3: What is the main IOI procedure ?
INVPOPIF is the main package used to validate, default, assign, process
and delete IOI items.
The following are the arguments used by the function
inopinp_open_interface_process:
org_id------(organization_id)
all_org-----(3D1, process all orgs.)
------------(3D2, process current org.)
val_item_flag (3D1, validate items, 23Ddon't validate)
pro_item_flag (process validated items. If not validated before, don't
process)
del_rec_flag---(delete processed rows)
prog_appid (program application_id)
prog_id (program_id)
request_id (request_id)
user_id (user_id)
login_id (login_id)
err_text
FAQ#5: How to process failed rows ?
IOI uses process_flag3D1 (Pending) to process failed rows from MSII
table.
The following table shows the different statuses for this flag.
Process_Flag
-------------- Meaning
1-------Pending/Waiting to be processed
2-------Assign complete
3-------Assign/Validation failed
4-------Validation succeeded, import failed
5,6------(Used internally)
7-------Import succeeded.
To process failed rows i.e. errored rows with process_flag 2 or 3
Resolve any errors reported in the mtl_interface_errors table, or
other error types
Truncate interface tables
Reset the process_flag to 120
Run IOI
FAQ#6: How to check for errors if process dies with process_flag 4
Check Extents, Size of Rollback Segments, Table Size, Indexes...
Check for errors in alert log
IOI Process dies with process_flag 4
Analyze results from the following query along with similar queries for
indexes and rollback segments.
3D} select segment_name, segment_type, tablespace_name
from sys.dba_segments where segment_name like 'MTL_SYSTEM_ITEMS';
3D} select FILE_ID, BLOCK_ID, BLOCKS, BYTES
from sys.dba_free_space where tablespace_name 3D 'TBSNAME';
3D} SELECT FILE_ID, BLOCK_ID, BLOCKS, BYTES FROM
DBA_FREE_SPACE
WHERE TABLESPACE_NAME'users'
ORDER BY BLOCK_ID;
3D} SELECT MAX(BLOCKS) FROM SYS.DBA_FREE_SPACE
WHERE TABLESPACE_NAME'name';
3D} SELECT SUM(BLOCKS) FROM SYS.DBA_FREE_SPACE
WHERE TABLESPACE_NAME'name';
Importing Item Costs...
You can import item costs when you run the item interface for the first
time.
Updates are not allowed at this point i.e. if you load items and then
want to
update item costs; that's not currently allowed. Its a future
enhancement.
Cost columns in msii...
MATERIAL_COST------------NUMBER,
MATERIAL_SUB_ELEM--------VARCHAR2(10),
MATERIAL_OH_RATE---------NUMBER,
MATERIAL_OH_SUB_ELEM-----VARCHAR2(10),
MATERIAL_SUB_ELEM_ID-----NUMBER
FAQ#10: Cannot load items into child org (master loaded) ?
Check the Item Attribute Controls for the child items and ensure that
they don't have any item level controls when running item import.
Sent: Friday, April 30, 1999 2:40 PM
Subject: INV: pending transactions
Does anyone know how to proceed the pending transaction at
inventory
module
transaction type : WIP component issue
transaction mode: Background processing
Process flag : 3
Error code : APP-05372 Transaction processor error
Error explanation: None
Oracle AP version is 10.7
Richard
Sent: Monday, May 03, 1999 3:47 PM
Subject: RE: pending transactions
I have solved this issue today.
The cause comes from another transaction error :
APP-05518 Negative balances not allowed,
after I asked user to replenish the on hand quantity for such
material.
All pending transactions are disappeared
But now, I raise another question,
The negative balance for all inventory are not allowed. and we
set it at the
inventory organization.
Why such setup cannot force error when user saved the
transaction before ?
The on hand/available qty cannot be trusted if system have
pending
transactions.
Checking and removing them are too late for us.
Thanks for your reply.
Richard
Sent: Monday, May 03, 1999 5:25 PM
Subject: RE: pending transactions
Hi Richard
There is a patch for that. But I do not remember that patch number. We
also had same problem.
Regards/Nagamohan
From: "221 Liu, Richard" richliu@ctxopto.com.tw
Subject: RE: pending transactions
Thank you Nagamohan,
Is the patch number 548294(WIP) or 624000(OE) ?
Oracle said we should apply both patches.
But both patches have been applied on Feb.2th this year.
regards, richard