GENERATE COGS RECOGNITION EVENTS NOT COMPLETING

SYMPTOMS


While  running the process "Generate COGS Recognition Events" from the OPM Financial Responsibility it is taking too much time. It is observed that the program is  running for more than 24 hours.



To implement the solution, please execute the following steps:

1. Ensure that you have taken a backup of your system before applying the recommended solution.

2. Run the following scripts in a TEST environment first:


Run the following steps before running the "Generate COGS recognition" which is usually done end of day with less production activities

shrink space for two tables mtl_transactions_interface and cst_revenue_cogs_match_lines.

Steps to shrink:

alter table inv.mtl_transactions_interface DEALLOCATE UNUSED;
alter table inv.mtl_transactions_interface ENABLE ROW MOVEMENT;
alter table inv.mtl_transactions_interface shrink space;
alter table inv.mtl_transactions_interface disable ROW MOVEMENT;

alter table bom.cst_revenue_cogs_match_lines DEALLOCATE UNUSED;
alter table bom.cst_revenue_cogs_match_lines ENABLE ROW MOVEMENT;
alter table bom.cst_revenue_cogs_match_lines shrink space;
alter table bom.cst_revenue_cogs_match_lines disable ROW MOVEMENT;

3. If you are satisfied with the results, issue a commit.

4. If you are satisfied that the issue is resolved, migrate the solution as appropriate to other environments.