ITPub博客

首页 > 数据库 > 数据库开发技术 > 处理待定数据

处理待定数据

原创 数据库开发技术 作者:rolleaway 时间:2006-06-15 08:42:06 0 删除 编辑

/*fact: Oracle Inventory 11.0.3
fact: INVTVTMP - View Pending Transactions
symptom: Unable to close inventory period
symptom: Resolution required for Unprocessed Material 4 each
cause: Flag settings would not allow the transaction manager to pick up the transactions.

fix: Run the following script in SQL*Plus to resubmit the records:*/

[@more@]

select mmtt.error_code,
mmtt.error_explanation,
mmtt.process_flag,
mmtt.lock_flag,
mmtt.transaction_mode,
mmtt.transaction_quantity,mmtt.*
from mtl_material_transactions_temp mmtt
where mmtt.inventory_item_id in (56780,55594)
and mmtt.organization_id = 84

update mtl_material_transactions_temp
set process_flag = 'Y',
lock_flag = 'N',
transaction_mode = 3,
error_code = NULL,
error_explanation = NULL
where process_flag in ('N','E');

/*After committing the update,
navigate to Inventory > Setup > Transactions
>Interface Managers > Special > Launch the Material Transaction Manager.
*/

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

请登录后发表评论 登录
全部评论

注册时间:2008-10-30

  • 博文量
    23
  • 访问量
    260702