OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Onhand Quantity import

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Onhand Quantity import [message #240944]

Mon, 28 May 2007 00:20

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

Report message to a moderator

Re: Onhand Quantity import [message #241139 is a reply to message #240944]

Mon, 28 May 2007 08:04

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

Report message to a moderator

Re: Onhand Quantity import [message #241246 is a reply to message #241139]

Mon, 28 May 2007 23:56

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.

Report message to a moderator

Re: Onhand Quantity import [message #347224 is a reply to message #241246]

Thu, 11 September 2008 02:11

ashokt
Messages: 7
Registered: August 2008

Junior Member

Hi All,

anyone tell then mondatory column for onhand quantity interface

thanks in advance

ashok.

Report message to a moderator

Previous Topic:	SHORT ENTITY IN MULTI ORG
Next Topic:	O 2 C CYCLE RELATED ENTRIES

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 14 17:36:55 CDT 2025