Tax Code changed after booking order -- Trouble Shooting

http://forums.oracle.com/forums/thread.jspa?messageID=1938213�

業務人員操作時碰到問題
當Customer A的Bill to預設TAX CODE為TAX0
打單時會預帶出TAX0
而某些時候因需求改為TAX5
存檔時都很正常
但Book後卻自動變為TAX0
當沒注意時
就會造成訂單的錯誤

這個問題透過Ketter Ohnes與Daniel Borgstrom的協助
發現Note 359606.1有建議的解決方式
(看來不是bug..而是需要額外設定的東西...詳細請看Note 359606.1)

修改$ONT_TOP/patch/115/sql/OEXEDEPB.pls的程式似乎沒有用
但直接修改 oe_dependencies_extn 這個package
則可以解決這個問題

CREATE OR REPLACE
PACKAGE BODY oe_dependencies_extn AS
/* $Header: OEXEDEPB.pls 115.5 2003/12/03 22:42:58 nlakshma ship $ */

-- Global constant holding the package name

G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Dependencies_Extn';


PROCEDURE Load_Entity_Attributes
( p_entity_code IN VARCHAR2
, x_extn_dep_tbl OUT NOCOPY Dep_Tbl_Type)

IS
l_index NUMBER;
--
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
--
BEGIN

null;
--==========================================================================
/*
* Please refer to : http://forums.oracle.com/forums/thread.jspa?messageID=1938213
* Ask and Trace by Zhxiang.. @20070706
*/
l_index := 1;

x_extn_dep_tbl(l_index).source_attribute := OE_LINE_UTIL.G_TAX_DATE;
x_extn_dep_tbl(l_index).dependent_attribute := OE_LINE_UTIL.G_TAX;
x_extn_dep_tbl(l_index).enabled_flag := 'N';
l_index := l_index + 1;
--==========================================================================

/*
-- In order to start using the package:
-- 1)Increase the version number in the header line to a high value
-- => Header: OEXEDEPB.pls 115.1000. This would prevent patches
-- from over-writing this package in the future.
-- 2)Included are some examples on how to enable/disable dependencies
-- Please use these guidelines to edit dependencies as per your
-- defaulting rules. Please note that:
-- i) List of attributes is restricted to those in the earlier
-- comments in this file.
-- ii) Source attribute and dependent attribute should belong
-- to the same entity!
-- This API does not support dependencies across entities i.e.
-- changing an attribute on order header will not result in
-- a change to attributes on order line.
-- 3)Uncomment this code and compile.

oe_debug_pub.add('Enter OE_Dependencies_Extn.LOAD_ENTITY_ATTRIBUTES', 1);

-- Initializing index value for pl/sql table. Ensure that the index
-- value is incremented after setting each dependency record.
l_index := 1;

-- Dependencies for Order Header Entity
IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN

null;

-- Sample Code for Disabling dependency of Invoice To on Ship To
-- x_extn_dep_tbl(l_index).source_attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
-- x_extn_dep_tbl(l_index).dependent_attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
-- x_extn_dep_tbl(l_index).enabled_flag := 'N';
-- l_index := l_index + 1;

-- Dependencies for Order Line Entity
ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN

null;

-- Sample Code for Disabling dependency of Invoice To on Ship To
-- x_extn_dep_tbl(l_index).source_attribute := OE_LINE_UTIL.G_SHIP_TO_ORG;
-- x_extn_dep_tbl(l_index).dependent_attribute := OE_LINE_UTIL.G_INVOICE_TO_ORG;
-- x_extn_dep_tbl(l_index).enabled_flag := 'N';
-- l_index := l_index + 1;

-- Sample Code for adding dependency of Source Type on Item
-- x_extn_dep_tbl(l_index).source_attribute := OE_LINE_UTIL.G_INVENTORY_ITEM;
-- x_extn_dep_tbl(l_index).dependent_attribute := OE_LINE_UTIL.G_SOURCE_TYPE;
-- x_extn_dep_tbl(l_index).enabled_flag := 'Y';
-- l_index := l_index + 1;

END IF;

oe_debug_pub.add('Exit OE_Dependencies_Extn.LOAD_ENTITY_ATTRIBUTES', 1);
*/

EXCEPTION
WHEN OTHERS THEN
IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
THEN
OE_MSG_PUB.Add_Exc_Msg
( G_PKG_NAME
, 'Load_Entity_Attributes'
);
END IF;
RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
END Load_Entity_Attributes;

END OE_Dependencies_Extn;
/

Awaiting Invoice Interface-On Hold -- Trouble Shooting

version 11.5.10.2

當Bill to的訂單被Hold
透過流程做完Release後
Line的Status有時會停在Awaiting Invoice Interface-On Hold

而並沒有資料拋到AR interface..

根據Metalink Doc: Note:398867.1
指出可以跑
Workflow Background Process
而Timeout要設為Yes..
這樣這支程式會將eligibe的部份再抓入重新進入流程
(就我的經驗...偶而會成功...偶而還是卡在這個狀態中)

不過..也可以找到這個line(在OM上)
直接按滑鼠右鍵
執行Progress Order的指令
就會往下一個流程推了...

無論如何
碰到這樣的狀況
兩個方法都試一下應該就可以了...

Trouble Shooting - Interface Trip Stop Completes With Error: Invalid Location

當User出貨後
做完Ship Confirm
往往認為這樣就操作結束了..
但部份的交易可能沒有那麼順利
會卡在Trip stop的interface中
例如ccid抓不到..或以下的狀況

Interface Trip Stop Completes With Error: Invalid Location

[LOG]
P_MESSAGE_TYPE ==> E

P_MODULE_NAME ==> wsh.plsql.WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV msg_buffer ==> Invalid location

E:Invalid location
Exiting WSH_UTIL_CORE.ADD_MESSAGE (05/07/2007 10:47:18 AM, 0 seconds) c_convert_locId%NOTFOUND ==> 599
Error at line ==> 14901

[SOLUTION]
Oracle MetaLink Note:312949.1

Step1: Run Concurrent Program "Import Shipping Locations"
(OM > Shipping > Interfaces > Run)
with parameters
* Map Regions: Yes
* Location Type: Both
* Other: Default
Step2: Retest this issue(Interface Trip-Stop).