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

["Vijay Srinivasan" <vijay.ebs@googlemail.com>]

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>