How do I find the original subscription for a renewed subscription?

To find the original subscription for a renewed one, go to the SQL prompt and use the following SQL query: Select SOURCE_SUBSCRIPTION_ID,TARGET_SUBSCRIPTION_ID,OPERATION_CODE from OSS_OPERATION_LINKS.

You can also change the SQL query to get other details, such as subscription number, subscription product details, subscription dates, and so on. For more information on subscription operation links, see the OSS_OPERATION_LINKS table, in the Tables and Views for Sales and Fusion Service guide.