Warranty Contract Creation from Order Management while upgrading to R12
We are upgrading from 11.5.9 to R 12.1.3As a part of the post upgrade steps I am trying to transfer data pending in ASO queue to OKS_REPROCESSING table for warranty creation
I ran the below script to identify number records ready for warranty creation
select consumer_name, msg_state, count(*) from aso.aq$aso_order_feedback_t group by consumer_name, msg_state;
The scripts tells me that there are approx 6K records ready for processing.
Then I run the Service Contracts ASO Queue Migration program which completes normally.
But I noticed that all the records are still sitting in the aso.aq$aso_order_feedback_t table and nothing got moved to oks_reprocessing table.
0