Order Line closure workflow not inserting data in CRRL table.
Hi Team,
Issue: Order Line closure workflow not inserting data in CRRL table.
Once sales order line is closed, oracle workflow should insert data into COGS Revenue Recognition lines table for a Ship Only order
so that COGS can be recognized.
But we have observed that rows are not inserted into CRRL tables. Could you please help us diagnose the issue?
Please note that the item is invoiceable and the order line is shippable. We have checked Metalink for known issues and we feel the patches and solutions recommended
are not applicable to us.
We have also checked the wf_item_activity_statuses table for the order_line (item_key) and observed that activity_status is complete and end_date is populated with the date