oracle 盘点有无interface 或API ?

wilson1966

Dear All:
请问oracle 盘点有无interface 或API 可大量汇入,本司料号5万多笔,实没有办法一笔一笔打

tianpan

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

tianpan

Cycle Count Interface Table - MTL_CC_ENTRIES_INTERFACE
http://blog.csdn.net/pan_tian/article/details/7710098

wilson1966

谢谢楼上的朋友分享资料

grasssoul

互相帮助啊，共同进步

wilson1966

google 一下,发觉好像没有这方面的范例,奇怪,难道大家都没有在盘点?

wilson1966

ding 一下