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.