[OAUGNet]-Re: Complete Job and Assign Serial Nos thu API/Interface

["Ramon Huerta Rivera" <rhuerta@gmx.de>]

To achieve a fully automated interfaced process you have to do a 2-step approach;

1)Populate table WIP_MOVE_TXN_INTERFACE with TRANSACTION_TYPE = 1 (Move) and call WIP Move Tx Manager 
2)Populate table MTL_TRANSACTIONS_INTERFACE with TRANSACTION_TYPE_ID = 44 (WIP Assy Completion) and then run INV Tx Manager

Regards,
Ramon


-------- Original-Nachricht --------
> Datum: Tue, 2 Sep 2008 09:54:55 -0400
> Von: "Mcpeak, Matthew" <vxsmimmcp@SUBARU.com>
> An: "OAUG Net listserver" <OAUGNet@oaug.com>
> Betreff: [OAUGNet]-Re: Complete Job and Assign Serial Nos thu API/Interface

> >> I think job serial completion API is available through inventory
> interface only in R12
> 
> No, you can do S/N completions in 11.5.10.2.  Populate the
> mtl_transactions_interface table and the mtl_serial_numbers_interface
> table.
> 
> After populating the interface tables, you can process them immediately
> and synchronously (i.e., an online API) by calling
> INV_TXN_MANAGER_PUB.PROCESS_TRANSACTIONS.  Or you can process them in
> the background via concurrent request (i.e., inventory transaction
> worker).
> 
> Best regards,
> Matt
> 
> mcpeakm@tempus-consulting-group.com
> 
> 
> 
> 
> -----Original Message-----
> From: OAUG Net listserver [mailto:OAUGNet@oaug.com] On Behalf Of Vijay
> Srinivasan
> Sent: Sunday, August 31, 2008 6:15 PM
> To: OAUG Net listserver
> Subject: [OAUGNet]-Re: Complete Job and Assign Serial Nos thu
> API/Interface
> 
> Hi Eric,
> 
> Paul has suggested to try the Inventory Interface tables. I tried to
> complete a quantity of 1 serial from a Job moved to the to move of the
> last operation (moved using front end). I then passed entries in MTL -
> transactions interface, lots interface and serials interface. The
> quantity of one got completed in Oracle and the serial numbers were then
> available in stock. The following is the entries that I used (The Job No
> is 509). I think job serial completion API is available through
> inventory interface only in R12. But is is not available through the WIP
> interface (move and complete option). Any comments?
> 
> Regards,
> Vijay
> 
> mtl_transactions_interface:	
> TRANSACTION_INTERFACE_ID	1
> SOURCE_CODE	DB Test
> SOURCE_LINE_ID	1
> SOURCE_HEADER_ID	1
> PROCESS_FLAG	1
> TRANSACTION_MODE	3
> INVENTORY_ITEM_ID	12121
> ORGANIZATION_ID	85
> TRANSACTION_QUANTITY	1
> TRANSACTION_UOM	Ea
> TRANSACTION_DATE	28/08/2008 11:00
> SUBINVENTORY_CODE	XYZ DP
> TRANSACTION_SOURCE_ID	
> DSP_SEGMENT1	509
> TRANSACTION_SOURCE_NAME	509
> TRANSACTION_TYPE_ID	44
> WIP_ENTITY_TYPE	1
> FINAL_COMPLETION_FLAG	N
> 	
> 	
> mtl_transaction_lots_interface:	
> TRANSACTION_INTERFACE_ID	1
> SOURCE_CODE	DB Test Source code
> SOURCE_LINE_ID	1
> LOT_NUMBER	509
> TRANSACTION_QUANTITY	1
> SERIAL_TRANSACTION_TEMP_ID	10
> ERROR_CODE	
> PROCESS_FLAG	1
> 	
> 	
> mtl_serial_NUMBERS_interface	
> TRANSACTION_INTERFACE_ID	10
> SOURCE_CODE	DB Test serial source
> SOURCE_LINE_ID	1
> FM_SERIAL_NUMBER	Iface_compl_test101
> TO_SERIAL_NUMBER	Iface_compl_test101
> PROCESS_FLAG	1
> 
> 
> On Sun, Aug 31, 2008 at 2:52 PM, Eric <ericthered732@yahoo.com> wrote:
> > Hi, Vijay.
> >
> > We are still on EBS 11i (11.5.10.2).  I am not sure about the complete
> job/assign serial number API in 11.5.10.2 for WIP jobs.  But I know that
> there's an API for Work Order-less Completions in 11.5.10.2 and R12 that
> essentially does the same thing.
> >
> > Note: Work Order-less Completions are job-less transactions in WIP,
> but they auto-create a WIP job, or schedule number, in the WIP tables
> just like a discrete WIP job.
> >
> > So keep researching.  Hopefully, someone else will reply to you with
> the specific API(s).
> >
> > I've blind-copied my former API developer in case she knows the API
> off-hand.
> >
> > Best regards,
> >
> > Eric
> >
> >
> > -------------------
> > Date: Sat, 30 Aug 2008 14:58:01 +0100
> > From: "Vijay Srinivasan" <vijay.ebs@googlemail.com>
> > Subject: Complete Job &Assign Serial Nos thu API/Interface
> >
> > Hi,
> >
> > We have a requirement where we need to interface from external system,
> 
> > the job completion transaction and associate serial numbers during 
> > completion. Serial control of item is set at 'At Receipt'. When I try 
> > to pass a transaction in WIP_MOVE_TXN_INTERFACE with transaction_type 
> > as 2 (move and completion) and populate the serial number in 
> > WIP_SERIAL_MOVE_INTERFACE (linked by transaction_id), I get the error 
> > message -
> >
> > "Assembly is under serial number control, no completion transactions 
> > allowed from the Move Interface table".
> >
> > Are serial completions not supported through API  in R12 or is this a
> bug?
> > Am I using the wrong interface/API?
> > Has anybody faced this requirement before?
> > Any suggestions on workarounds/possible solutions?
> >
> > Thanks in advance!
> >
> > (below are theentries in the two interface tables after they were 
> > errored with the error message - "Assembly is under serial number 
> > control, no completion transactions allowed from the Move Interface 
> > table"
> >
> > Regards,
> > Vijay
> >
> >
> >
> >
> >
> >
> > #############################################################
> > This message is sent to you because you are subscribed to the mailing
> list <OAUGNet@oaug.com>.
> > To unsubscribe, E-mail to: <OAUGNet-off@oaug.com> To switch to the 
> > FEED mode, send any message to <OAUGNet-feed@oaug.com> To switch to 
> > the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com> To switch to the 
> > INDEX mode, E-mail to <OAUGNet-index@oaug.com> Send administrative 
> > queries to  <OAUGNet-request@oaug.com>
> >
> >
> 
> #############################################################
> This message is sent to you because you are subscribed to the mailing
> list <OAUGNet@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNet-off@oaug.com> To switch to the FEED
> mode, send any message to <OAUGNet-feed@oaug.com> To switch to the
> DIGEST mode, E-mail to <OAUGNet-digest@oaug.com> To switch to the INDEX
> mode, E-mail to <OAUGNet-index@oaug.com> Send administrative queries to
> <OAUGNet-request@oaug.com>
> 
> 
> 
> #############################################################
> This message is sent to you because you are subscribed to the mailing list
> <OAUGNet@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
> To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
> To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
> To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
> Send administrative queries to  <OAUGNet-request@oaug.com>

-- 
Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten 
Browser-Versionen downloaden: http://www.gmx.net/de/go/browser

#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNet@oaug.com>.
To unsubscribe, E-mail to: <OAUGNet-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNet-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNet-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNet-index@oaug.com>
Send administrative queries to  <OAUGNet-request@oaug.com>