 Interface Trip Stop problem [message #322340] |
Fri, 23 May 2008 03:14  |
|
|
Dear Experts,
Please help me on this problem.
Interface Trip Stop completed with warning, the DO in the interface trip stop not go off.
symtoms :
SO line status = Awaiting Shipping, Shipping Status = Shipped, Invoice not created, and onhand stock not deducted. got other SO with the same Item no park in Transaction open Interface.
Workaround : Clear the Transaction open Interface , and then run interface trip stop but fail.
log file as shown below :
+---------------------------------------------------------------------------+
Oracle Shipping: Version : 11.5.0 - Development
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
WSHINTERFACES module: Interface Trip Stop - SRS
+---------------------------------------------------------------------------+
Current system time is 23-MAY-2008 14:27:38
+---------------------------------------------------------------------------+
**Starts**23-MAY-2008 14:27:38
**Ends**23-MAY-2008 14:27:41
Interface trip stop is completed with warning
+---------------------------------------------------------------------------+
Start of log messages from Plsql program
+---------------------------------------------------------------------------+
InterfaceTripStop: processing stop_id 20113 for INV OM DSNO
Checking for Lock on line 20497
Checking for Lock on line 20498
Process Order failed for order header_id 22359
no. of OE messages :0
Failed to interface header 22359 to Order Management because API interface_hea
der_to_OM failed
InterfaceTripStop: total stops processed: 1
Stops processed for ORDER MANAGEMENT with status NORMAL: 0
Stops processed for ORDER MANAGEMENT with status WARNING: 1
Stops already interfaced for ORDER MANAGEMENT: 0
+---------------------------------------------------------------------------+
End of log messages from PlSql program
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 23-MAY-2008 14:27:41
+---------------------------------------------------------------------------+
|
|
|
|
|
|
| Re: Interface Trip Stop problem [message #326603 is a reply to message #326257] |
Thu, 12 June 2008 01:59  |
|
|
Hi Alson,
you can check the following things,
-- There should not any lock exists on the line.
-- Check the Attriute of Items (eg if you are generating the
Excise Invoice then this Flag must be on and item should be
assign to the warehouse where you want to pick the material.)
-- Check Inventory Period should be open.
-- There should not exists any Pending Transaction (means check
that whether this record is stuck in
mtl_material_transaction_temp or not).
-- Check the Reservation Interface.
|
|
|
|
| Re: Interface Trip Stop problem [message #328361 is a reply to message #326603] |
Thu, 19 June 2008 20:44 |
|
|
hi shakti,
thanks for your advise and sorry for my late reply because I was busy on some other problem.
"There should not any lock exists on the line."
after I change the Sales Order Header and Line Status from closed to Booked and Awaiting Shipping respectively, The interface trip stop seems working better than previous time. I got different error now, please see the attached file. I have compare the account code for the part in the Sales Order Line in the Item Master -> Costing screen, it is start from
01-201-...., it was the correct account code, but in Interface Trip Stop log, it tell me "01-701-...., Cost of Goods Sold Account generation failed, please use the existing combination."
and this 01-701 does not exist in our Account Code.
My question is how do I change this wrong account code into the correct account code ?
please help , thanks
-
Attachment: l1133003.txt
(Size: 6.72KB, Downloaded 2640 times)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
