interfaces
-
- Posts: 12
- Joined: Wed Feb 28, 2007 12:40 pm
- Location: India
interfaces
hi
can anybody tell what r the important APIs and interfaces in purchasing and inventory
can anybody tell what r the important APIs and interfaces in purchasing and inventory
<font color="blue">Hi ,
Interfaces in Oracle Inventory and Oracle Purchasing are
Given Below
<font color="blue"><b>Oracle Inventory</b></font id="blue">Oracle Inventory provides the following open interfaces:
? Customer Item Interface
? Open Item Interface
? Open Replenishment Interface
? Open Transaction Interface
? Cycle Count Open Interface
? Reservations Open Interface
? Move Orders Open Interface
<b>Oracle Purchasing</b>
Oracle Purchasing provides the following open interfaces:
? Requisitions Open Interface
? Purchasing Documents Open Interface
? Receiving Open Interface
For further more Details pls check the User Manuals.
TIA
</font id="blue">
Interfaces in Oracle Inventory and Oracle Purchasing are
Given Below
<font color="blue"><b>Oracle Inventory</b></font id="blue">Oracle Inventory provides the following open interfaces:
? Customer Item Interface
? Open Item Interface
? Open Replenishment Interface
? Open Transaction Interface
? Cycle Count Open Interface
? Reservations Open Interface
? Move Orders Open Interface
<b>Oracle Purchasing</b>
Oracle Purchasing provides the following open interfaces:
? Requisitions Open Interface
? Purchasing Documents Open Interface
? Receiving Open Interface
For further more Details pls check the User Manuals.
TIA
</font id="blue">
-
- Posts: 12
- Joined: Wed Feb 28, 2007 12:40 pm
- Location: India
-
- Posts: 12
- Joined: Wed Feb 28, 2007 12:40 pm
- Location: India
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
-
- Posts: 4
- Joined: Tue Nov 21, 2006 1:23 am
- Location: India
In inventory you may need to use the open interface concurrent program 'Item Import'. For purchasing you have to use the open interface' Import Standard Purchase Orders'. Based on items,revisions,categories,catalogs,price to be imported different interface tables need to be populated. Mentioning below some important details. Please let me know if there are any more queries.
A script enabled browser is required for this page to function properly.
Bookmarks Admin Profile Feedback Sign Out Help
Headlines Knowledge Service Request Configuration Support Manager Certify
Knowledge Browser Advanced Search Bug Search Secure Enterprise Search
Quick Find
All Sources Knowledge Base Knowledge Base (Including Archived Articles) Bug Database Technical Forums Document ID (Knowledge Base, Forum, or Bug) Service Request Number Error Code Patch Number Go
Secure Enterprise Search Advanced Saved Searches
Did this article help solve your problem? Select Yes No Does Not Apply Would you recommend this document to others? Select Yes No Not Sure
TIP: Click help for a detailed explanation of this page.
Bookmark Go to End
Subject: Item Open Interface Setup and How-To
Doc ID: Note:115557.1 Type: BULLETIN
Last Revision Date: 05-FEB-2004 Status: PUBLISHED
Item Open Interface Setup & How-To
Purpose:
-------------
Documentation of the setup and usage of the Item Open Import (IOI) process
for the import of items.
Scope & Application:
----------------------------
This document can be used as a supplement to load item data through the
Open Interface.
Contents:
--------------------------
Setup
How-To
Running the Item Open Interface In Create Mode
Running the Item Open Interface In Update Mode
Updating Item Attributes to NULL
Importing Master and Child Records
Revisions
Template Use
Setup
============================================================
Follow this checklist before attempting to load items via the Item Open
Interface:
a) If any IOI patches have been applied, verify that there are no invalid
packages.
To find invalid objects, run the following:
SELECT owner, object_type, object_name
FROM dba_objects
WHERE status = 'INVALID'
b) Insure that INCOIN has been relinked if any IOI patches were applied.
adrelink sample command lines to relink aiap:
'adrelink force=y ranlib=y "fnd aiap"'
c) Check that the standard indexes exist on the mtl_system_items (
mtl_system_items_b in Release 11.5) and mtl_system_items_interface tables.
(Select table_name, index_name
From all_indexes
Where table_name in (''MTL-SYSTEM_ITEMS', 'MTL_SYSTEM_ITEMS_INTERFACE',
'MTL_SYSTEMS_ITEMS_B')
Order by table_name, index_name; )
The standard indexes for Release 11.0.3 are as follows:
mtl_system_items_interface_n1
mtl_system_items_interface_n2
mtl_system_items_interface_u1
mtl_system_items_n1
mtl_system_items_n2
mtl_system_items_n3
mtl_system_items_n4
mtl_system_items_n5
mtl_system_items_n6
The standard indexes for Release 11.5 are as follows:
mtl_system_items_interface_ n1
mtl_system_items_interface_n2
mtl_system_items_interface_n3
mtl_system_items_interface_u1
mtl_system_items_ b_n1
mtl_system_items_ b_n2
mtl_system_items_ b_n3
mtl_system_items_ b_n4
mtl_system_items_ b_n5
mtl_system_items_ b_n6
mtl_system_items_ b_n7
mtl_system_items_ b_u1
d) Check if the internal and standard concurrent managers are up and running
before loading items (system admin resp/concurrent/manager/administer)
Check the actual and target processes, the numbers should be the same
for each.
e) Define an item through the Define Item form. If this does not work,
then it is unlikely that items will load through the interface.
ex. inventory responsibility/items/master items Enter item name,
description and attributes needed and save the item.
f) Truncate all IOI interface tables before loading mtl_system_items_interface:
ex. TRUNCATE TABLE <tablename>
MTL_SYSTEM_ITEMS_INTERFACE
MTL_INTERFACE_ERRORS
MTL_ITEM_REVISIONS_INTERFACE
MTL_ITEM_CATEGORIES_INTERFACE
Note:
======
If Purchasing is fully installed but Inventory is only a shared product,
users should be able to run the IOI. You should, however, be aware that the
IOI code is not shipped with standalone Purchasing. You will have to obtain
the code by downloading the latest IOI megapatches.
How-To
========
Running the Item Open Interface In Create Mode
Populate the mtl_system_items_interface with the following minimum required
columns when creating new items:
PROCESS_FLAG = 1
TRANSACTION_TYPE = 'CREATE'
SET_PROCESS_ID = 1
ORGANIZATION_ID = Master Org id.
DESCRIPTION = 'Description of the item'
ITEM_NUMBER and/or SEGMENT(n)
Running the Item Open Interface In Update Mode
To update existing item(s), set TRANSACTION_TYPE = 'UPDATE'.
Creating and updating items in a single run of the Item Open Interface is not
supported functionality.
For best performance, use inventory_item_id when updating items.
Functionality
Every attribute updateable from the Item form is updateable through the
interface, and all required validations are performed to enforce:
A script enabled browser is required for this page to function properly.
Bookmarks Admin Profile Feedback Sign Out Help
Headlines Knowledge Service Request Configuration Support Manager Certify
Knowledge Browser Advanced Search Bug Search Secure Enterprise Search
Quick Find
All Sources Knowledge Base Knowledge Base (Including Archived Articles) Bug Database Technical Forums Document ID (Knowledge Base, Forum, or Bug) Service Request Number Error Code Patch Number Go
Secure Enterprise Search Advanced Saved Searches
Did this article help solve your problem? Select Yes No Does Not Apply Would you recommend this document to others? Select Yes No Not Sure
TIP: Click help for a detailed explanation of this page.
Bookmark Go to End
Subject: Item Open Interface Setup and How-To
Doc ID: Note:115557.1 Type: BULLETIN
Last Revision Date: 05-FEB-2004 Status: PUBLISHED
Item Open Interface Setup & How-To
Purpose:
-------------
Documentation of the setup and usage of the Item Open Import (IOI) process
for the import of items.
Scope & Application:
----------------------------
This document can be used as a supplement to load item data through the
Open Interface.
Contents:
--------------------------
Setup
How-To
Running the Item Open Interface In Create Mode
Running the Item Open Interface In Update Mode
Updating Item Attributes to NULL
Importing Master and Child Records
Revisions
Template Use
Setup
============================================================
Follow this checklist before attempting to load items via the Item Open
Interface:
a) If any IOI patches have been applied, verify that there are no invalid
packages.
To find invalid objects, run the following:
SELECT owner, object_type, object_name
FROM dba_objects
WHERE status = 'INVALID'
b) Insure that INCOIN has been relinked if any IOI patches were applied.
adrelink sample command lines to relink aiap:
'adrelink force=y ranlib=y "fnd aiap"'
c) Check that the standard indexes exist on the mtl_system_items (
mtl_system_items_b in Release 11.5) and mtl_system_items_interface tables.
(Select table_name, index_name
From all_indexes
Where table_name in (''MTL-SYSTEM_ITEMS', 'MTL_SYSTEM_ITEMS_INTERFACE',
'MTL_SYSTEMS_ITEMS_B')
Order by table_name, index_name; )
The standard indexes for Release 11.0.3 are as follows:
mtl_system_items_interface_n1
mtl_system_items_interface_n2
mtl_system_items_interface_u1
mtl_system_items_n1
mtl_system_items_n2
mtl_system_items_n3
mtl_system_items_n4
mtl_system_items_n5
mtl_system_items_n6
The standard indexes for Release 11.5 are as follows:
mtl_system_items_interface_ n1
mtl_system_items_interface_n2
mtl_system_items_interface_n3
mtl_system_items_interface_u1
mtl_system_items_ b_n1
mtl_system_items_ b_n2
mtl_system_items_ b_n3
mtl_system_items_ b_n4
mtl_system_items_ b_n5
mtl_system_items_ b_n6
mtl_system_items_ b_n7
mtl_system_items_ b_u1
d) Check if the internal and standard concurrent managers are up and running
before loading items (system admin resp/concurrent/manager/administer)
Check the actual and target processes, the numbers should be the same
for each.
e) Define an item through the Define Item form. If this does not work,
then it is unlikely that items will load through the interface.
ex. inventory responsibility/items/master items Enter item name,
description and attributes needed and save the item.
f) Truncate all IOI interface tables before loading mtl_system_items_interface:
ex. TRUNCATE TABLE <tablename>
MTL_SYSTEM_ITEMS_INTERFACE
MTL_INTERFACE_ERRORS
MTL_ITEM_REVISIONS_INTERFACE
MTL_ITEM_CATEGORIES_INTERFACE
Note:
======
If Purchasing is fully installed but Inventory is only a shared product,
users should be able to run the IOI. You should, however, be aware that the
IOI code is not shipped with standalone Purchasing. You will have to obtain
the code by downloading the latest IOI megapatches.
How-To
========
Running the Item Open Interface In Create Mode
Populate the mtl_system_items_interface with the following minimum required
columns when creating new items:
PROCESS_FLAG = 1
TRANSACTION_TYPE = 'CREATE'
SET_PROCESS_ID = 1
ORGANIZATION_ID = Master Org id.
DESCRIPTION = 'Description of the item'
ITEM_NUMBER and/or SEGMENT(n)
Running the Item Open Interface In Update Mode
To update existing item(s), set TRANSACTION_TYPE = 'UPDATE'.
Creating and updating items in a single run of the Item Open Interface is not
supported functionality.
For best performance, use inventory_item_id when updating items.
Functionality
Every attribute updateable from the Item form is updateable through the
interface, and all required validations are performed to enforce:
-
- Posts: 3
- Joined: Tue Oct 02, 2007 12:28 am
- Location: India
hi i vanna dovnload the apps 11i.
but i dont knov hov to dovnload that
they told in "sr" vindov ve can get..as patches
but i am not getting vhere that sr vindov vill be located
can u pls send me the link...
my id is:- udaykumar.apps@gmail.com
help me
pls
regards
uday
but i dont knov hov to dovnload that
they told in "sr" vindov ve can get..as patches
but i am not getting vhere that sr vindov vill be located
can u pls send me the link...
my id is:- udaykumar.apps@gmail.com
help me
pls
regards
uday
Who is online
Users browsing this forum: No registered users and 0 guests