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

["Mcpeak, Matthew" <vxsmimmcp@SUBARU.com>]

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