Cycle Count Interface Table - MTL_CC_ENTRIES_INTERFACE

最新推荐文章于 2024-09-24 23:05:22 发布

田攀

最新推荐文章于 2024-09-24 23:05:22 发布

阅读量6k

点赞数

文章标签： interface table transactions oracle user

本文链接：https://blog.csdn.net/pan_tian/article/details/7710098

版权

MTL_CC_ENTRIES_INTERFACE 是用户与Oracle Inventory Enter/Approve Cycle Count Request 功能之间的接口。用户填充接口表，然后通过PL/SQL并发程序（由用户启动）处理表中的信息，插入/更新MTL_CYCLE_COUNT_ENTRIES表，并在必要时生成调整物料交易。

摘要由CSDN通过智能技术生成

The MTL_CC_ENTRIES_INTERFACE table serves as the interface between users and Oracle Inventory's Enter/Approve Cycle Count Request functionality. Users populate the interface table, and a PL/SQLconcurrent program, launched by the user, processes the information in this table, inserts/updates the MTL_CYCLE_COUNT_ENTRIES table, and spawns adjustment material transactions, if necessary.

Expected behavior
-----------------------
Cycle count open interface brings the counts in the count entries form and populating mtl_cycle_count_entries table with correct data.

Steps
-------------------------
Inventory responsibility>populate MTL_CC_ENTRIES_INTERFACE table with records to be imported>Request>run INVCCEOI - Cycle Count Entries Open Interface concurrent program>this will launch MTL_CCEOI_WORKER- Cycle Count Entries Open Interface Worker concurrent program>check the status of request and see it is error

Code Process: