Oracle E-business Suite--实施与维护经验谈

取消销售订单保留

销售订单保留通常可以通过Oracle EBS标准功能中的取消保留来实现！但有时一些业务导致标准功能无法处理，这时我们可以使用一些非常规的解决方案来解决，具体Solution如下：删除销售订单保留

---第一次备份数据-----------------------------------------------------
create table MTL_RESERVATIONS_BAK as
select * From
MTL_RESERVATIONS MR
where MR.reservation_id=7718
and organization_id=87

--如果之前有建立备份的Table,则采用以下SQL备份---------------------------------------------------------

insert into MTL_RESERVATIONS_BAK
select * From
MTL_RESERVATIONS MR
where MR.reservation_id=7718
and organization_id=87

commit

---检查是否备份成功-----------------------------------------------------------
select * from MTL_RESERVATIONS_BAK MRB
where MRB.reservation_id=7718
and MRB.organization_id=87


---备分成功后在删除要取消的销售订单保留-------------------------------------------------------------
Delete from MTL_RESERVATIONS MR
where MR.reservation_id=7718
and MR.organization_id=87


commit

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/45641/viewspace-925054/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/45641/viewspace-925054/