R12-销售订单booked行上的税码被置空问题 OEXOEORD: Tax Code Gets Re-Defaulted After Booking Order (文档 ID 731485.1)

最新推荐文章于 2024-03-30 12:57:15 发布

kikiwhq

最新推荐文章于 2024-03-30 12:57:15 发布

阅读量690

点赞数

分类专栏： OM 文章标签： OM

OM 专栏收录该内容

32 篇文章 1 订阅

订阅专栏

摘自：https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=437487006658384&id=731485.1&_adf.ctrl-state=i8pkgzr0k_9

问题：SO book后，line上的tax code自动清空了，然后手动再指定tax code是OK的。

处理：修改PKG-OE_Dependencies_Extn实现

OEXOEORD: Tax Code Gets Re-Defaulted After Booking Order (文档 ID 731485.1)

In this Document

APPLIES TO:

Oracle Order Management - Version 11.5.10.2 to 12.2.4 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 17-Dec-2013***

SYMPTOMS

When enter a new sales order the system default tax code is X. If user change the tax code to Y
and book the order, the tax code is changed back to X. This is happening even if user save the
record before doing the initial change.

Same issue can also occur when the scheduling is happening at time of saving the order if autoschedule is used.

CAUSE

This is the standard functionality of the system.

What is happening here is explained below :

1. Create an Order and Line. Tax Date and Tax Code get defaulted to the Order Line. Line is saved.
Right now Schedule Ship Date is blank, hence scheduling is not triggered. Tax calculation happens
based on the defaulted Tax Code.

2. Change the Tax Code to the desired one. Saves the Line. Tax gets re-calculated based on the
changed Tax Code.

3. Books the Order. Order is Booked successfully.

4. As part of the Booking process itself, before the control returns back to the user, the next
activity in the WF gets triggered. Since Scheduling is the next activity on the Line, line gets
scheduled. A new Schedule Ship Date is returned and updated on the Order Line.

Please note that as part of the standard order processing and defaulting frame work, when ever any
attribute value changes, system always clears the dependent attributes and re-defaults them.

Now since, scheduling resulted in change of Schedule Ship Date, the dependent attributes of
Schedule Ship Date are cleared. As per the seeded dependency Tax Date is dependent on Schedule
Ship Date. Hence Tax Date is cleared and re-defaulted. Again, Tax Code is dependent on Tax Date.
Hence, Tax Code is cleared and re-defaulted.

That is why you see that whenever you Book an Order, Tax Code is getting re-defaulted back to
original value.

SOLUTION

You can avoid this issue in the following ways:

1. Change the Tax Code only after the Line is scheduled. But with this approach, when ever
Schedule Ship Date changes, Tax Code will get re-defaulted.

or

2. Disable the seeded dependency between Schedule Ship Date and Tax Date. This you can do by
adding code in OE_DEPENDENCIES_EXTN package. Below code can be used to do the same :

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