Home » Applications » Oracle Fusion Apps & E-Business Suite » Interface Trip Stop problem (EBS 11.5.7, HPUX)
icon12.gif  Interface Trip Stop problem [message #322340] Fri, 23 May 2008 03:14 Go to next message
alson
Messages: 41
Registered: October 2007
Location: -
Member

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 #326257 is a reply to message #322340] Tue, 10 June 2008 22:01 Go to previous messageGo to next message
alson
Messages: 41
Registered: October 2007
Location: -
Member

how can no one reply ?
Re: Interface Trip Stop problem [message #326603 is a reply to message #326257] Thu, 12 June 2008 01:59 Go to previous messageGo to next message
shakti_goyal
Messages: 60
Registered: November 2006
Location: India
Member

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 Go to previous messageGo to next message
alson
Messages: 41
Registered: October 2007
Location: -
Member

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 1035 times)
Difference b/w SCM and CRM [message #328386 is a reply to message #322340] Fri, 20 June 2008 00:42 Go to previous message
Naresh.Y
Messages: 2
Registered: June 2008
Junior Member
Hi friends,
please sendd me differnce b/w SCM and CRM..
Previous Topic: Oracle AP IPV calculation
Next Topic: Oracle Newbie
Goto Forum:
  


Current Time: Wed Dec 07 10:50:12 CST 2016

Total time taken to generate the page: 0.10543 seconds