Lease and Finance Management - EBS (MOSC)

MOSC Banner

Warranty Contract Creation from Order Management while upgrading to R12

edited Jun 20, 2013 12:44AM in Lease and Finance Management - EBS (MOSC) 4 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center