ORA-00904: "MASTER_QUOTE_YN" Invalid identifier error when opening the Service Contract

(Doc ID 2266962.1)

Last updated on MAY 22, 2017

Applies to:

Oracle Service Contracts - Version 12.1.3 and later
Information in this document applies to any platform.


After applying the patch 23713847:R12.OKS.B (Oracle Service Contracts Recommended Patch Collection (June. 2016))When attempting to Open a Contract the following error occurs.

ORA-00904: "MASTER_QUOTE_YN" Invalid identifier

The issue can be reproduced at will with the following steps:
1. (R) Service Contracts Manager
2. (N) Contracts Administration-->Launch Contracts
3.select Contract and click on Open below error thrown

ORA-00904: "MASTER_QUOTE_YN" Invalid identifier

4.Contact details screen is empty.




Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms