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