interfaces

[annadasahoo]

hi

can anybody tell what r the important APIs and interfaces in purchasing and inventory

[anu_uma]

<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">

[annadasahoo]

Hi,
Thanks

Plaese tell me what are the interface tables related to these .
And after loading data to interface tables what should we do in each interfaces?
pls help me

[annadasahoo]

i want to know after loading the data to interface tables how we uses the interface APIs or how we run that interface.
pls tell me about all the interfaces you hv specified above

[anu_uma]

Hi,
Only technical people can give the answer to this. better post the same query in technical forum

[ahmadbilal]

[quote]hi

can anybody tell what r the important APIs and interfaces in purchasing and inventory

<i><div align="right">Originally posted by annadasahoo

[anuprpandit]

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:

[hunter_uday]

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

[sai_apps]

hi friends,,,,,

can anyone of u post some documents related to API'S and their usage