My Oracle Support Banner

Ora-01001 Invalid Cursor When Trying to Create a Quote (Doc ID 2704805.1)

Last updated on FEBRUARY 11, 2021

Applies to:

Oracle Quoting - Version 12.2.7 and later
Information in this document applies to any platform.


When attempting to create a quote, an user gets the following error message :


APP-236066: The columns PRICE_LIST_ID has an invalid value 5915715
APP-236138: Error returned in ASO_QUOTE_HEADRES_PVT.Update_quote.
APP-236139: ORA-01001 invalid cursor

They can't create a quote on the last day of the month due to this error.

The issue can be reproduced at will with the following steps:
1. Try to create a quote on the last day of the month OR for testing purposes end dated price list with the end date today
2. Go to Quoting and try to create a quote .
3. Get the error

The issue has the following business impact:
Due to this issue, users cannot create quotes in the last day of the month.


To view full details, sign in with your My Oracle Support account.

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

In this Document

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