Service Contracts Version History Throws Error, ORA-00904: “SUBSCRIPTION_OWNER”: Invalid Identifier When Accessing The Lines (Doc ID 3071377.1)

Last updated on FEBRUARY 14, 2025

Applies to:

Symptoms

   When attempting to open Contract Versions from the history tab of the Execution form and navigate to the Lines tab,
the following error is thrown


"ORA-00904: "SUBSCRIPTION_OWNER": invalid identifier"

The issue can be reproduced at will with the following steps:
1. Service Contracts (R)
2. In the Search Templates and Contracts form, search for and select Contract with versions
3. Double click on the selected contract to open the Execution form and navigate to History tab
4. Select Contract Versions from the Select dropdown and then select the Open button
5. Click on the Lines tab when Lines are not displayed but the reported error is thrown

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.