Home » Applications » Oracle Fusion Apps & E-Business Suite » Onhand Quantity import
Onhand Quantity import [message #240944] Mon, 28 May 2007 00:20 Go to next message
kdurgareddy
Messages: 20
Registered: February 2007
Location: india
Junior Member

Hi all,


Please anybobdy send me coding for Onhaand Quantity import.
I have to do it in 3 days.Please forword me .


Thanks in advance .
regards,
Durga Reddy
Re: Onhand Quantity import [message #241139 is a reply to message #240944] Mon, 28 May 2007 08:04 Go to previous messageGo to next message
prashant_pathak
Messages: 263
Registered: February 2006
Location: California,US
Senior Member
Following tables are used for Open Transaction Interface which bring Inventory from External System

Transaction

MTL_TRANSACTIONS_INTERFACE
MTL_TRANSACTION_LOTS_INTERFACE for Item under lot control
MTL_SERIAL_NUMBERS_INTERFACE for Item under Serial Control
CST_COMP_SNAP_INTERFACE for WIP job transaction
 SOURCE_CODE
 SOURCE_LINE_ID
 SOURCE_HEADER_ID
 PROCESS_FLAG
 TRANSACTION_MODE
 TRANSACTION_INTERFACE_ID
This column is required for transactions of items under lot or serial control. The
value in the column in this table is used to identify the child rows in the lot or serial
interface tables MTL_TRANSACTION_LOTS_INTERFACE and MTL_SERIAL_
NUMBERS_INTERFACE.
If the transacted item is under lot control, this column maps to MTL_
TRANSACTION_LOTS_INTERFACE.
TRANSACTION_INTERFACE_ID. If the transacted item is under serial control and
not lot control, this column maps to MTL_SERIAL_NUMBERS_INTERFACE.
TRANSACTION_INTERFACE_ID.

always look here so that you have some idea of that perticular interface and by reading document in detail you can easily try the interface and can do it yourself

Regards
Prashant Pathak
Re: Onhand Quantity import [message #241246 is a reply to message #241139] Mon, 28 May 2007 23:56 Go to previous messageGo to next message
kdurgareddy
Messages: 20
Registered: February 2007
Location: india
Junior Member

Thank you Prashanth,

One more query is actually from begining I was in Reports.This is the first time I am going to develope the Conversions.

Actually I dont no which are the mandatory columns for this Inrterface like process flag and some more .Please forword me any document to give more details .


Thanking you.

Regards,
Durga Reddy.
Re: Onhand Quantity import [message #347224 is a reply to message #241246] Thu, 11 September 2008 02:11 Go to previous message
ashokt
Messages: 7
Registered: August 2008
Junior Member
Hi All,

anyone tell then mondatory column for onhand quantity interface

thanks in advance

ashok.
Previous Topic: SHORT ENTITY IN MULTI ORG
Next Topic: O 2 C CYCLE RELATED ENTRIES
Goto Forum:
  


Current Time: Fri Dec 09 15:44:12 CST 2016

Total time taken to generate the page: 0.14685 seconds