Purge function background data analysis for cycle count (periodic counting) in EBS

Source: Internet
Author: User
Purge function background data analysis for cycle count (periodic counting) in EBS
EBS, we can purge ABC assignment group,abc compiles and cycle count at the corresponding interface

And according to the interface hint, if want to purge ABC compiles, must first purge ABC assignment Group; If you want to purge ABC assignment Group, you must first purge cycle count;


When purge collects the corresponding SQL TRACE, you can find
1. When purge cycle count, we will delete the corresponding data from the table below
A. If you only purge historical data, the data will be deleted from the table below based on the selected date
Mtl_cc_schedule_requests--cycle Count SCHEDULE requests (planned cycle count request)
Mtl_cc_sched_count_xrefs--cycle COUNT and scheduled request for connection input
Mtl_cc_serial_numbers--Used to record serial numbers in an inventory
Mtl_cycle_count_entries--Counting entries for recording the results of actual counts
B. If it is completely purge, the data will be deleted from the tables below, but note that if there is a corresponding cycle count adjustment occurring, then the Inventory transaction table (Mtl_material_transactions MMT) has data, then Mtl_abc_compile_ HEADERS data is not deleted, which means that the corresponding cycle count is not completely deleted or purge.

Mtl_cc_schedule_requests--cycle Count SCHEDULE requests (planned cycle count request)
Mtl_cc_sched_count_xrefs--cycle COUNT and scheduled request for connection input
Mtl_cc_serial_numbers--Used to record serial numbers in an inventory
Mtl_cycle_count_entries--Counting entries for recording the results of actual counts
Mtl_cycle_count_items-For a specified count, record all the item that matches the count.
Mtl_cycle_count_classes--Record Counting classification information
Mtl_cc_subinventories--The subinvneotry to be counted as defined in the record count

Mtl_cc_entries_interface--Interface table for counting entries

Mtl_cycle_count_headers--Information related to the inventory definition

2. When purge ABC Assignment group, purge will check if there is a corresponding cycle count using this ABC distribution group, if there is, you can not purge; if not, the corresponding data will be deleted from the table below.
Mtl_abc_assignments--Record item to ABC class and ABC Group assignment information
Mtl_abc_assgn_group_classes--Record The distribution information of ABC class to ABC GROUP
Mtl_abc_assignment_groups--Record the definition information of ABC Group
3. When purge ABC compiles, purge will check whether there is a corresponding ABC distribution group using the ABC system, if there is, it can not purge; if not, the corresponding data will be deleted from the table below.
Mtl_abc_compiles--store information for each item in compile

Mtl_abc_compile_headers--Store Complle definition information


When purge ABC distribution group, if it is because cycle count is using this allocation group, and this cycle count has been adjusted to generate, then we cannot purge cycle count, we must change/empty the allocation group on cycle count , so that when purge the ABC distribution group, it is not checked to have a cycle count that uses this allocation group.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.