Volume Offer Creation Giving Error - PL/SQL : Cursor Already Open In Package OZF_OFFER_PUB Procedure Process_vo

(Doc ID 2286073.1)

Last updated on JULY 14, 2017

Applies to:

Oracle Trade Management - Version 12.2.5 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.


On : 12.2.5 version, Offers

When volume offer is created using Public API - OZF_Offer_PUB.process_vo and patch 24739519:R12.OZF.C is not applied, then offer is created successfully.

After application of <patch 24739519:R12.OZF.C>, it is ending with error.

Error E-API API Error: ~ p_modifier_line_tbl.COUNT :0 ~ Invalid MARKET_OPTION is passed. ~ ORA-06511: PL/SQL: cursor already open in Package OZF_OFFER_PUB Procedure process_vo




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